Andy posted some very good links recently to video’s on how to optimize your web site. Although I spend more time optimizing the database you always have to go where the actual performance is lost. For MySQL the place to check for performance issues is the slow query log which I have mentioned in earlier [...]
Extending the slow query log
February 4th, 2009 · No Comments
Tags: MySQL · Performance
Enabling and using the slow query log in MySQL
August 26th, 2008 · 2 Comments
By special request here is a post about the MySQL slow query log. MySQL has a wonderful feature that lets you keep track of all queries that took longer than a certain time to complete. To enable it simply add the following line to your my.cnf file:
log-slow-queries = [path to the log file]
Secondly it is [...]
Tags: MySQL · Performance
