Delete MySQL binary log specific method

Server 120G SSD hard disk space used 92%, after inspection found that the original MySQL binary log is not in time to remove, occupy a lot of space, so directly with the command: Reset master a delete clean.

The code is as follows	Copy Code
Reset Master

If the database on the MySQL server is replication, do not use the command, but should use: Purge binary logs command. Purge is more moderate and usually has two ways of doing it:

The code is as follows	Copy Code
Purge binary logs to ' mysql-bin.010 '; Purge binary logs before ' 2012-05-02 22:46:26 ';

Remove MySQL binary log, there is a more convenient way, just add in the My.cnf/ini Expire_logs_days=3,mysql will only keep the last 3 days of the log, not always bother to reset.

code is as follows	copy code
1 expire_ logs_days=3