如何删除mysql-bin.0000X 日志文件

最新推荐文章于 2024-09-14 19:55:29 发布

D_SJ

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量452

点赞数

文章标签：数据库开发工具

原文链接：https://yq.aliyun.com/articles/477182

版权

一、数据库版本

Server version: 5.1.40

二、进入数据库

[root@kt01 ~]# mysql -uroot -p
Enter password: 输入密码
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31114
Server version: 5.1.40-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

2、查看日志文件

mysql> show master logs;
+------------------+-----------+
| Log_name         | File_size |
+------------------+-----------+
| mysql-bin.000063 | 12572632 |
| mysql-bin.000064 |    116575 |
| mysql-bin.000065 | 11140064 |
| mysql-bin.000066 |   7754187 |
| mysql-bin.000067 |     31984 |
| mysql-bin.000068 |   1019530 |
| mysql-bin.000069 |   2732931 |
| mysql-bin.000070 |    308131 |
| mysql-bin.000071 | 12101585 |
| mysql-bin.000072 |      1655 |
| mysql-bin.000073 | 26374833 |
| mysql-bin.000074 | 17866915 |
| mysql-bin.000075 |       125 |
| mysql-bin.000076 |     77987 |
| mysql-bin.000077 |     71104 |
| mysql-bin.000078 |       125 |
| mysql-bin.000079 |       125 |
| mysql-bin.000080 |       125 |
| mysql-bin.000081 |     62067 |
| mysql-bin.000082 |       106 |
| mysql-bin.000083 |       106 |
| mysql-bin.000084 |       106 |
| mysql-bin.000085 |    214510 |
| mysql-bin.000086 |      2188 |
| mysql-bin.000087 |       125 |
| mysql-bin.000088 |   8736376 |
| mysql-bin.000089 |       149 |
| mysql-bin.000090 |     15818 |
+------------------+-----------+
28 rows in set (0.00 sec)

3、清除日志文件

mysql> reset master;
Query OK, 0 rows affected (0.51 sec)

三、修改my.cnf配置文件

既然mysql-bin.0000X日志文件占用这么大空间,存在的意义又不是特别大,那么我们就不让它生成吧.

[root@kt01 ~]# vim /etc/my.cnf

我们将log-bin=mysql-bin 这条注释掉即可.

重启下mysql吧.

OK,至此,操作完成. 以后再不会因为就几十M的数据库大小生成N个G的日志文件啦.

本文转自 kuangling 51CTO博客，原文链接:http://blog.51cto.com/kling/1152334