Is it safe to delete mysql-bin files?
152
votes
4
answers
262785
views
I have MM Replication in mysql, and I want to squeeze some free space in the box be deleting unnecessary files, I came across these
mysql-bin
files inside /var/db/mysql/
There are hundreds of those files like mysql-bin.000123
, mysql-bin.000223
etc. I have checked the mysql replication by doing show master status
and show slave status
they are using some mysql-bin files at certain positions, but I guess all the other bin files are **leftovers** which will not be used anymore. In this case is it safe to delete all those mysql-bin files except the ones that replication is currently pointing at ?
If it is safe to delete, then is there anything I could do to **automatically** delete those files once they are not in use ?
Asked by user18530
Apr 26, 2013, 08:56 PM
Last activity: Jan 5, 2024, 10:51 AM
Last activity: Jan 5, 2024, 10:51 AM