1. 背景
mongoDB版本1.8.1
collection stats
> db.user.gift.stats() { "ns" : "statgame.user.gift", "count" : 650, "size" : 162804, "avgObjSize" : 250.46769230769232, "storageSize" : 696320, "numExtents" : 4, "nindexes" : 3, "lastExtentSize" : 524288, "paddingFactor" : 1.0099999999999576, "flags" : 1, "totalIndexSize" : 180224, "indexSizes" : { "_id_" : 40960, "day_1_userId_1_fromId_1_sceneId_1" : 81920, "idx_modified_time_long" : 57344 }, "ok" : 1 } |
indexes
> db.user.gift.getIndexes() [ { "name" : "_id_", "ns" : "statgame.user.gift", "key" : { "_id" : 1 } }, { "name" : "day_1_userId_1_fromId_1_sceneId_1", "ns" : "statgame.user.gift", "unique" : true, "key" : { "day" : 1, "userId" : 1, "fromId" : 1, "sceneId" : 1 } |