1.查看binlog日志

mysql> show binary logs;+------------------+------------+ | Log_name | File_size | +------------------+------------+ | mysql-bin.000061 | 50624 | | mysql-bin.000062 | 5159 | | mysql-bin.000063 | 126 | | mysql-bin.000064 | 3067 | | mysql-bin.000065 | 503 | | mysql-bin.000066 | 494 | | mysql-bin.000067 | 107 | | mysql-bin.000068 | 1433 | | mysql-bin.000069 | 7077 | | mysql-bin.000070 | 107 | | mysql-bin.000071 | 804 | | mysql-bin.000072 | 7642 | | mysql-bin.000073 | 2198 | | mysql-bin.000074 | 350139 | | mysql-bin.000075 | 126 | | mysql-bin.000076 | 51122 | | mysql-bin.000077 | 1074279197 | | mysql-bin.000078 | 1074435879 | | mysql-bin.000079 | 928917122 | +------------------+------------+

2.刪除某個日志文件之前的所有日志文件

mysql> purge binary logs to 'mysql-bin.000079'; mysql> show binary logs;+------------------+-----------+ | Log_name | File_size | +------------------+-----------+ | mysql-bin.000079 | 928917122 | +------------------+-----------+ mysql> reset master; #重置所有的日志

3.關(guān)閉mysql的binlog日志

#log-bin=mysql-bin 在my.cnf里面注釋掉binlog日志重啟mysqlservice mysqld restart

?

轉(zhuǎn)?https://www.cnblogs.com/love123/p/6898568.html

?

總結(jié)

以上是生活随笔為你收集整理的Mysql清理binlog日志的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。