The slow-log tag has no wiki summary.
3
votes
3answers
1k views
MySQL slow log configuration
Is there a way of making MySQL slow logs to start new log file every day ?
At the moment its just a single large file, and have to grep lines for every day. It would be much more convenient to have ...
1
vote
1answer
524 views
Transaction Lock Timeouts When Updating a Row
I'm trying to determine the cause of an InnoDB transaction lock timeout. This one is very strange in that it appears to be a deadlock error instead - nonetheless, here's the output of my slow log ...
1
vote
1answer
696 views
MySQL flush logs, unknown error
I gave been trying to solve this for few days now, and cant seem to figure this out.
I have been trying to set log rotation for mysql slow using linux logrotate feature, and my script seems to get ...
2
votes
1answer
60 views
Slow Queries Not Logging
I am attempting to enable slow query logging on our server in order to identify any queries that could use optimization. Sounds simple enough, however my file is not being written to. I get no errors ...
0
votes
2answers
170 views
How often does the slow_log table get updated in MySQL?
I've changed the long_query_time from 10 secs to 5 secs. I haven't seen any queries logged for a few hours now. Am I supposed to tweak my database for the slow_log table to gets updated more often?
...
