Nagios Support Forum

Hi,

I found out there are a lot of mysqld-bin.xxxxxx under /var/lib/mysql/ folder. The file name are mysqld-bin.000001 ~ 000499. And most of the file size is 1.1 GB.

How those file are created? I want to know that those are what kind of files? And can we delete? If I can delete, what kind of side effect can be happen?

Thanks.

Those are mysql binary log files, you can read more about them and how to manage them here: http://serverfault.com/questions/82093/ ... -to-remove

But do not delete them by hand, you need to use the mysql query to do it.

ssax wrote:Those are mysql binary log files, you can read more about them and how to manage them here: http://serverfault.com/questions/82093/ ... -to-remove

I tried to solve this issue mention in this link.
First I login to mysql and run the following command. But it seems all of the old mysql binary files haven't delete. So I restart the mysqld service. And I noticed SET GLOBAL expire_logs_days become from 7 to 0 after I restart the service.
So I backup the my.cnf file and add the SET GLOBAL expire_logs_days=7 manually. After I restart the msyqld service, all of the old mysql binary file has been deleted.

Interesting..., so setting the value directly in mysql didn't work, but setting it in the my.cnf did. In any case, I am glad the issue has been resolved! I am locking this topic.