Sample Header Ad - 728x90

Slow Query logging everything

2 votes
2 answers
1273 views
I have a mysql instance that is logging slow queries. I have it set to 1 sec, but I am getting back lots of these:(example) Query_time: 0.000237 Lock_time: 0.000064 Rows_sent: 0 Rows_examined: 109 On another server I get these: Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 Either way they both seem to be logging other queries...or am I reading something wrong? set-variable = log-slow-queries="/tmp/mysql-slow-query.log" set-variable = long_query_time=1
Asked by mike628 (171 rep)
Jul 28, 2011, 06:16 PM
Last activity: Dec 31, 2021, 12:16 AM