I'm trying to enable Slow Query Logging on mysql 5.7 and getting this error:
2016-04-27T14:55:51.934612Z 0 [ERROR] unknown variable 'log-slow-queries=/var/log/mysql-query.log'
2016-04-27T14:55:51.934639Z 0 [ERROR] Aborting
In my /etc/my.cnf file I have "log-slow-queries=/var/log/mysql-query.log" defined, but I'm going to assume that in 5.7 that is invalid. What is the correct my.cnf settings to enable query logging?
Thanks,
解决方案
Name of the MySQL system variable is slow_query_log_file
And to enable it, you need to set slow_query_log to ON or 1