mysql 5.7 log-slow-queries error

mysql my.cnf mysql-slow-query-log
Alby picture Alby · Apr 27, 2016 · Viewed 22.1k times · Source

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,

Answer

Evgeniy Tkachenko picture Evgeniy Tkachenko · Sep 2, 2016

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

Related questions

Why does `log_slow_queries` break `my.cnf`?

Why can't I use slow_query_log on MySQL 5.6 on CentOS 6.4? [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock ... ## Logging ## *** THESE LOGS WORK JUST FINE *** log_error = /var/log/mysql/error.log general_log_file = /var/log/…

Read More
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root

I am not sure how to fix this: dyn-72-33-214-45:python mona$ sudo /usr/local/mysql/bin/mysqld stop 2014-09-06 09:49:04 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see …

Read More
MySQL my.cnf performance tuning recommendations

I am kind of hoping that someone might be able to offer some assistance with optimizing a my.cnf file for an extremely high volume mysql database server. Our architecture is as follows: Memory : 96GB CPUs : 12 OS & Mysql : 64-bit …

Read More