Re: Slow log logs non-slow statements

2006-08-15 Thread Jay Pipes
It is likely you are also logging any queries not using an index (doing full table scans). Check the configuration variable: log_long_format Cheers, Jay On Tue, 2006-08-15 at 14:45 +0200, Dominik Klein wrote: > I have specified > > log-slow-queries > long-query-time=10 > > in my.cnf and restar

Slow log logs non-slow statements

2006-08-15 Thread Dominik Klein
I have specified log-slow-queries long-query-time=10 in my.cnf and restarted my server. After that I see statements logged into the slow-log-file. But it seems that mysql logs too much into that file. When executing this statement: mysql> show variables like "%tx%"; +---+---