MySQL Flush Logs
 

After logrotate ran through the cron job and rotated my mysql.log file, I see that it has zero size. I logged in and did a couple queries, and still the log has zero size. I supposed that probably after rotation that the logs were not flushed. So I flushed them, and still nothing.

This is what I have in /etc/my.cnf
log=/var/log/mysql/mysql.log

I used this command to flush:
### > mysqladmin -u root -p<pw> flush-logs

Status:
-rw-rw---- 1 mysql mysql 0 Nov 26 16:20 mysql.log

The only thing that works is to restart the server, which I do not want to do. Is a cheap hack to get this to work.

Any thoughts or ideas on why flush-logs doesn't seem to be working correctly?

Thanks...

check what the log level is, generally logs are only recorded when there is an error.
you would need to set a loglevel of debug or something of that sort.