They are taking up too much space:
/var/lib/mysql/jiaoyou-slow.log: 53M /var/lib/mysql/mysql-bin.000005: 68M /var/lib/mysql/mysql-bin.000003: 1.1G /var/lib/mysql/mysql-bin.000007: 34M /var/lib/mysql/mysql-bin.000004: 225M
migrated from stackoverflow.com Nov 6 '09 at 7:51
This question came from our site for professional and enthusiast programmers.
There are a few reasons to use binary logging. In order of importance:
So there are three things to check before you delete any binary logs:
If you are happy with the answers to all of those then go ahead and delete them with the
A much better approach, as kedar notes, is to use
no, you not should delete them by hand there is a command to remove them, if delete them mysql would crash. the command is:
see here for more information.
you may also use expire_logs_days http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html
In Ubuntu 12.04
PURGE BINARY LOGS
Add this line to your /etc/mysql/my.cnf and it'll need to be in the [mysqld] section.
expire_logs_days = 7
Then log into Mysql and run this command to set the variable without having to restart Mysql.
SET GLOBAL expire_logs_days=7;