前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >详解mysql-bin.000001文件来源以及处理方法

详解mysql-bin.000001文件来源以及处理方法

作者头像
行 者
发布2018-03-26 14:18:43
1.5K0
发布2018-03-26 14:18:43
举报
文章被收录于专栏:运维技术迷运维技术迷

今天看服务器探针,吓了我一跳,发现硬盘空间剩余6.2G左右。

《详解mysql-bin.000001文件来源以及处理方法》
《详解mysql-bin.000001文件来源以及处理方法》

仔细想想没有往服务器上传什么大的文件,也不能被黑(不起眼的小网站服务器)。于是,就逐一的检查”/”下的所有文件占用磁盘空间的大小。

代码语言:javascript
复制
[root@localhost ~]# du -s /* 
6160	/bin
19380	/boot
156	/dev
21700	/etc
2383236	/home
112372	/lib
16	/lost+found
4	/media
4	/mnt
4	/opt
du: 无法访问"/proc/2187/task/2187/fd/4": 没有那个文件或目录
du: 无法访问"/proc/2187/task/2187/fdinfo/4": 没有那个文件或目录
du: 无法访问"/proc/2187/fd/4": 没有那个文件或目录
du: 无法访问"/proc/2187/fdinfo/4": 没有那个文件或目录
0	/proc
56	/root
9488	/sbin
4	/selinux
4	/srv
0	/sys
14760	/tmp
37310312	/usr
90452	/var

发现/usr占用了大约37.3G的磁盘空间,然后进入/usr检查。

代码语言:javascript
复制
[root@localhost ~]#  du -s /usr/local/*
944	/usr/local/autoconf-2.13
472	/usr/local/bin
87568	/usr/local/eaccelerator_cache
4	/usr/local/etc
4	/usr/local/games
172	/usr/local/include
13824	/usr/local/ioncube
4100	/usr/local/lib
4	/usr/local/libexec
36	/usr/local/man
36436840	/usr/local/mysql
5108	/usr/local/nginx
53440	/usr/local/php
4	/usr/local/sbin
2620	/usr/local/share
4	/usr/local/src
900	/usr/local/zend

从返回的命令看出,占用最大的是/usr/local/mysql,继续检查。

