This is the relevant section from
[mysqld] slow-query-log = ON long_query_time = 2 log_slow_queries = /var/log/mysql-slow.log
The problem is that file is missing and even if I
touch it , nothing get written there.
I've tried changing the log location to
$datadir/mysql-slow.log and in the
/etc/my.cnf file it looks like this:
log_slow_queries = mysql-slow.log
I've forgot to mention that the user and owner of the
mysql-slow.log file are mysql.
But it doesn't work as well, any idea how to fix it?
[root@dbsrv ~]# grep slow /etc/my.cnf slow-query-log = ON log_slow_queries = /var/log/mysql/mysql-slow.log slow-query-log = ON log_slow_queries = /var/log/mysql/slow.log [root@dbsrv ~]# ll /var/log/mysql/slow.log ; ll /var/log/mysql/mysql-slow.log -rwxrwxrwx 1 mysql mysql 0 2014-02-04 18:23 /var/log/mysql/slow.log -rwxrwxrwx 1 mysql mysql 0 2014-02-04 18:23 /var/log/mysql/mysql-slow.log [root@dbsrv ~]#
Thanks in advance