2

mysql slow queries?

view story
linux-howto

http://www.linuxquestions.org – 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: Quote: mysqldumpslow slow.log 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 (HowTos)