MySQL log slow queries

edit /etc/my.cnf


# vi /etc/my.cnf

Then add

long_query_time = 5

Long_query_time is the number of seconds for a query to be considered long enough to log. The log will be created with detailed information about the queries that are slower than 5 seconds (in this case) for MySQL.

The default location of this log is



I am a g33k, Linux blogger, developer, student and Tech Writer for My passion for all things tech drives my hunt for all the coolz. I often need a vacation after I get back from vacation....

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.