首页 > Linux系统管理 > Mysql清理binlog日志
2018
09-06

Mysql清理binlog日志

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.关闭mysql的binlog日志

#log-bin=mysql-bin  在my.cnf里面注释掉binlog日志
 
重启mysql
 
service mysqld restart
最后编辑:
作者:saunix
大型互联网公司linux系统运维攻城狮,专门担当消防员