MySQL Slow Query Log File

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?

Trackbacks

Trackback Address: 233/AEB5F2A8AEF38EEEC2701EFE0F9EEFA6

Comments

On 10/02/2006 at 2:05:16 PM EDT Rolando wrote:
1
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

On 03/15/2010 at 9:21:56 AM EDT Andrew wrote:
2
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

On 03/29/2010 at 4:03:32 AM EDT Daniel W wrote:
3
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?