Enable mysql slow_query_log on the fly, no reboot required
I always forget how to do this, so finally decided to write it down (I’m talking about mysql 5.1):
- Login to mysql with administrator rights
-
Inspect current variables before changing those (optional):
mysqlshow variables like 'long_query_time' \G; ...