当MySQL数据库的binlog日志过大时，可以通过查看binlog日志、删除旧日志、重置所有日志和关闭binlog功能来清理。首先使用`show binary logs`检查当前binlog状态，然后通过`purge binary logs to`删除指定之前的日志，使用`reset master`重置所有日志，最后可选择在配置文件中注释掉`log-bin=mysql-bin`来关闭binlog功能并重启MySQL服务。
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
扫一扫
1376
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