代码语言:javascript
复制
[root@localhost ~]#  du -s /usr/local/mysql/var/*
552	/usr/local/mysql/var/0t9
71196	/usr/local/mysql/var/feifeicms
1640	/usr/local/mysql/var/idc@002elianst@002ecom
320	/usr/local/mysql/var/localhost.localdomain.err
4	/usr/local/mysql/var/localhost.localdomain.pid
1032	/usr/local/mysql/var/mysql
28	/usr/local/mysql/var/mysql-bin.000001
1048	/usr/local/mysql/var/mysql-bin.000002
4	/usr/local/mysql/var/mysql-bin.000003
4	/usr/local/mysql/var/mysql-bin.000004
4	/usr/local/mysql/var/mysql-bin.000005
5092	/usr/local/mysql/var/mysql-bin.000006
3808	/usr/local/mysql/var/mysql-bin.000007
508	/usr/local/mysql/var/mysql-bin.000008
8	/usr/local/mysql/var/mysql-bin.000009
4	/usr/local/mysql/var/mysql-bin.000010
72	/usr/local/mysql/var/mysql-bin.000011
16	/usr/local/mysql/var/mysql-bin.000012
36	/usr/local/mysql/var/mysql-bin.000013
116	/usr/local/mysql/var/mysql-bin.000014
4	/usr/local/mysql/var/mysql-bin.000015
44	/usr/local/mysql/var/mysql-bin.000016
84	/usr/local/mysql/var/mysql-bin.000017
976	/usr/local/mysql/var/mysql-bin.000018
36	/usr/local/mysql/var/mysql-bin.000019
628	/usr/local/mysql/var/mysql-bin.000020
872	/usr/local/mysql/var/mysql-bin.000021
1428	/usr/local/mysql/var/mysql-bin.000022
4	/usr/local/mysql/var/mysql-bin.000023
16	/usr/local/mysql/var/mysql-bin.000024
44	/usr/local/mysql/var/mysql-bin.000025
28	/usr/local/mysql/var/mysql-bin.000026
76	/usr/local/mysql/var/mysql-bin.000027
12	/usr/local/mysql/var/mysql-bin.000028
104	/usr/local/mysql/var/mysql-bin.000029
40	/usr/local/mysql/var/mysql-bin.000030
76	/usr/local/mysql/var/mysql-bin.000031
292	/usr/local/mysql/var/mysql-bin.000032
64	/usr/local/mysql/var/mysql-bin.000033
7852	/usr/local/mysql/var/mysql-bin.000034
96	/usr/local/mysql/var/mysql-bin.000035
44	/usr/local/mysql/var/mysql-bin.000036
100	/usr/local/mysql/var/mysql-bin.000037
28740	/usr/local/mysql/var/mysql-bin.000038
12	/usr/local/mysql/var/mysql-bin.000039
128	/usr/local/mysql/var/mysql-bin.000040
384	/usr/local/mysql/var/mysql-bin.000041
100	/usr/local/mysql/var/mysql-bin.000042
4	/usr/local/mysql/var/mysql-bin.000043
24	/usr/local/mysql/var/mysql-bin.000044
40	/usr/local/mysql/var/mysql-bin.000045
88	/usr/local/mysql/var/mysql-bin.000046
13920	/usr/local/mysql/var/mysql-bin.000047
41164	/usr/local/mysql/var/mysql-bin.000048
4	/usr/local/mysql/var/mysql-bin.000049
4	/usr/local/mysql/var/mysql-bin.000050
4	/usr/local/mysql/var/mysql-bin.000051
6320	/usr/local/mysql/var/mysql-bin.000052
5272	/usr/local/mysql/var/mysql-bin.000053
84	/usr/local/mysql/var/mysql-bin.000054
100	/usr/local/mysql/var/mysql-bin.000055
80	/usr/local/mysql/var/mysql-bin.000056
124	/usr/local/mysql/var/mysql-bin.000057
56	/usr/local/mysql/var/mysql-bin.000058
7556	/usr/local/mysql/var/mysql-bin.000059
6244	/usr/local/mysql/var/mysql-bin.000060
4	/usr/local/mysql/var/mysql-bin.000061
4	/usr/local/mysql/var/mysql-bin.000062
356	/usr/local/mysql/var/mysql-bin.000063
108	/usr/local/mysql/var/mysql-bin.000064
40	/usr/local/mysql/var/mysql-bin.000065
76	/usr/local/mysql/var/mysql-bin.000066
88	/usr/local/mysql/var/mysql-bin.000067
152	/usr/local/mysql/var/mysql-bin.000068
2648	/usr/local/mysql/var/mysql-bin.000069
84	/usr/local/mysql/var/mysql-bin.000070
108	/usr/local/mysql/var/mysql-bin.000071
52	/usr/local/mysql/var/mysql-bin.000072
104	/usr/local/mysql/var/mysql-bin.000073
172	/usr/local/mysql/var/mysql-bin.000074
408	/usr/local/mysql/var/mysql-bin.000075
848	/usr/local/mysql/var/mysql-bin.000076
72	/usr/local/mysql/var/mysql-bin.000077
36	/usr/local/mysql/var/mysql-bin.000078
56	/usr/local/mysql/var/mysql-bin.000079
80	/usr/local/mysql/var/mysql-bin.000080
236	/usr/local/mysql/var/mysql-bin.000081
104	/usr/local/mysql/var/mysql-bin.000082
324	/usr/local/mysql/var/mysql-bin.000083
3476	/usr/local/mysql/var/mysql-bin.000084
88	/usr/local/mysql/var/mysql-bin.000085
140	/usr/local/mysql/var/mysql-bin.000086
336	/usr/local/mysql/var/mysql-bin.000087
396	/usr/local/mysql/var/mysql-bin.000088
84	/usr/local/mysql/var/mysql-bin.000089
88	/usr/local/mysql/var/mysql-bin.000090
272	/usr/local/mysql/var/mysql-bin.000091
80	/usr/local/mysql/var/mysql-bin.000092
76	/usr/local/mysql/var/mysql-bin.000093
88	/usr/local/mysql/var/mysql-bin.000094
248	/usr/local/mysql/var/mysql-bin.000095
116	/usr/local/mysql/var/mysql-bin.000096
3028	/usr/local/mysql/var/mysql-bin.000097
64	/usr/local/mysql/var/mysql-bin.000098
220	/usr/local/mysql/var/mysql-bin.000099
64	/usr/local/mysql/var/mysql-bin.000100
76	/usr/local/mysql/var/mysql-bin.000101
80	/usr/local/mysql/var/mysql-bin.000102
208	/usr/local/mysql/var/mysql-bin.000103
64	/usr/local/mysql/var/mysql-bin.000104
64	/usr/local/mysql/var/mysql-bin.000105
64	/usr/local/mysql/var/mysql-bin.000106
240	/usr/local/mysql/var/mysql-bin.000107
64	/usr/local/mysql/var/mysql-bin.000108
68	/usr/local/mysql/var/mysql-bin.000109
68	/usr/local/mysql/var/mysql-bin.000110
184	/usr/local/mysql/var/mysql-bin.000111
64	/usr/local/mysql/var/mysql-bin.000112
68	/usr/local/mysql/var/mysql-bin.000113
64	/usr/local/mysql/var/mysql-bin.000114
180	/usr/local/mysql/var/mysql-bin.000115
56	/usr/local/mysql/var/mysql-bin.000116
56	/usr/local/mysql/var/mysql-bin.000117
52	/usr/local/mysql/var/mysql-bin.000118
72	/usr/local/mysql/var/mysql-bin.000119
2076	/usr/local/mysql/var/mysql-bin.000120
32	/usr/local/mysql/var/mysql-bin.000121
32	/usr/local/mysql/var/mysql-bin.000122
104	/usr/local/mysql/var/mysql-bin.000123
84	/usr/local/mysql/var/mysql-bin.000124
32	/usr/local/mysql/var/mysql-bin.000125
32	/usr/local/mysql/var/mysql-bin.000126
88	/usr/local/mysql/var/mysql-bin.000127
64	/usr/local/mysql/var/mysql-bin.000128
24	/usr/local/mysql/var/mysql-bin.000129
4408	/usr/local/mysql/var/mysql-bin.000130
64	/usr/local/mysql/var/mysql-bin.000131
60	/usr/local/mysql/var/mysql-bin.000132
32	/usr/local/mysql/var/mysql-bin.000133
24	/usr/local/mysql/var/mysql-bin.000134
36	/usr/local/mysql/var/mysql-bin.000135
76	/usr/local/mysql/var/mysql-bin.000136
16	/usr/local/mysql/var/mysql-bin.000137
28	/usr/local/mysql/var/mysql-bin.000138
32	/usr/local/mysql/var/mysql-bin.000139
84	/usr/local/mysql/var/mysql-bin.000140
16	/usr/local/mysql/var/mysql-bin.000141
3700	/usr/local/mysql/var/mysql-bin.000142
24	/usr/local/mysql/var/mysql-bin.000143
84	/usr/local/mysql/var/mysql-bin.000144
64	/usr/local/mysql/var/mysql-bin.000145
24	/usr/local/mysql/var/mysql-bin.000146
24	/usr/local/mysql/var/mysql-bin.000147
68	/usr/local/mysql/var/mysql-bin.000148
48	/usr/local/mysql/var/mysql-bin.000149
24	/usr/local/mysql/var/mysql-bin.000150
24	/usr/local/mysql/var/mysql-bin.000151
32	/usr/local/mysql/var/mysql-bin.000152
72	/usr/local/mysql/var/mysql-bin.000153
16	/usr/local/mysql/var/mysql-bin.000154
16	/usr/local/mysql/var/mysql-bin.000155
36	/usr/local/mysql/var/mysql-bin.000156
60	/usr/local/mysql/var/mysql-bin.000157
28	/usr/local/mysql/var/mysql-bin.000158
28	/usr/local/mysql/var/mysql-bin.000159
32	/usr/local/mysql/var/mysql-bin.000160
104	/usr/local/mysql/var/mysql-bin.000161
28	/usr/local/mysql/var/mysql-bin.000162
12	/usr/local/mysql/var/mysql-bin.000163
1636	/usr/local/mysql/var/mysql-bin.000164
24	/usr/local/mysql/var/mysql-bin.000165
76	/usr/local/mysql/var/mysql-bin.000166
1684	/usr/local/mysql/var/mysql-bin.000167
32	/usr/local/mysql/var/mysql-bin.000168
8	/usr/local/mysql/var/mysql-bin.000169
4	/usr/local/mysql/var/mysql-bin.000170
4	/usr/local/mysql/var/mysql-bin.000171
4	/usr/local/mysql/var/mysql-bin.000172
72	/usr/local/mysql/var/mysql-bin.000173
88	/usr/local/mysql/var/mysql-bin.000174
144	/usr/local/mysql/var/mysql-bin.000175
44	/usr/local/mysql/var/mysql-bin.000176
100	/usr/local/mysql/var/mysql-bin.000177
52	/usr/local/mysql/var/mysql-bin.000178
4	/usr/local/mysql/var/mysql-bin.000179
76	/usr/local/mysql/var/mysql-bin.000180
76	/usr/local/mysql/var/mysql-bin.000181
116	/usr/local/mysql/var/mysql-bin.000182
88	/usr/local/mysql/var/mysql-bin.000183
44	/usr/local/mysql/var/mysql-bin.000184
48	/usr/local/mysql/var/mysql-bin.000185
108	/usr/local/mysql/var/mysql-bin.000186
352	/usr/local/mysql/var/mysql-bin.000187
48	/usr/local/mysql/var/mysql-bin.000188
92	/usr/local/mysql/var/mysql-bin.000189
116	/usr/local/mysql/var/mysql-bin.000190
116	/usr/local/mysql/var/mysql-bin.000191
92	/usr/local/mysql/var/mysql-bin.000192
308	/usr/local/mysql/var/mysql-bin.000193
56	/usr/local/mysql/var/mysql-bin.000194
168	/usr/local/mysql/var/mysql-bin.000195
108	/usr/local/mysql/var/mysql-bin.000196
44	/usr/local/mysql/var/mysql-bin.000197
84	/usr/local/mysql/var/mysql-bin.000198
116	/usr/local/mysql/var/mysql-bin.000199
360	/usr/local/mysql/var/mysql-bin.000200
120	/usr/local/mysql/var/mysql-bin.000201
112	/usr/local/mysql/var/mysql-bin.000202
72	/usr/local/mysql/var/mysql-bin.000203
156	/usr/local/mysql/var/mysql-bin.000204
204	/usr/local/mysql/var/mysql-bin.000205
52	/usr/local/mysql/var/mysql-bin.000206
108	/usr/local/mysql/var/mysql-bin.000207
156	/usr/local/mysql/var/mysql-bin.000208
44	/usr/local/mysql/var/mysql-bin.000209
80	/usr/local/mysql/var/mysql-bin.000210
316	/usr/local/mysql/var/mysql-bin.000211
164	/usr/local/mysql/var/mysql-bin.000212
116	/usr/local/mysql/var/mysql-bin.000213
132	/usr/local/mysql/var/mysql-bin.000214
68	/usr/local/mysql/var/mysql-bin.000215
156	/usr/local/mysql/var/mysql-bin.000216
380	/usr/local/mysql/var/mysql-bin.000217
112	/usr/local/mysql/var/mysql-bin.000218
96	/usr/local/mysql/var/mysql-bin.000219
188	/usr/local/mysql/var/mysql-bin.000220
44	/usr/local/mysql/var/mysql-bin.000221
96	/usr/local/mysql/var/mysql-bin.000222
4	/usr/local/mysql/var/mysql-bin.000223
4	/usr/local/mysql/var/mysql-bin.000224
104	/usr/local/mysql/var/mysql-bin.000225
44	/usr/local/mysql/var/mysql-bin.000226
76	/usr/local/mysql/var/mysql-bin.000227
232	/usr/local/mysql/var/mysql-bin.000228
108	/usr/local/mysql/var/mysql-bin.000229
64	/usr/local/mysql/var/mysql-bin.000230
212	/usr/local/mysql/var/mysql-bin.000231
1020	/usr/local/mysql/var/mysql-bin.000232
60	/usr/local/mysql/var/mysql-bin.000233
128	/usr/local/mysql/var/mysql-bin.000234
168	/usr/local/mysql/var/mysql-bin.000235
56	/usr/local/mysql/var/mysql-bin.000236
80	/usr/local/mysql/var/mysql-bin.000237
532	/usr/local/mysql/var/mysql-bin.000238
20	/usr/local/mysql/var/mysql-bin.000239
1380	/usr/local/mysql/var/mysql-bin.000240
84	/usr/local/mysql/var/mysql-bin.000241
100	/usr/local/mysql/var/mysql-bin.000242
4	/usr/local/mysql/var/mysql-bin.000243
16	/usr/local/mysql/var/mysql-bin.000244
48	/usr/local/mysql/var/mysql-bin.000245
88	/usr/local/mysql/var/mysql-bin.000246
380	/usr/local/mysql/var/mysql-bin.000247
56	/usr/local/mysql/var/mysql-bin.000248
84	/usr/local/mysql/var/mysql-bin.000249
112	/usr/local/mysql/var/mysql-bin.000250
48	/usr/local/mysql/var/mysql-bin.000251
84	/usr/local/mysql/var/mysql-bin.000252
1492	/usr/local/mysql/var/mysql-bin.000253
104	/usr/local/mysql/var/mysql-bin.000254
96	/usr/local/mysql/var/mysql-bin.000255
96	/usr/local/mysql/var/mysql-bin.000256
68	/usr/local/mysql/var/mysql-bin.000257
80	/usr/local/mysql/var/mysql-bin.000258
1424	/usr/local/mysql/var/mysql-bin.000259
112	/usr/local/mysql/var/mysql-bin.000260
88	/usr/local/mysql/var/mysql-bin.000261
96	/usr/local/mysql/var/mysql-bin.000262
68	/usr/local/mysql/var/mysql-bin.000263
72	/usr/local/mysql/var/mysql-bin.000264
7492	/usr/local/mysql/var/mysql-bin.000265
352	/usr/local/mysql/var/mysql-bin.000266
96	/usr/local/mysql/var/mysql-bin.000267
104	/usr/local/mysql/var/mysql-bin.000268
92	/usr/local/mysql/var/mysql-bin.000269
48	/usr/local/mysql/var/mysql-bin.000270
124	/usr/local/mysql/var/mysql-bin.000271
1428	/usr/local/mysql/var/mysql-bin.000272
68	/usr/local/mysql/var/mysql-bin.000273
4	/usr/local/mysql/var/mysql-bin.000274
76	/usr/local/mysql/var/mysql-bin.000275
84	/usr/local/mysql/var/mysql-bin.000276
48	/usr/local/mysql/var/mysql-bin.000277
104	/usr/local/mysql/var/mysql-bin.000278
1616	/usr/local/mysql/var/mysql-bin.000279
12	/usr/local/mysql/var/mysql-bin.000280
4	/usr/local/mysql/var/mysql-bin.000281
4	/usr/local/mysql/var/mysql-bin.000282
180	/usr/local/mysql/var/mysql-bin.000283
4	/usr/local/mysql/var/mysql-bin.000284
72	/usr/local/mysql/var/mysql-bin.000285
7952	/usr/local/mysql/var/mysql-bin.000286
101440	/usr/local/mysql/var/mysql-bin.000287
176936	/usr/local/mysql/var/mysql-bin.000288
212424	/usr/local/mysql/var/mysql-bin.000289
253540	/usr/local/mysql/var/mysql-bin.000290
1048612	/usr/local/mysql/var/mysql-bin.000291
1048900	/usr/local/mysql/var/mysql-bin.000292
1049060	/usr/local/mysql/var/mysql-bin.000293
358448	/usr/local/mysql/var/mysql-bin.000294
794560	/usr/local/mysql/var/mysql-bin.000295
1048744	/usr/local/mysql/var/mysql-bin.000296
296464	/usr/local/mysql/var/mysql-bin.000297
1049108	/usr/local/mysql/var/mysql-bin.000298
21740	/usr/local/mysql/var/mysql-bin.000299
1048704	/usr/local/mysql/var/mysql-bin.000300
821624	/usr/local/mysql/var/mysql-bin.000301
981160	/usr/local/mysql/var/mysql-bin.000302
1048688	/usr/local/mysql/var/mysql-bin.000303
1049156	/usr/local/mysql/var/mysql-bin.000304
1048604	/usr/local/mysql/var/mysql-bin.000305
1025568	/usr/local/mysql/var/mysql-bin.000306
662604	/usr/local/mysql/var/mysql-bin.000307
705336	/usr/local/mysql/var/mysql-bin.000308
739816	/usr/local/mysql/var/mysql-bin.000309
788712	/usr/local/mysql/var/mysql-bin.000310
446864	/usr/local/mysql/var/mysql-bin.000311
1048880	/usr/local/mysql/var/mysql-bin.000312
1048708	/usr/local/mysql/var/mysql-bin.000313
602936	/usr/local/mysql/var/mysql-bin.000314
862772	/usr/local/mysql/var/mysql-bin.000315
894116	/usr/local/mysql/var/mysql-bin.000316
1048632	/usr/local/mysql/var/mysql-bin.000317
78332	/usr/local/mysql/var/mysql-bin.000318
1048656	/usr/local/mysql/var/mysql-bin.000319
307512	/usr/local/mysql/var/mysql-bin.000320
974816	/usr/local/mysql/var/mysql-bin.000321
1049144	/usr/local/mysql/var/mysql-bin.000322
1048636	/usr/local/mysql/var/mysql-bin.000323
1048688	/usr/local/mysql/var/mysql-bin.000324
122544	/usr/local/mysql/var/mysql-bin.000325
117868	/usr/local/mysql/var/mysql-bin.000326
733616	/usr/local/mysql/var/mysql-bin.000327
918396	/usr/local/mysql/var/mysql-bin.000328
878484	/usr/local/mysql/var/mysql-bin.000329
789624	/usr/local/mysql/var/mysql-bin.000330
551632	/usr/local/mysql/var/mysql-bin.000331
1048704	/usr/local/mysql/var/mysql-bin.000332
1048808	/usr/local/mysql/var/mysql-bin.000333
15468	/usr/local/mysql/var/mysql-bin.000334
4	/usr/local/mysql/var/mysql-bin.000335
4	/usr/local/mysql/var/mysql-bin.000336
15908	/usr/local/mysql/var/mysql-bin.000337
129536	/usr/local/mysql/var/mysql-bin.000338
181124	/usr/local/mysql/var/mysql-bin.000339
264004	/usr/local/mysql/var/mysql-bin.000340
8	/usr/local/mysql/var/mysql-bin.index
212	/usr/local/mysql/var/performance_schema
2792	/usr/local/mysql/var/wordpress

通过检查看到,好多mysql-bin.000XXX的文件,而且都还很大。经过询问度娘发现,此文件为mysql的日志文件,是可以删除的。因为这些日志文 件太大了,对我来说用处不大,索性就直接给关闭了。

代码语言:javascript
复制
[root@localhost ~]# vi /etc/my.cnf 

在log-bin前面加上”#”

《详解mysql-bin.000001文件来源以及处理方法》
《详解mysql-bin.000001文件来源以及处理方法》

然后重启服务器,再次查看,就不会在产生日志文件了!

《详解mysql-bin.000001文件来源以及处理方法》
《详解mysql-bin.000001文件来源以及处理方法》
本文参与 腾讯云自媒体分享计划,分享自作者个人站点/博客。
如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体分享计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
相关产品与服务
数据库
云数据库为企业提供了完善的关系型数据库、非关系型数据库、分析型数据库和数据库生态工具。您可以通过产品选择和组合搭建,轻松实现高可靠、高可用性、高性能等数据库需求。云数据库服务也可大幅减少您的运维工作量,更专注于业务发展,让企业一站式享受数据上云及分布式架构的技术红利!
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档