Difference between revisions of "Enable MySQL’s slow query log without a restart"

From MyWiki
Jump to: navigation, search
(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';