Home > mysql > Enable MySQL Slow Query Logging Without Server Restart

Enable MySQL Slow Query Logging Without Server Restart

February 7th, 2012 Leave a comment Go to comments

When mysql stops responding…  You can usually bet on finding slow queries to be the culprit.

You can easily enable slow query logging without restarting the server.

Just run:

set global log_slow_queries = ON

Be Sociable, Share!
Categories: mysql Tags:
  1. No comments yet.
  1. No trackbacks yet.