Quick and Dirty MySQL Performance Troubleshooting

Sooner or later, you‚Äôre going to get that phone call (or email, SMS, instant message, tweet, or whatever): The database is slow! Fix ASAP! And you‚Äôll be expected to very quickly figure out what‚Äôs slowing things down‚Äìoften wither very little context, background, or sense of what may have changed recently at the application layer.

It‚Äôs just a server. How hard could it be?

Well, as we all know ‚Äúthat depends.‚Äù It depends on a lot of things that you likely have little time to investigate in the middle of a crisis. So where should you focus your time and attention...?