Salesforce interview question

How does MySQL replication work? What tuning variables affect MySQL? How do you determine why a SQL query is taking a long time to run? How do you skip major version upgrades with as little downtime as possible? What status variables tell you if the buffer pool is thrashing?