At the risk of stating the obvious, you might want to check the query plans on your most common mySql queries, to make sure that all the appropriate indexes are

At the risk of stating the obvious, you might want to check the query plans on your most common mySql queries, to make sure that all the appropriate indexes are in place and in use. I've not done this with mySql myself, but this looks like it might be useful: http://www.learn-mysql-tutorial.com/OptimizeQueries.cfm http://www.learn-mysql-tutorial.com/OptimizeQueries.cfm