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...
|