MySQL Restart slow query log

[Warning] '--log_slow_queries ' is deprecated and would be removed in a future release. Please use '--slow_query_log '/'--slow_query_log_file ' instead.


1. Modify the configuration file

[Mysqld]
Datadir=/var/lib/mysql
Socket=/var/lib/mysql/mysql.sock
User=mysql
Slow_query_log #注意后面没有 "=on"
Slow_query_log_file=/var/lib/mysql/mysqld-slow.log #指定日志文件存放位置, default is/var/run/mysqld/mysqld-slow.log



2. When the service starts, modify the global variables, you can temporarily open the slow log

Set global slow_query_log=on; #这里要加上 "=on"

Set global slow_query_log_file = '/var/lib/mysqld/mysqld-slow.log '; #注意路径要加上引号, or you'll get an error.

MySQL Restart slow query log