MySQL Slow Query Log File

February 17, 2005
databases

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


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

Comments

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.

Andrew
http://www.tv-links.eu
You'd think they'd mention this on this page in the manual, but I don't see it:

http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html

Thanks!

Post a Comment




  



Spell Checker by Foundeo

Recent Entries



foundeo


did you hack my cf?