Hello Stephen, Did u try this ??
mysql> show global variables like '%log_output%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | log_output | FILE | +---------------+-------+ If only the log_output is FILE, then the slow queries will get logged in the log. mysql> set global log_output = FILE; [if you find log_output as TABLE or NONE] Let me know if you have any issues... Cheers, Anirudh Sundar On Fri, May 7, 2010 at 10:34 PM, Stephen Sunderlin < stephen.sunder...@verizon.net> wrote: > 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! > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=sundar.anir...@gmail.com > >
