Karakas Online

25.8. How to proceed when MySQL is slow

It is of course too general a complain to say "MySQL is slow! What is wrong with my pages?", but nonetheless, there exist a couple of things you can check if this happens to you (see slow page load and mysql errors):

Tip Large Slow Query Logs

The slow query log can be used to find queries that take a long time to execute and are thus candidates for optimization . With a large log, that can become a difficult task. You can pipe the slow query log through the mysqldumpslow command to get a summary of the queries which appear in the log.

Last updated Sun Aug 7 21:14:12 CEST 2005 Permalink: http://www.karakas-online.de/EN-Book/proceed-when-mysql-slow.html All contents © 2004 Chris Karakas, Claudio Erba