Difference between revisions of "Enable MySQL’s slow query log without a restart"
From MyWiki
(Created page with "Log on to mysql as root <br> Set the log-file location for the Slow Query log. Make sure mysql has write permission. mysql> SET GLOBAL slow_query_log_file = '/path/to/slow_qu...") |
(No difference)
|
Revision as of 08:36, 18 May 2016
Log on to mysql as root
Set the log-file location for the Slow Query log. Make sure mysql has write permission.
mysql> SET GLOBAL slow_query_log_file = '/path/to/slow_query.log';