Search code examples
mysqlmy.cnfmysql-slow-query-log

mysql 5.7 log-slow-queries error

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,

Solution

  • 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

    MySQL Reference Manual: sysvar_slow_query_log_file

    MySQL Reference Manual: sysvar_slow_query_log