mercredi 7 janvier 2015

Is this normal binary logging behaviour - maintaining one ever growing file despite expire_logs_days?


I have a Percona MySQL DB running on a dedicated server.


I have in my.cnf



# REPLICATION #
log_bin=/var/lib/mysql/binlogs/mysql-bin
expire_logs_days=7


My issue is that the log file mysql-bin.000001 is ever growing in size.


I'm not sure if the expected behaviour is for it to start a new file each day on 7 day rotation, or to "trim from the top", but it doesn't seem to be doing either, as it's the only file been created and continues to grow in size beyond the 7 day boundary.


Any advice or clarification is much appreciated.





Aucun commentaire:

Enregistrer un commentaire