温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

处理删除二进制日志后,show binary logs 显示File_size为0的情况

发布时间:2020-03-25 21:07:12 来源:网络 阅读:1854 作者:莲池管俊涛 栏目:MySQL数据库

服务器硬盘空间占用过大,发现二进制日志文件过多,于是删除mysql的二进制日志文件:

[root@iZbp1b36sef813d0zilqd6Z mysql] # rm -rf dbbin.00010*
[root@iZbp1b36sef813d0zilqd6Z mysql] #  rm  -rf  dbbin.00010*
[root@iZbp1b36sef813d0zilqd6Z mysql] #  rm  -rf  dbbin.00011*
[root@iZbp1b36sef813d0zilqd6Z mysql] #  rm  -rf  dbbin.00012*

然后通过mysql命令行查看:

mysql> show binary logs;
+--------------+------------+
| Log_name     | File_size  |
+--------------+------------+
| dbbin.000001 |          0 |
| dbbin.000002 |          0 |
| dbbin.000003 |          0 |
| dbbin.000004 |          0 |
| dbbin.000005 |          0 |
| dbbin.000006 |          0 |
| dbbin.000007 |          0 |
| dbbin.000008 |          0 |
| dbbin.000009 |          0 |
| dbbin.000010 |          0 |
| dbbin.000011 |          0 |
| dbbin.000012 |          0 |
| dbbin.000013 |          0 |
| dbbin.000014 |          0 |
| dbbin.000015 |          0 |
| dbbin.000016 |          0 |
| dbbin.000017 |          0 |
| dbbin.000018 |          0 |
| dbbin.000019 |          0 |
| dbbin.000020 |          0 |
| dbbin.000021 |          0 |
| dbbin.000022 |          0 |
| dbbin.000023 |          0 |
| dbbin.000024 |          0 |
| dbbin.000025 |          0 |
| dbbin.000026 |          0 |
| dbbin.000027 |          0 |
| dbbin.000028 |          0 |
| dbbin.000029 |          0 |
| dbbin.000030 |          0 |
| dbbin.000031 |          0 |
| dbbin.000032 |          0 |
| dbbin.000033 |          0 |
| dbbin.000034 |          0 |
| dbbin.000035 |          0 |
| dbbin.000036 |          0 |
| dbbin.000037 |          0 |
| dbbin.000038 |          0 |
| dbbin.000039 |          0 |
| dbbin.000040 |          0 |
| dbbin.000041 |          0 |
| dbbin.000042 |          0 |
| dbbin.000043 |          0 |
| dbbin.000044 |          0 |
| dbbin.000045 |          0 |
| dbbin.000046 |          0 |
| dbbin.000047 |          0 |
| dbbin.000048 |          0 |
| dbbin.000049 |          0 |
| dbbin.000050 |          0 |
| dbbin.000051 |          0 |
| dbbin.000052 |          0 |
| dbbin.000053 |          0 |
| dbbin.000054 |          0 |
| dbbin.000055 |          0 |
| dbbin.000056 |          0 |
| dbbin.000057 |          0 |
| dbbin.000058 |          0 |
| dbbin.000059 |          0 |
| dbbin.000060 |          0 |
| dbbin.000061 |          0 |
| dbbin.000062 |          0 |
| dbbin.000063 |          0 |
| dbbin.000064 |          0 |
| dbbin.000065 |          0 |
| dbbin.000066 |          0 |
| dbbin.000067 |          0 |
| dbbin.000068 |          0 |
| dbbin.000069 |          0 |
| dbbin.000070 |          0 |
| dbbin.000071 |          0 |
| dbbin.000072 |          0 |
| dbbin.000073 |          0 |
| dbbin.000074 |          0 |
| dbbin.000075 |          0 |
| dbbin.000076 |          0 |
| dbbin.000077 |          0 |
| dbbin.000078 |          0 |
| dbbin.000079 |          0 |
| dbbin.000080 |          0 |
| dbbin.000081 |          0 |
| dbbin.000082 |          0 |
| dbbin.000083 |          0 |
| dbbin.000084 |          0 |
| dbbin.000085 |          0 |
| dbbin.000086 |          0 |
| dbbin.000087 |          0 |
| dbbin.000088 |          0 |
| dbbin.000089 |          0 |
| dbbin.000090 |          0 |
| dbbin.000091 |          0 |
| dbbin.000092 |          0 |
| dbbin.000093 |          0 |
| dbbin.000094 |          0 |
| dbbin.000095 |          0 |
| dbbin.000096 |          0 |
| dbbin.000097 |          0 |
| dbbin.000098 |          0 |
| dbbin.000099 |          0 |
| dbbin.000100 |          0 |
| dbbin.000101 |          0 |
| dbbin.000102 |          0 |
| dbbin.000103 |          0 |
| dbbin.000104 |          0 |
| dbbin.000105 |          0 |
| dbbin.000106 |          0 |
| dbbin.000107 |          0 |
| dbbin.000108 |          0 |
| dbbin.000109 |          0 |
| dbbin.000110 |          0 |
| dbbin.000111 |          0 |
| dbbin.000112 |          0 |
| dbbin.000113 |          0 |
| dbbin.000114 |          0 |
| dbbin.000115 |          0 |
| dbbin.000116 |          0 |
| dbbin.000117 |          0 |
| dbbin.000118 |          0 |
| dbbin.000119 |          0 |
| dbbin.000120 |          0 |
| dbbin.000121 |          0 |
| dbbin.000122 |          0 |
| dbbin.000123 |          0 |
| dbbin.000124 |          0 |
| dbbin.000125 |          0 |
| dbbin.000126 |          0 |
| dbbin.000127 |          0 |
| dbbin.000128 |          0 |
| dbbin.000129 |          0 |
| dbbin.000130 |          0 |
| dbbin.000131 |          0 |
| dbbin.000001 |          0 |
| dbbin.000002 |          0 |
| dbbin.000003 |          0 |
| dbbin.000004 |          0 |
| dbbin.000005 |          0 |
| dbbin.000006 |          0 |
| dbbin.000007 |          0 |
| dbbin.000008 |          0 |
| dbbin.000009 |          0 |
| dbbin.000010 |          0 |
| dbbin.000011 |          0 |
| dbbin.000012 |          0 |
| dbbin.000013 |          0 |
| dbbin.000014 |          0 |
| dbbin.000015 |          0 |
| dbbin.000016 |          0 |
| dbbin.000017 |          0 |
| dbbin.000018 |          0 |
| dbbin.000019 |          0 |
| dbbin.000020 |          0 |
| dbbin.000021 |          0 |
| dbbin.000022 |          0 |
| dbbin.000023 |          0 |
| dbbin.000024 |          0 |
| dbbin.000025 |          0 |
| dbbin.000026 |          0 |
| dbbin.000027 |          0 |
| dbbin.000028 |          0 |
| dbbin.000029 |          0 |
| dbbin.000030 |          0 |
| dbbin.000031 |          0 |
| dbbin.000032 |          0 |
| dbbin.000033 |          0 |
| dbbin.000034 |          0 |
| dbbin.000035 |          0 |
| dbbin.000036 |          0 |
| dbbin.000037 |          0 |
| dbbin.000038 |          0 |
| dbbin.000039 |          0 |
| dbbin.000040 |          0 |
| dbbin.000041 |          0 |
| dbbin.000042 |          0 |
| dbbin.000043 |          0 |
| dbbin.000044 |          0 |
| dbbin.000045 |          0 |
| dbbin.000046 |          0 |
| dbbin.000047 |          0 |
| dbbin.000048 |          0 |
| dbbin.000049 |          0 |
| dbbin.000050 |          0 |
| dbbin.000051 |          0 |
| dbbin.000052 |          0 |
| dbbin.000053 |          0 |
| dbbin.000054 |          0 |
| dbbin.000055 |          0 |
| dbbin.000056 |          0 |
| dbbin.000057 |          0 |
| dbbin.000058 |          0 |
| dbbin.000059 |          0 |
| dbbin.000060 |          0 |
| dbbin.000061 |          0 |
| dbbin.000062 |          0 |
| dbbin.000063 |          0 |
| dbbin.000064 |          0 |
| dbbin.000065 |          0 |
| dbbin.000066 |          0 |
| dbbin.000067 |          0 |
| dbbin.000068 |          0 |
| dbbin.000069 |          0 |
| dbbin.000070 |          0 |
| dbbin.000071 |          0 |
| dbbin.000072 |          0 |
| dbbin.000073 |          0 |
| dbbin.000074 |          0 |
| dbbin.000075 |          0 |
| dbbin.000076 |          0 |
| dbbin.000077 |          0 |
| dbbin.000078 |          0 |
| dbbin.000079 |          0 |
| dbbin.000080 |          0 |
| dbbin.000081 |          0 |
| dbbin.000082 |          0 |
| dbbin.000083 |          0 |
| dbbin.000084 |          0 |
| dbbin.000085 |          0 |
| dbbin.000086 |          0 |
| dbbin.000087 |          0 |
| dbbin.000088 |          0 |
| dbbin.000089 |          0 |
| dbbin.000090 |          0 |
| dbbin.000091 |          0 |
| dbbin.000092 |          0 |
| dbbin.000093 |          0 |
| dbbin.000094 |          0 |
| dbbin.000095 |          0 |
| dbbin.000096 |          0 |
| dbbin.000097 |          0 |
| dbbin.000098 |          0 |
| dbbin.000099 |          0 |
| dbbin.000100 |          0 |
| dbbin.000101 |          0 |
| dbbin.000102 |          0 |
| dbbin.000103 |          0 |
| dbbin.000104 |          0 |
| dbbin.000105 |          0 |
| dbbin.000106 |          0 |
| dbbin.000107 |          0 |
| dbbin.000108 |          0 |
| dbbin.000109 |          0 |
| dbbin.000110 |          0 |
| dbbin.000111 |          0 |
| dbbin.000112 |          0 |
| dbbin.000113 |          0 |
| dbbin.000114 |          0 |
| dbbin.000115 |          0 |
| dbbin.000116 |          0 |
| dbbin.000117 |          0 |
| dbbin.000118 |          0 |
| dbbin.000119 |          0 |
| dbbin.000120 |          0 |
| dbbin.000121 |          0 |
| dbbin.000122 |          0 |
| dbbin.000123 |          0 |
| dbbin.000124 |          0 |
| dbbin.000125 |          0 |
| dbbin.000126 |          0 |
| dbbin.000127 |          0 |
| dbbin.000128 |          0 |
| dbbin.000129 |          0 |
| dbbin.000130 |          0 |
| dbbin.000131 |          0 |
| dbbin.000132 |          0 |
| dbbin.000133 |          0 |
| dbbin.000134 |          0 |
| dbbin.000135 |  928716703 |
| dbbin.000136 |  959380747 |
| dbbin.000137 |  851723423 |
| dbbin.000138 |  365674634 |
| dbbin.000139 | 1073742052 |
| dbbin.000140 |  123579443 |
| dbbin.000141 |   30362973 |
| dbbin.000142 |  902470948 |
| dbbin.000143 |  889738300 |
| dbbin.000144 |  923650782 |
| dbbin.000145 | 1511748108 |
| dbbin.000146 |  290317434 |
| dbbin.000147 |      52264 |
+--------------+------------+
278 rows in set (0.00 sec)

