Peter at MySQL Performance Blog pointed out this sweet perl script to analyze MySQL’s slow query logs. (This is supposedly a PHP port.)
The script does a good job of aggregating similar queries (those that only differ in their query values) and displaying overall stats for them. The following two queries are showing up a lot [...]

Posted March 17, 2009 by Casey Bisson
Categories: Dispatches. Tags: mysql, optimization, performance, slow query log. Be the first one.

Zach suggested it last week, but it’s only now that I’ve gotten around to setting up MySQL’s slow query log.
It’s easy enough, you’ve just got to put a couple lines like this in your my.cnf (which is in /etc on my server):
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 10
This should get most people running, but this story in [...]

Posted February 13, 2006 by Casey Bisson
Categories: Technology. Tags: high performance mysql, mysql, mysql optimization, performance optimization, query optimization, slow queries, slow query log. One Comment.