mysql5.6版本以上,取消了参数log-slow-queries,更改为slow-query-log-file
还需要加上 slow_query_log = on 否则,还是没用
log-slow-queries = /var/log/mysql/mysql-slow.log
slow_query_log = on
slow-query-log-file = /var/log/mysql/mysql-slow.log
long_query_time = 2
原文
mysql 5.7 unknown variable ‘log_slow_queries=/var/log/mysql/mysql-slow.log’这里写链接内容
mysql5.6版本以上,取消了参数log-slow-queries,更改为slow-query-log-file
还需要加上 slow_query_log = on 否则,还是没用
log-slow-queries = /var/log/mysql/mysql-slow.log
slow_query_log = on
slow-query-log-file = /var/log/mysql/mysql-slow.log
long_query_time = 2
原文
mysql 5.7 unknown variable ‘log_slow_queries=/var/log/mysql/mysql-slow.log’这里写链接内容