List:General Discussion« Previous MessageNext Message »
From:Stephen Sunderlin Date:May 7 2010 5:04pm
Subject:log-slow-queries
View as plain text  
Can't get slow querys to log.  Does this not work in myisam?

*snip*
[mysqld]
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
*snip*

restarted mysqld  - no log.

Created in file in /var/log/mysql/

*snip*
-rwxr--r-- 1 mysql mysql 0 May  7 10:33 mysql-slow.log
*snip*

still not writing to the file

I've read
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
http://www.mydigitallife.info/2007/01/22/enable-logging-of-slow-queries-slow-query-log-in-mysql-database/


looks pretty simple -  not sure what I'm missing.

Thanks!


Thread
log-slow-queriesStephen Sunderlin7 May
  • Re: log-slow-queriesmos7 May
    • Re: log-slow-queriesmos7 May
  • Re: log-slow-queriesAnirudh Sundar8 May