I've set this value on my my.cnf:
Quote:
log_slow_queries = /var/log/mysql/slow.log
long_query_time = 3
log-queries-not-using-indexes
|
If I type:
I see lots of query like this:
Quote:
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (1), root[root]@localhost
SELECT COUNT(*) FROM `roundcubemail`.`cache`
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=5.0 (5), ulog[ulog]@localhost
SELECT * FROM ulogd.output
Count: 4 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), debian-sys-maint[debian-sys-maint]@localhost
SELECT COUNT(*) INTO @discard FROM `information_schema`.`TRIGGERS`
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), ulog[ulog]@localhost
CREATE TEMPORARY TABLE ulogd.output AS SELECT * FROM ulogd.allrows LIMIT N, N
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (1), root[root]@localhost
SELECT COUNT(*) FROM `roundcubemail`.`contactgroupmembers`
|
why? The time is < than 3 seconds...