About too many mysql binary logs (12gb)
Today mysql was working bad, looking at the errorlog I realized that the disk was full…. then I see 12gb of binary logs… (some of them from 4 months ago?)
It is a regular mysql, no slave, no replication, etc… just a regular mysql with 3 databases at the moment…
The question is… How many days we need to keep those binary log files? Why are not purged? Do I need to configure something to achieve that?
Best regards!
luciano
3 Replies
mysqldump can be called to backup the db with options –flush-logs and --delete-master-logs so it prunes back the logs.
If you don't need that, turn the binary logging off in the cnf file by commenting out the log_bin setting
Will do the backup thing I guess! it was a thing to do… it is time now