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 of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.