Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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,

like image 644
Alby Avatar asked Apr 27 '16 15:04

Alby


1 Answers

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
like image 76
Evgeniy Tkachenko Avatar answered Sep 20 '22 18:09

Evgeniy Tkachenko