mysql: 10 Tips for Optimizing MySQL Queries (That don’t suck)
The very first thing you should do is turn on the MySQL slow query log and install mtop. This will give you access to information about the absolute worst offenders. Have a ten-second query ruining your web application? These guys will show you the query right off.
Link tagged as: