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
Last activity: Dec 31, 2021, 12:16 AM