mysql数据库binlog日志太大的清理方法[主从清理，待续]

r囧r小猫 2022-11-21 09:43 418阅读 0赞

mysql数据库binlog日志太大的清理方法

1.查看binlog日志

![复制代码][a4c26d1e5885305701be709a3d33442f.png]

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 |
    
    +------------------+------------+

![复制代码][a4c26d1e5885305701be709a3d33442f.png]

2.删除某个日志文件之前的所有日志文件

![复制代码][a4c26d1e5885305701be709a3d33442f.png]

mysql> purge binary logs to 'mysql-bin.000079';

![复制代码][a4c26d1e5885305701be709a3d33442f.png]

3.关闭mysql的binlog日志

#log-bin=mysql-bin  在my.cnf里面注释掉binlog日志
    #binlog_format=mixed 
    #server-id = 1 
    #expire_logs_days = 10
    
    重启mysql
    service mysqld restart

[a4c26d1e5885305701be709a3d33442f.png]: /images/20221120/419845531a664fb08279e145eabc46b4.png