服务器存在大量的mysql-bin.文件,请问是否可以删除?-问答-阿里云开发者社区-阿里云

开发者社区> 问答> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

服务器存在大量的mysql-bin.文件,请问是否可以删除?

2017-01-25 18:46:40 13893 5

mysql-bin.是什么东西来的呢?我查到存在非常多的mysql-bin.*文件,并且每个都是1G左右,是否可以删除呢?

11M ibdata1
5.1M ib_logfile0
5.1M ib_logfile1
4.0K iZ94dpasz1dZ.pid
996K mysql
4.0K mysql-bin.000001
26M mysql-bin.000002
239M mysql-bin.000003
3.9M mysql-bin.000004
138M mysql-bin.000005
18M mysql-bin.000006
2.0M mysql-bin.000007
480K mysql-bin.000008
356K mysql-bin.000009
1.7M mysql-bin.000010
325M mysql-bin.000011
23M mysql-bin.000012
180M mysql-bin.000013
144K mysql-bin.000014
408M mysql-bin.000015
352K mysql-bin.000016
158M mysql-bin.000017
4.0K mysql-bin.000018
106M mysql-bin.000019
33M mysql-bin.000020
3.2M mysql-bin.000021
46M mysql-bin.000022
4.0K mysql-bin.000023
17M mysql-bin.000024
27M mysql-bin.000025
152M mysql-bin.000026
1.9M mysql-bin.000027
3.3M mysql-bin.000028
28M mysql-bin.000029
22M mysql-bin.000030
2.4M mysql-bin.000031
1.6M mysql-bin.000032
363M mysql-bin.000033
12K mysql-bin.000034
1.1G mysql-bin.000035
1.1G mysql-bin.000036
1.1G mysql-bin.000037
934M mysql-bin.000038
2.1M mysql-bin.000039
420K mysql-bin.000040
232K mysql-bin.000041
1.1G mysql-bin.000042
56M mysql-bin.000043
860M mysql-bin.000044
20M mysql-bin.000045
1.1G mysql-bin.000046
1.1G mysql-bin.000047
161M mysql-bin.000048
27M mysql-bin.000049
1.1G mysql-bin.000050
1.1G mysql-bin.000051
1.1G mysql-bin.000052
1.1G mysql-bin.000053
1.1G mysql-bin.000054
245M mysql-bin.000055
1.1G mysql-bin.000056
1.1G mysql-bin.000057
1.1G mysql-bin.000058
1.1G mysql-bin.000059
1.1G mysql-bin.000060
1.1G mysql-bin.000061
1.1G mysql-bin.000062
993M mysql-bin.000063
112K mysql-bin.000064
640K mysql-bin.000065
1.1G mysql-bin.000066
1.1G mysql-bin.000067
1.1G mysql-bin.000068
1.1G mysql-bin.000069
1.1G mysql-bin.000070
1.1G mysql-bin.000071
1.1G mysql-bin.000072
1.1G mysql-bin.000073
1.1G mysql-bin.000074
1.1G mysql-bin.000075
1.1G mysql-bin.000076
1.1G mysql-bin.000077
1.1G mysql-bin.000078
1.1G mysql-bin.000079
1.1G mysql-bin.000080
1.1G mysql-bin.000081
1.1G mysql-bin.000082
1.1G mysql-bin.000083
1.1G mysql-bin.000084
1.1G mysql-bin.000085
1.1G mysql-bin.000086
1.1G mysql-bin.000087
1.1G mysql-bin.000088
1.1G mysql-bin.000089
1.1G mysql-bin.000090
1.1G mysql-bin.000091
1.1G mysql-bin.000092
1.1G mysql-bin.000093
1.1G mysql-bin.000094
1.1G mysql-bin.000095
1.1G mysql-bin.000096
1.1G mysql-bin.000097
40M mysql-bin.000098
1.1G mysql-bin.000099
1.1G mysql-bin.000100
787M mysql-bin.000101
1.1G mysql-bin.000102
1.1G mysql-bin.000103
1.1G mysql-bin.000104
1.1G mysql-bin.000105
1.1G mysql-bin.000106
1.1G mysql-bin.000107
1.1G mysql-bin.000108
1.1G mysql-bin.000109
1.1G mysql-bin.000110
1.1G mysql-bin.000111
1.1G mysql-bin.000112
1.1G mysql-bin.000113
1.1G mysql-bin.000114
1.1G mysql-bin.000115
1.1G mysql-bin.000116
1.1G mysql-bin.000117
1.1G mysql-bin.000118
1.1G mysql-bin.000119
1.1G mysql-bin.000120
1.1G mysql-bin.000121
1.1G mysql-bin.000122
1.1G mysql-bin.000123
1.1G mysql-bin.000124
1.1G mysql-bin.000125
1.1G mysql-bin.000126
1.1G mysql-bin.000127
1.1G mysql-bin.000128
1.1G mysql-bin.000129
1.1G mysql-bin.000130
1.1G mysql-bin.000131
1.1G mysql-bin.000132
1.1G mysql-bin.000133
1.1G mysql-bin.000134
1.1G mysql-bin.000135
1.1G mysql-bin.000136
1.1G mysql-bin.000137
1.1G mysql-bin.000138
1.1G mysql-bin.000139
1.1G mysql-bin.000140
1.1G mysql-bin.000141
1.1G mysql-bin.000142
1.1G mysql-bin.000143
1.1G mysql-bin.000144
1.1G mysql-bin.000145
1.1G mysql-bin.000146
1.1G mysql-bin.000147
1.1G mysql-bin.000148
1.1G mysql-bin.000149
1.1G mysql-bin.000150
1.1G mysql-bin.000151
1.1G mysql-bin.000152
1.1G mysql-bin.000153
1.1G mysql-bin.000154
1.1G mysql-bin.000155
1.1G mysql-bin.000156
1.1G mysql-bin.000157
1.1G mysql-bin.000158
705M mysql-bin.000159
1.1G mysql-bin.000160
1.1G mysql-bin.000161
1.1G mysql-bin.000162
1.1G mysql-bin.000163
1.1G mysql-bin.000164
1.1G mysql-bin.000165
1.1G mysql-bin.000166
1.1G mysql-bin.000167
1.1G mysql-bin.000168
1.1G mysql-bin.000169
1.1G mysql-bin.000170
1.1G mysql-bin.000171
1.1G mysql-bin.000172
1.1G mysql-bin.000173
1.1G mysql-bin.000174
66M mysql-bin.000175
1.1G mysql-bin.000176
1.1G mysql-bin.000177
1.1G mysql-bin.000178
1.1G mysql-bin.000179
1.1G mysql-bin.000180
1.1G mysql-bin.000181
1.1G mysql-bin.000182
1.1G mysql-bin.000183
294M mysql-bin.000184
4.0K mysql-bin.index
4.0K test
60M ultrax
8.6M ultrax61cn
140G total

