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]