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.