MySQL continues using the old file for logging, after mysql slow log is rotated in Red Hat Enterprise Linux 5
Issue
- After the weekly MySQL log rotation, the mysqld continues to write logs to the recently deleted file rather than using the new log.
$ grep slow lsof-mysqld-after.log
mysqld 24867 mysql 44u REG 253,2 328721 655422 /var/lib/mysql/mysqld-slow.log.1 (deleted)
Environment
Red Hat Enterprise Linux 5
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
