mongodb集群重构，释放磁盘空间

雅冰石

已于 2022-09-01 13:32:58 修改

阅读量4k

点赞数

分类专栏： 4 Mongodb 学习文章标签： mongodb 数据库

于 2016-11-07 16:35:27 首次发布

本文链接：https://blog.csdn.net/yabingshi_tech/article/details/53067455

版权

4 Mongodb 学习专栏收录该内容

55 篇文章 0 订阅

订阅专栏

由于mongodb删除了一部分数据后，不会回收相应的磁盘空间，所以这里通过重建数据目录的方式释放磁盘空间。

一实验环境

配置了一个副本集，该副本集由以下三个节点组成：

10.192.203.201:27017 PRIMARY

10.192.203.202:27017 SECONDARY

10.192.203.202:10001 ARBITER

二实验步骤

2.1 模拟环境

use dba;
for(var i=0;i<1000000;i++)db.c.insert({uid:i,uname:'osqlfan'+i});
db.c.find().count();#1000000
 db.stats();
{
	"db" : "dba",
	"collections" : 5,
	"objects" : 1000111,
	"avgObjSize" : 111.9994880568257,
	"dataSize" : 112011920,
	"storageSize" : 174796800,
	"numExtents" : 17,
	"indexes" : 3,
	"indexSize" : 32475072,
	"fileSize" : 469762048,
	"nsSizeMB" : 16,
	"extentFreeList" : {
		"num" : 0,
		"totalSize" : 0
	},
	"dataFileVersion" : {
		"major" : 4,
		"minor" : 22
	},
	"ok" : 1
}

磁盘空间增加了400M数据：

-rw-------. 1 root root 134217728 Nov 7 13:38 dba.1

-rw-------. 1 root root 268435456 Nov 7 13:38 dba.2

[root@slave2 ~]# du -sh /data/mongo/data

4.7G /data/mongo/data

#删除dba.c表数据:
MyReplset:PRIMARY> db.c.drop();
true
MyReplset:PRIMARY> db.c.find().count();
0
MyReplset:PRIMARY> db.stats();
{
"db" : "dba",
"collections" : 4,
"objects" : 108,
"avgObjSize" : 108.44444444444444,
"dataSize" : 11712,
"storageSize" : 61440,
"numExtents" : 5,
"indexes" : 2,
"indexSize" : 16352,
"fileSize" : 469762048,
"nsSizeMB" : 16,
"extentFreeList" : {
"num" : 18,
"totalSize" : 212492288
},
"dataFileVersion" : {
"major" : 4,
"minor" : 22
},
"ok" : 1
}

看到dataSize，indexSize，storageSize都变小了，但是fileSize没有变化，而且mongo data目录仍然占用4.7G。

2.2 确保先在从库10.192.203.202:27017上进行重构

#查看主从关系

MyReplset:PRIMARY>rs.status();
{
"set" : "MyReplset",
"date" :ISODate("2016-11-07T07:10:50.717Z"),
"myState" : 1,
"members" : [
           {
                    "_id" : 0,
                    "name" :"10.192.203.201:27017",
                    "health" : 1,
                    "state" : 1,
                    "stateStr" :"PRIMARY",
                    "uptime" : 964,
                    "optime" :Timestamp(1478239977, 594),
                    "optimeDate" :ISODate("2016-11-04T06:12:57Z"),
                    "electionTime" :Timestamp(1478502021, 1),
                    "electionDate" :ISODate("2016-11-07T07:00:21Z"),
                    "configVersion" :2,
                    "self" : true
           },
           {
                    "_id" : 1,
                    "name" :"10.192.203.202:27017",
                    "health" : 1,
                    "state" : 2,
                    "stateStr" :"SECONDARY",
                    "uptime" : 628,
                    "optime" :Timestamp(1478239977, 594),
                    "optimeDate" :ISODate("2016-11-04T06:12:57Z"),
                    "lastHeartbeat" :ISODate("2016-11-07T07:10:49.257Z"),
                    "lastHeartbeatRecv": ISODate("2016-11-07T07:10:50.143Z"),
                    "pingMs" : 2,
                    "configVersion" :2
           },
           {
                    "_id" : 2,
                    "name" :"10.192.203.202:10001",
                    "health" : 1,
                   "state": 7,
                    "stateStr" :"ARBITER",
                    "uptime" : 618,
                    "lastHeartbeat" :ISODate("2016-11-07T07:10:49.416Z"),
                    "lastHeartbeatRecv": ISODate("2016-11-07T07:10:49.847Z"),
                    "pingMs" : 2,
                    "configVersion" :2
           }
],
"ok" : 1
}

2.2.1 关闭数据库

MyReplset:SECONDARY> use admin;
switched to db admin
MyReplset:SECONDARY> db.shutdownServer();
2016-11-07T15:14:42.548+0800 I NETWORK  DBClientCursor::init call() failed
server should be down...
2016-11-07T15:14:42.571+0800 I NETWORK  trying reconnect to 127.0.0.1:27017(127.0.0.1) failed
2016-11-07T15:14:42.575+0800 W NETWORK  Failed to connect to 127.0.0.1:27017, reason:errno:111 Connection refused
2016-11-07T15:14:42.575+0800 I NETWORK  reconnect 127.0.0.1:27017 (127.0.0.1) failedfailed couldn't connect to server 127.0.0.1:27017 (127.0.0.1), connectionattempt failed
2016-11-07T15:14:42.634+0800 I NETWORK  trying reconnect to 127.0.0.1:27017(127.0.0.1) failed
2016-11-07T15:14:42.637+0800 W NETWORK  Failed to connect to 127.0.0.1:27017, reason:errno:111 Connection refused
2016-11-07T15:14:42.638+0800I NETWORK  reconnect 127.0.0.1:27017(127.0.0.1) failed failed couldn't connect to server 127.0.0.1:27017(127.0.0.1), connection attempt failed