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 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%"; > +---------------+-----------------+ > | Variable_name | Value | > +---------------+-----------------+ > | tx_isolation | REPEATABLE-READ | > +---------------+-----------------+ > 1 row in set (0,00 sec) > > it immediately shows up in the slow-log: > > # Time: 060815 14:40:22 > # [EMAIL PROTECTED]: root[root] @ localhost [] > # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 > show variables like "%tx%"; > > This is also true vor simple select statements which give a result in > (0,00 sec). > > How can I make mysql log only those slow queries, that are "really" slow. > > Thanks in advance > Dominik > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
