删除全部binlog不影响数据库运行,类似Oracle的archivelog

最新推荐文章于 2025-06-02 08:00:00 发布

scan724

最新推荐文章于 2025-06-02 08:00:00 发布

阅读量1.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： Mysql

本文链接：https://blog.youkuaiyun.com/zhaoyangjian724/article/details/46330223

Mysql 专栏收录该内容

90 篇文章 ¥39.90 ¥99.00

订阅专栏

本文展示了如何在MySQL中删除所有binlog文件，并在重启服务后，数据库仍能正常运行。通过`rm -rf *`命令清空binlog目录，然后重启MySQL服务，新的binlog文件将被创建，表明数据库运行未受影响。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

v-lhb-db03:/data01/mysqllog/binlog# ls
mysql-bin.000002  mysql-bin.000003  mysql-bin.000004  mysql-bin.000005  mysql-bin.000006  mysql-bin.index
v-lhb-db03:/data01/mysqllog/binlog# rm -rf *
v-lhb-db03:/data01/mysqllog/binlog# ls
v-lhb-db03:/data01/mysqllog/binlog# service mysql restart
Shutting down MySQL...                                     [  OK  ]
Starting MySQL.                                            [  OK  ]
v-lhb-db03:/data01/mysqllog/binlog# ls
mysql-bin.000001  mysql-bin.index
v-lhb-db03:/data01/mysqllog/binlog# ls
mysql-bin.000001  mysql-bin.index
v-lhb-db03:/data01/mysqllog/binlog# cat mysql-bin.index 
/data01/mysqllog/binlog/mysql-bin.000001