MySQL Slow Query Log File

February 17, 2005

MySQL has a feature that allows you to log slow running queries to a file. To enable you just need to add some lines to your my.cnf file, and restart. Add the following:

log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1

The above will log queries taking longer than one second to the specified log file.

You can read more in the MySQL Reference Manual

23 people found this page useful, what do you think?


Regards.. I need catch all id and message avents (1064 You have a error in your SQL syntaxis) from MySQL database, because in the log, log-error the messages is not very good description.. Thanks, Rolando
Thank you for this. I was looking for a way to debug mysql as I've been having some problems.

You'd think they'd mention this on this page in the manual, but I don't see it:


Recent Entries


did you hack my cf?