Slow log not working
I'm trying to get the slow log working on 5.5, and I'm pulling my hair out. I've set every parameter thinkable. It simply dumps out some startup header information but doesn't log anything. Here are the variables I have set:
log_slow_filter=''
log_slow_queries=ON
log_slow_rate_limit=1
slow_query_log=ON
slow_query_log_file=slow.log
long_query_time=0.00000
log_output=FILE
I've set all these and restarted the instance. I test it by running several queries but absolutely nothing gets written to the slow log. The slow.log file gets created with simple header info like "MySQL starting up", but no queries get logged there.
What am I missing?
Subject
Views
Written By
Posted
Slow log not working
2277
November 24, 2012 08:11AM
1250
November 25, 2012 02:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.