MySQL: how to enable Slow Query Log?
- by Continuation
Can you give me an example on how to enable MySQL's slow query log?
According to the doc:
As of MySQL 5.1.29, use
--slow_query_log[={0|1}] to enable or disable the slow query log, and
optionally
--slow_query_log_file=file_name to specify a log file name. The
--log-slow-queries option is deprecated.
So how do I use that option? Can I put it in my.cnf? An example would be greatly appreciated.
Thank you very much