取消 提交回答
全部回答(5)
  • 晓风瑟瑟
    2021-10-15 19:28:54

    所有MYSQL的文件不建议非专业人员移动或删除,否则后果很严重

    0 0
  • 睡着了去做梦
    2021-10-11 17:22:29

    不可以删除,这里其中一部分数据,可能还没有写入硬盘呢 数据是可以通过binlog恢复的呢

    0 0
  • zysql
    2019-07-17 20:44:47

    如果是备份集所需的binlog,不建议删除

    0 0
  • 韩逸
    2019-07-17 20:44:47

    binlog是mysql用来构建复制时候用的文件。目测楼主没有从库,所以可以把binlog给关掉。方法就是在配置文件中注释掉log-bin。在关闭前,可以下使用reset master把现有的binlog都删除掉

    0 0
  • dongshan8
    2019-07-17 20:44:47

    题主您好,

    请问您的mysql是单机使用的吗?

    一般mysql-bin-xxxx文件是mysql在运行中自动创建的,不建议手工删除,推荐用mysql命令来清除。

    请参考:http://dba.stackexchange.com/questions/41050/is-it-safe-to-delete-mysql-bin-files

    0 0
添加回答
相关问答

0

回答

请问一下有人遇到使用mysql-cdc同步数据报错没有收到来自服务器的任何数据包吗?

2022-09-06 22:48:43 17浏览量 回答数 0

1

回答

请问为什么我进行mysql数据update时,kafka中采集到的是先删除原纪录(op d)再新增新

2022-07-22 11:59:35 120浏览量 回答数 1

0

回答

请问canal如何同步rds上mysql数据库的binlog文件呢?

2020-05-14 15:06:53 828浏览量 回答数 0

0

回答

访问ECS服务器的MySQL提示Can't get hostname for your addres

2019-07-16 16:23:27 345浏览量 回答数 0

2

回答

请问阿里云服务器支不支持访问smtp.gmail.com

2019-03-12 15:20:10 853浏览量 回答数 2

1

回答

访问ECS服务器的MySQL提示Can't get hostname for your address。

2018-01-12 13:28:00 1654浏览量 回答数 1

0

回答

为什么访问ECS服务器的MySQL提示Can't get hostname for your address

2017-11-02 16:02:22 1804浏览量 回答数 0

3

回答

mac中无法连接mysql服务器

2016-06-27 11:05:57 2892浏览量 回答数 3

5

回答

ESC服务器安装的MYSQL连接不稳定

2016-02-21 10:39:01 8474浏览量 回答数 5

1

回答

mac中无法连接mysql服务器

2016-02-12 16:57:35 3544浏览量 回答数 1
+关注
0
文章
4
问答
问答排行榜
最热
最新
相关电子书
更多
低代码开发师(初级)实战教程
立即下载
阿里巴巴DevOps 最佳实践手册
立即下载
冬季实战营第三期:MySQL数据库进阶实战
立即下载