pf » MySQL Slow Query Log File

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


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

Trackback Address: 233/AEB5F2A8AEF38EEEC2701EFE0F9EEFA6
On 10/02/2006 at 12:05:16 PM MDT 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




  



Spell Checker by Foundeo





Subscribe to my RSS Feed: solosub RSS
Tags