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

Permalink | Add Comment |

add to del.icio.us

23 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

by Rolando on 10/02/2006 at 12:05:16 PM UTC

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

by Andrew on 03/15/2010 at 7:21:56 AM UTC

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!

by Daniel W on 03/29/2010 at 2:03:32 AM UTC

MySQL Slow Query Log File

Comments

Recent Entries