The binary log has two important purposes:

  • Data Recovery : It may be used for data recovery operations. After a backup file has been restored, the events in the binary log that were recorded after the backup was made are re-executed. These events bring databases up to date from the point of the backup.
  • High availability / replication : The binary log is used on master replication servers as a record of the statements to be sent to slave servers. The master server sends the events contained in its binary log to its slaves, which execute those events to make the same data changes that were made on the master.

Disable MySQL binlogging if you are not replicating, you can disable binlogging by changing your my.ini or my.cnf file. Open your my.ini or /etc/my.cnf (/etc/mysql/my.cnf), enter:
# vi /etc/my.cnf

Find a line that reads “log_bin” and remove or comment it as follows:
#log_bin = /var/log/mysql/mysql-bin.log

You also need to remove or comment following lines:
#expire_logs_days = 10 #max_binlog_size = 100M

Close and save the file. Finally, restart mysql server:
# service mysql restart

Purge Master Logs If you ARE replicating, then you need to periodically RESET MASTER or PURGE MASTER LOGS to clear out the old logs as those files are necessary for the proper operation of replication. Use following command to purge master logs:
$ mysql -u root -p ‘MyPassword’ -e “PURGE BINARY LOGS TO ‘mysql-bin.03’;”
OR
$ mysql -u root -p ‘MyPassword’ -e “PURGE BINARY LOGS BEFORE ‘2008-12-15 10:06:06’;”

Delete MySQL Binary Logs
mysql> PURGE BINARY LOGS BEFORE NOW() – INTERVAL 3 DAY;
DELETE ALL bin files before 3 DAYS! or
PURGE MASTER LOGS BEFORE ‘2010-10-08 00:00:00’;

References:
http[:]//www[.]cyberciti[.]biz/faq/what-is-mysql-binary-log/
http[:]//stackoverflow[.]com/questions/2989215/is-it-safe-to-delete-rotated-mysql-binary-logs

Tinggalkan Balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *