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
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%";
+---+---