Re: log-slow-queries

2010-05-07 Thread Anirudh Sundar
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 my

Re: log-slow-queries

2010-05-07 Thread mos
*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

Re: log-slow-queries

2010-05-07 Thread mos
At 12:04 PM 5/7/2010, Stephen Sunderlin wrote: Can't get slow querys to log. Does this not work in myisam? Sure it does. Have you tried: slow_query_time = 1 Mike *snip* [mysqld] log-slow-queries = /var/log/mysql/mysql-slow.log long_query_time = 1 *snip* restarted mysqld - n

log-slow-queries

2010-05-07 Thread Stephen Sunderlin
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*