Hi!

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

Are you backing up the database? Binary logs also serve to keep a record of what's changed since the last backup so you can do a point in time recovery between backups.

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

Thanks for the advices vickd!

Will do the backup thing I guess! it was a thing to do... it is time now

You can also set up expire_logs_days to clean out logs for you
http://dev.mysql.com/doc/refman/5.0/en/ ... _logs_days

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue