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,
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With