14

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,

Alby
  • 426
  • 2
  • 7
  • 17
  • 2
    Version 5.1.29 deprecated that syntax (and some other log syntax); 5.6.1 removed it. What was generating it? – Rick James Apr 30 '16 at 19:20

2 Answers2

29

log-slow-queries is deprecated

See http://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html

# Here you can see queries with especially long duration
slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow-queries.log
long_query_time = 1
Evgeniy Tkachenko
  • 1,733
  • 1
  • 17
  • 23
19

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

Wilson Hauck
  • 2,094
  • 1
  • 11
  • 19
spencer7593
  • 106,611
  • 15
  • 112
  • 140
  • Does slow query also mean "All queries"? My overall goal is to enable logging of all queries, yet all I see are comments about slow queries. There isn't some other flag for enabling all queries, is there? – Alby Apr 27 '16 at 18:21
  • The **`general_log`** can log everything. And it can grow really fast. We only enable it temporarily for debugging. Reference: [**http://dev.mysql.com/doc/refman/5.7/en/query-log.html**](http://dev.mysql.com/doc/refman/5.7/en/query-log.html) – spencer7593 Apr 27 '16 at 19:51
  • 1
    Have many awnsers in Stackoverflow using `log-slow-queries` to set the path... Thank you for the anwser. – Inkeliz Aug 29 '16 at 21:26