Quick and Dirty MySQL Performance Troubleshooting

32
Article Source Linux Magazine
August 17, 2009, 6:50 am

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…?

Read More