上一篇建好的MongoDB集群中插入数据，看看性能如何。
向test
数据库的test集合插入五百万数据 www.2cto.com
用时约11分钟
查看集合状态
www.2cto.com
mongos> db.test.stats(1024)
{
"sharded" : true,
"ns" : "test.test",
"count" : 5000000,
"numExtents" : 61,
"size" : 273436,
"storageSize" : 839500,
"totalIndexSize" : 158685,
"indexSizes" : {
"_id_" : 158685
},
"avgObjSize" : 0.0546872,
"nindexes" : 1,
"nchunks" : 29,
"shards" : {
"shard1" : {
"ns" : "test.test",
"count" : 0,
"size" : 0,
"storageSize" : 18460,
"numExtents" : 8,
"nindexes" : 1,
"lastExtentSize" : 7468,
"paddingFactor" : 1,
"systemFlags" : 1,
"userFlags" : 0,
"totalIndexSize" : 7,
"indexSizes" : {
"_id_" : 7
},
"ok" : 1
},
"shard2" : {
"ns" : "test.test",
"count" : 1256764,
"size" : 68729,
"avgObjSize" : 0.054687276210967216,
"storageSize" : 121032,
"numExtents" : 11,
"nindexes" : 1,
"lastExtentSize" : 36744,
"paddingFactor" : 1,
"systemFlags" : 1,
"userFlags" : 0,
"totalIndexSize" : 39834,
"indexSizes" : {
"_id_" : 39834
},
"ok" : 1
},
"shard3" : {
"ns" : "test.test",
"count" : 3642282,
"size" : 199187,
"avgObjSize" : 0.05468741849203329,
"storageSize" : 328024,
"numExtents" : 14,
"nindexes" : 1,
"lastExtentSize" : 90412,
"paddingFactor" : 1,
"systemFlags" : 1,
"userFlags" : 0,
"totalIndexSize" : 115621,
"indexSizes" : {
"_id_" : 115621
},
"ok" : 1
},
"shard4" : {
"ns" : "test.test",
"count" : 100954,
"size" : 5520,
"avgObjSize" : 0.05467836836579036,
"storageSize" : 21980,
"numExtents" : 7,
"nindexes" : 1,
"lastExtentSize" : 11060,
"paddingFactor" : 1,
"systemFlags" : 1,
"userFlags" : 0,
"totalIndexSize" : 3209,
"indexSizes" : {
"_id_" : 3209
},
"ok" : 1
},
"shard5" : {
"ns" : "test.test",
"count" : 0,
"size" : 0,
"storageSize" : 328024,
"numExtents" : 14,
"nindexes" : 1,
"lastExtentSize" : 90412,
"paddingFactor" : 1,
"systemFlags" : 1,
"userFlags" : 0,
"totalIndexSize" : 7,
"indexSizes" : {
"_id_" : 7
},
"ok" : 1
},
"shard6" : {
"ns" : "test.test",
"count" : 0,
"size" : 0,
"storageSize" : 21980,
"numExtents" : 7,
"nindexes" : 1,
"lastExtentSize" : 11060,
"paddingFactor" : 1,
"systemFlags" : 1,
"userFlags" : 0,
"totalIndexSize" : 7,
"indexSizes" : {
"_id_" : 7
},
"ok" : 1
}
},
"ok" : 1
}
用时约33分钟
查看集合状态
mongos> db.test.stats(1024)
{
"sharded" : true,
"ns" : "test.test",
"count" : 10000000,
"numExtents" : 81,
"size" : 546873,
"storageSize" : 1542568,
"totalIndexSize" : 316959,
"indexSizes" : {
"_id_" : 316959
},
"avgObjSize" : 0.0546873,
"nindexes" : 1, |
