|
I confirm, updating to 2.2.0 seems to solve the issue.
I just replayed the session and it worked as expected:
mongos> db.offer.count({shopId: 205640})
|
131032
|
mongos> var count = 0;
|
mongos> var cursor = db.offer.find({shopId: 205640}).batchSize(1000);
|
mongos> while(cursor.hasNext()){cursor.next(); count++;}
|
131031
|
mongos> db.offer.find({shopId: 205640}).batchSize(1000).explain()
|
{
|
"clusteredType" : "ParallelSort",
|
"shards" : {
|
"offerStoreDE2/s127:27018,s131:27018,s136:27018" : [
|
{
|
"cursor" : "BtreeCursor shopId_1_merchantId_1",
|
"isMultiKey" : false,
|
"n" : 50699,
|
"nscannedObjects" : 50699,
|
"nscanned" : 50699,
|
"nscannedObjectsAllPlans" : 50699,
|
"nscannedAllPlans" : 50699,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nYields" : 217,
|
"nChunkSkips" : 0,
|
"millis" : 480,
|
"indexBounds" : {
|
"shopId" : [
|
[
|
205640,
|
205640
|
]
|
],
|
"merchantId" : [
|
[
|
{
|
"$minElement" : 1
|
},
|
{
|
"$maxElement" : 1
|
}
|
]
|
]
|
},
|
"server" : "s136:27018"
|
}
|
],
|
"offerStoreDE3/s117:27018,s124:27018,s129:27018" : [
|
{
|
"cursor" : "BtreeCursor shopId_1_merchantId_1",
|
"isMultiKey" : false,
|
"n" : 77002,
|
"nscannedObjects" : 77002,
|
"nscanned" : 77002,
|
"nscannedObjectsAllPlans" : 77002,
|
"nscannedAllPlans" : 77002,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nYields" : 596,
|
"nChunkSkips" : 0,
|
"millis" : 422,
|
"indexBounds" : {
|
"shopId" : [
|
[
|
205640,
|
205640
|
]
|
],
|
"merchantId" : [
|
[
|
{
|
"$minElement" : 1
|
},
|
{
|
"$maxElement" : 1
|
}
|
]
|
]
|
},
|
"server" : "s129:27018"
|
}
|
],
|
"offerStoreDE4/s115:27018,s125:27018,s132:27018" : [
|
{
|
"cursor" : "BtreeCursor shopId_1_merchantId_1",
|
"isMultiKey" : false,
|
"n" : 3331,
|
"nscannedObjects" : 3331,
|
"nscanned" : 3331,
|
"nscannedObjectsAllPlans" : 3331,
|
"nscannedAllPlans" : 3331,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nYields" : 17,
|
"nChunkSkips" : 0,
|
"millis" : 40,
|
"indexBounds" : {
|
"shopId" : [
|
[
|
205640,
|
205640
|
]
|
],
|
"merchantId" : [
|
[
|
{
|
"$minElement" : 1
|
},
|
{
|
"$maxElement" : 1
|
}
|
]
|
]
|
},
|
"server" : "s125:27018"
|
}
|
]
|
},
|
"cursor" : "BtreeCursor shopId_1_merchantId_1",
|
"n" : 131032,
|
"nChunkSkips" : 0,
|
"nYields" : 830,
|
"nscanned" : 131032,
|
"nscannedAllPlans" : 131032,
|
"nscannedObjects" : 131032,
|
"nscannedObjectsAllPlans" : 131032,
|
"millisShardTotal" : 942,
|
"millisShardAvg" : 314,
|
"numQueries" : 3,
|
"numShards" : 3,
|
"millis" : 484
|
}
|
|