MySQL Slow Log Missing SQL statements
I use pingdom to do basic monitoring of my website and have been noticing a steady march upward for response time. I assume the issue is with my database, so I went to look at my the mysql-slow.log file and see the same three lines repeated with no SQL statements; not exactly helpful.
/usr/sbin/mysqld, Version: 5.1.41-3ubuntu12.6-log ((Ubuntu)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
Here is a snippet from the my.cnf file:
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes
I have just tried changing permissions on the files and directory and restarted mysql with no luck. I still am getting new additions to the mysql-slow.log file, but nothing useful. My current permissions are:
:/var/log/mysql$ ls -al
total 31772
drwxrws--- 2 mysql mysql 4096 Aug 26 06:25 .
drwxr-xr-x 7 root root 4096 Aug 26 06:25 ..
-rw-rw---- 1 mysql mysql 32193324 Aug 27 02:12 error.log
-rw-rw---- 1 mysql mysql 125493 Aug 27 02:11 mysql-slow.log
Any suggestions for what I am missing?
Thanks, Josh
2 Replies
SELECT SLEEP(3);
and see if it shows up in the log.
I also noticed that this log file was rotated and the group reverted back to be "adm" instead of the "mysql" group I changed it to yesterday. Could this be part of the issue?
-rw-r----- 1 mysql adm 107793 Aug 27 23:21 mysql-slow.log
Thanks, Josh