看着很不爽,进行下一步的解决:

mysql> purge binary logs to 'dbbin.000133';
Query OK, 0 rows affected, 263 warnings (0.01 sec)

查看处理的结果:

mysql> show binary logs;
+--------------+------------+
| Log_name     | File_size  |
+--------------+------------+
| dbbin.000133 |          0 |
| dbbin.000134 |          0 |
| dbbin.000135 |  928716703 |
| dbbin.000136 |  959380747 |
| dbbin.000137 |  851723423 |
| dbbin.000138 |  365674634 |
| dbbin.000139 | 1073742052 |
| dbbin.000140 |  123579443 |
| dbbin.000141 |   30362973 |
| dbbin.000142 |  902470948 |
| dbbin.000143 |  889738300 |
| dbbin.000144 |  923650782 |
| dbbin.000145 | 1511748108 |
| dbbin.000146 |  290317434 |
| dbbin.000147 |    3826433 |
+--------------+------------+
15 rows in set (0.00 sec)

再处理一下:

mysql> purge binary logs to 'dbbin.000135';
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> show binary logs;
+--------------+------------+
| Log_name     | File_size  |
+--------------+------------+
| dbbin.000135 |  928716703 |
| dbbin.000136 |  959380747 |
| dbbin.000137 |  851723423 |
| dbbin.000138 |  365674634 |
| dbbin.000139 | 1073742052 |
| dbbin.000140 |  123579443 |
| dbbin.000141 |   30362973 |
| dbbin.000142 |  902470948 |
| dbbin.000143 |  889738300 |
| dbbin.000144 |  923650782 |
| dbbin.000145 | 1511748108 |
| dbbin.000146 |  290317434 |
| dbbin.000147 |    4443351 |
+--------------+------------+
13 rows in set (0.00 sec)

看着是不是舒服很多?

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI