Hello.

I have insert into the data is very slow, and I have check the mongod.log
file, seem is the split is very long time.

*shard key: { "_id" : "hashed" }*
*chunksize:64m*

Could you please help me if you have a moment?

Thanks.

Sat Aug 31 03:17:27.007 [conn227891] query
Spellbound_Smurf_Vo_User_Social.Smurf.Vo.User.Social query: { query: { _id:
{ $gt: "10000
2434589250" } }, orderby: { _id: 1.0 } } cursorid:979171091354177739
ntoreturn:500 ntoskip:0 nscanned:502 keyUpdates:0 numYields: 26
locks(micros) r:1193558 nreturned:500 reslen:759001 851ms
Sat Aug 31 03:17:27.078 [conn801949] request split points lookup for chunk
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session {
: -3074457345618258602 } -->> { : -2687574190631340339 }
Sat Aug 31 03:17:27.112 [conn802462] request split points lookup for chunk
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session {
: -3074457345618258602 } -->> { : -2687574190631340339 }
Sat Aug 31 03:17:27.210 [initandlisten] connection accepted from
10.126.105.209:36942 #802818 (1231 connections now open)
Sat Aug 31 03:17:27.216 [conn802818] request split points lookup for chunk
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session {
: -3074457345618258602 } -->> { : -2687574190631340339 }
Sat Aug 31 03:17:27.418 [conn802462] warning: Finding the split vector for
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session ov
er { _id: "hashed" } keyCount: 101067 numSplits: 1 lookedAt: 21815 took
306ms
Sat Aug 31 03:17:27.419 [conn802462] command admin.$cmd command: {
splitVector: "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Sess
ion", keyPattern: { _id: "hashed" }, min: { _id: -3074457345618258602 },
max: { _id: -2687574190631340339 }, maxChunkSizeBytes: 6710
8864, maxSplitPoints: 2, maxChunkObjects: 250000 } ntoreturn:1 keyUpdates:0
numYields: 225 locks(micros) r:492272 reslen:90 307ms
Sat Aug 31 03:17:27.420 [conn801949] warning: Finding the split vector for
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session ov
er { _id: "hashed" } keyCount: 101067 numSplits: 1 lookedAt: 21815 took
341ms
Sat Aug 31 03:17:27.420 [conn801949] command admin.$cmd command: {
splitVector: "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Sess
ion", keyPattern: { _id: "hashed" }, min: { _id: -3074457345618258602 },
max: { _id: -2687574190631340339 }, maxChunkSizeBytes: 6710
8864, maxSplitPoints: 2, maxChunkObjects: 250000 } ntoreturn:1 keyUpdates:0
numYields: 227 locks(micros) r:601027 reslen:90 341ms
Sat Aug 31 03:17:27.449 [conn802818] warning: Finding the split vector for
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session ov
er { _id: "hashed" } keyCount: 101067 numSplits: 1 lookedAt: 21815 took
233ms
Sat Aug 31 03:17:27.449 [conn802818] command admin.$cmd command: {
splitVector: "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Sess
ion", keyPattern: { _id: "hashed" }, min: { _id: -3074457345618258602 },
max: { _id: -2687574190631340339 }, maxChunkSizeBytes: 6710
8864, maxSplitPoints: 2, maxChunkObjects: 250000 } ntoreturn:1 keyUpdates:0
numYields: 183 locks(micros) r:340055 reslen:90 239ms
Sat Aug 31 03:17:31.390 [conn801418] query
Spellbound_Smurf_Vo_User_Social.Smurf.Vo.User.Social query: { _id: { $in: {
0: "100000005
309176", 3: "100000031456696", 12: "100000144459637", 20:
"100000287013881", 25: "100000417624481", 28: "100000462476779", 35: "1000
00506687384", 39: "100000534491178", 44: "100000558792599", 46:
"100000601382828", 48: "100000603220183", 50: "100000657283767", 61:
"100000862623875", 63: "100000878014240", 71: "100001094867849", 74:
"100001174976221", 82: "100001327519860", 90: "100001530294516
", 97: "100001812282384", 100: "100001851655320", 101: "100001902850203",
110: "100002224971248", 118: "100002509978733", 120: "1000
02523872324", 125: "100002627324870", 132: "100003057541064", 134:
"100003103751867", 147: "100003576077637", 150: "100003696638782"
, 152: "100003723393996", 154: "100003913716414", 155: "100003917903744",
172: "100005133881333", 177: "100005405071613", 181: "1000
05686350484", 187: "100005987256315", 204: "100006593370629", 210:
"1175670353", 215: "1284448182", 223: "1453624322", 226: "1517300
337", 230: "1534912987", 232: "1551166645", 235: "1573011460", 236:
"1574744605", 240: "1599291286", 250: "517261011", 256: "6027130
75", 261: "648493014", 262: "681644444" } } } ntoreturn:0 ntoskip:0
nscanned:56 keyUpdates:0 numYields: 1 locks(micros) r:223923 nre
turned:7 reslen:500 185ms
Sat Aug 31 03:17:31.390 [conn797475] update
Spellbound_Panda_Vo_User_Online.Panda.Vo.User.Online query: { _id:
"100004719517701" } u
pdate: { accessDate: 1377919051, _explicitType: "Panda.Vo.User.Online",
_id: "100004719517701" } idhack:1 nupdated:1 keyUpdates:0 lo
cks(micros) w:82 159ms
Sat Aug 31 03:17:31.390 [conn798085] update
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session query: { _id:
"100001157409620" }
update: { $set: { accessDate: "2013-08-31T03:17:31+00:00", requestCounts:
0, accessTimer: 0 } } idhack:1 nupdated:1 fastmod:1 keyUp
dates:0 locks(micros) w:84 159ms
Sat Aug 31 03:17:31.390 [conn798763] update
Spellbound_Smurf_Vo_User_Counter.Smurf.Vo.User.Counter query: { _id:
"100003699220862" }
update: { $set: { startedQuests.Story_1001.tasks.T1: "done" } } idhack:1
nupdated:1 keyUpdates:0 locks(micros) w:155 159ms
Sat Aug 31 03:17:27.078 [conn801949] request split points lookup for chunk
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session {
: -3074457345618258602 } -->> { : -2687574190631340339 }
Sat Aug 31 03:17:27.112 [conn802462] request split points lookup for chunk
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session {
: -3074457345618258602 } -->> { : -2687574190631340339 }
Sat Aug 31 03:17:27.210 [initandlisten] connection accepted from
10.126.105.209:36942 #802818 (1231 connections now open)
Sat Aug 31 03:17:27.216 [conn802818] request split points lookup for chunk
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session {
: -3074457345618258602 } -->> { : -2687574190631340339 }
Sat Aug 31 03:17:27.418 [conn802462] warning: Finding the split vector for
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session ov
er { _id: "hashed" } keyCount: 101067 numSplits: 1 lookedAt: 21815 took
306ms
Sat Aug 31 03:17:27.419 [conn802462] command admin.$cmd command: {
splitVector: "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Sess
ion", keyPattern: { _id: "hashed" }, min: { _id: -3074457345618258602 },
max: { _id: -2687574190631340339 }, maxChunkSizeBytes: 6710
8864, maxSplitPoints: 2, maxChunkObjects: 250000 } ntoreturn:1 keyUpdates:0
numYields: 225 locks(micros) r:492272 reslen:90 307ms
Sat Aug 31 03:17:27.420 [conn801949] warning: Finding the split vector for
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session ov
er { _id: "hashed" } keyCount: 101067 numSplits: 1 lookedAt: 21815 took
341ms
Sat Aug 31 03:17:27.420 [conn801949] command admin.$cmd command: {
splitVector: "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Sess
ion", keyPattern: { _id: "hashed" }, min: { _id: -3074457345618258602 },
max: { _id: -2687574190631340339 }, maxChunkSizeBytes: 6710
8864, maxSplitPoints: 2, maxChunkObjects: 250000 } ntoreturn:1 keyUpdates:0
numYields: 227 locks(micros) r:601027 reslen:90 341ms
Sat Aug 31 03:17:27.449 [conn802818] warning: Finding the split vector for
Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session ov
er { _id: "hashed" } keyCount: 101067 numSplits: 1 lookedAt: 21815 took
233ms
Sat Aug 31 03:17:27.449 [conn802818] command admin.$cmd command: {
splitVector: "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Sess
ion", keyPattern: { _id: "hashed" }, min: { _id: -3074457345618258602 },
max: { _id: -2687574190631340339 }, maxChunkSizeBytes: 6710
8864, maxSplitPoints: 2, maxChunkObjects: 250000 } ntoreturn:1 keyUpdates:0
numYields: 183 locks(micros) r:340055 reslen:90 239ms
Sat Aug 31 03:17:31.390 [conn801418] query
Spellbound_Smurf_Vo_User_Social.Smurf.Vo.User.Social query: { _id: { $in: {
0: "100000005
309176", 3: "100000031456696", 12: "100000144459637", 20:
"100000287013881", 25: "100000417624481", 28: "100000462476779", 35: "1000
00506687384", 39: "100000534491178", 44: "100000558792599", 46:
"100000601382828", 48: "100000603220183", 50: "100000657283767", 61:
"100000862623875", 63: "100000878014240", 71: "100001094867849", 74:
"100001174976221", 82: "100001327519860", 90: "100001530294516
", 97: "100001812282384", 100: "100001851655320", 101: "100001902850203",
110: "100002224971248", 118: "100002509978733", 120: "1000
02523872324", 125: "100002627324870", 132: "100003057541064", 134:
"100003103751867", 147: "100003576077637", 150: "100003696638782"
, 152: "100003723393996", 154: "100003913716414", 155: "100003917903744",
172: "100005133881333", 177: "100005405071613", 181: "1000
05686350484", 187: "100005987256315", 204: "100006593370629", 210:
"1175670353", 215: "1284448182", 223: "1453624322", 226: "1517300
337", 230: "1534912987", 232: "1551166645", 235: "1573011460", 236:
"1574744605", 240: "1599291286", 250: "517261011", 256: "6027130
75", 261: "648493014", 262: "681644444" } } } ntoreturn:0 ntoskip:0
nscanned:56 keyUpdates:0 numYields: 1 locks(micros) r:223923 nre
turned:7 reslen:500 185ms

--
--
You received this message because you are subscribed to the Google
Groups "mongodb-user" group.
To post to this group, send email to mongodb-user@googlegroups.com
To unsubscribe from this group, send email to
mongodb-user+unsubscribe@googlegroups.com
See also the IRC channel -- freenode.net#mongodb

---
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Search Discussions

  • 彪 杨 at Sep 2, 2013 at 2:45 am
    The collection '.Panda.Vo.User.Session' stats:

    mongos> db.Panda.Vo.User.Session.stats()
    {
             "sharded" : true,
             "ns" : "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session",
             "count" : 6522006,
             "numExtents" : 79,
             "size" : 2169689440,
             "storageSize" : 2979332096,
             "totalIndexSize" : 620909968,
             "indexSizes" : {
                     "_id_" : 314097392,
                     "_id_hashed" : 306812576
             },
             "avgObjSize" : 332.6721011909526,
             "nindexes" : 2,
             "nchunks" : 48,
             "shards" : {
                     "sco2set_a" : {
                             "ns" :
    "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session",
                             "count" : 1227832,
                             "size" : 408497376,
                             "avgObjSize" : 332.6981020204719,
                             "storageSize" : 629612544,
                             "numExtents" : 16,
                             "nindexes" : 2,
                             "lastExtentSize" : 168730624,
                             "paddingFactor" : 1.0000000000040825,
                             "systemFlags" : 1,
                             "userFlags" : 0,
                             "totalIndexSize" : 120873984,
                             "indexSizes" : {
                                     "_id_" : 62546400,
                                     "_id_hashed" : 58327584
                             },
                             "ok" : 1
                     },
                     "sco2set_b" : {
                             "ns" :
    "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session",
                             "count" : 1358435,
                             "size" : 451935168,
                             "avgObjSize" : 332.68810653435753,
                             "storageSize" : 629612544,
                             "numExtents" : 16,
                             "nindexes" : 2,
                             "lastExtentSize" : 168730624,
                             "paddingFactor" : 1.0000000000038276,
                             "systemFlags" : 1,
                             "userFlags" : 0,
                             "totalIndexSize" : 126785232,
                             "indexSizes" : {
                                     "_id_" : 64386000,
                                     "_id_hashed" : 62399232
                             },
                             "ok" : 1
                     },
                     "sco2set_c" : {
                             "ns" :
    "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session",
                             "count" : 1358765,
                             "size" : 452063168,
                             "avgObjSize" : 332.70151056290086,
                             "storageSize" : 629612544,
                             "numExtents" : 16,
                             "nindexes" : 2,
                             "lastExtentSize" : 168730624,
                             "paddingFactor" : 1.0000000000038867,
                             "systemFlags" : 1,
                             "userFlags" : 0,
                             "totalIndexSize" : 129655008,
                             "indexSizes" : {
                                     "_id_" : 64729392,
                                     "_id_hashed" : 64925616
                             },
                             "ok" : 1
                     },
                     "sco2set_d" : {
                             "ns" :
    "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session",
                             "count" : 1355678,
                             "size" : 450989120,
                             "avgObjSize" : 332.66684271633824,
                             "storageSize" : 629612544,
                             "numExtents" : 16,
                             "nindexes" : 2,
                             "lastExtentSize" : 168730624,
                             "paddingFactor" : 1.000000000002713,
                             "systemFlags" : 1,
                             "userFlags" : 0,
                             "totalIndexSize" : 129164448,
                             "indexSizes" : {
                                     "_id_" : 64214304,
                                     "_id_hashed" : 64950144
                             },
                             "ok" : 1
                     },
                     "sco2set_e" : {
                             "ns" :
    "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session",
                             "count" : 1221296,
                             "size" : 406204608,
                             "avgObjSize" : 332.6012760215378,
                             "storageSize" : 460881920,
                             "numExtents" : 15,
                             "nindexes" : 2,
                             "lastExtentSize" : 124985344,
                             "paddingFactor" : 1.0000000000003868,
                             "systemFlags" : 1,
                             "userFlags" : 0,
                             "totalIndexSize" : 114431296,
                             "indexSizes" : {
                                     "_id_" : 58221296,
                                     "_id_hashed" : 56210000
                             },
                             "ok" : 1
                     }
             },
             "ok" : 1
    }
    On Monday, September 2, 2013 10:41:26 AM UTC+8, 彪 杨 wrote:

    Hello.

    I have insert into the data is very slow, and I have check the mongod.log
    file, seem is the split is very long time.

    *shard key: { "_id" : "hashed" }*
    *chunksize:64m*

    Could you please help me if you have a moment?

    Thanks.

    Sat Aug 31 03:17:27.007 [conn227891] query
    Spellbound_Smurf_Vo_User_Social.Smurf.Vo.User.Social query: { query: { _id:
    { $gt: "10000
    2434589250" } }, orderby: { _id: 1.0 } } cursorid:979171091354177739
    ntoreturn:500 ntoskip:0 nscanned:502 keyUpdates:0 numYields: 26
    locks(micros) r:1193558 nreturned:500 reslen:759001 851ms
    Sat Aug 31 03:17:27.078 [conn801949] request split points lookup for chunk
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session {
    : -3074457345618258602 } -->> { : -2687574190631340339 }
    Sat Aug 31 03:17:27.112 [conn802462] request split points lookup for chunk
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session {
    : -3074457345618258602 } -->> { : -2687574190631340339 }
    Sat Aug 31 03:17:27.210 [initandlisten] connection accepted from
    10.126.105.209:36942 #802818 (1231 connections now open)
    Sat Aug 31 03:17:27.216 [conn802818] request split points lookup for chunk
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session {
    : -3074457345618258602 } -->> { : -2687574190631340339 }
    Sat Aug 31 03:17:27.418 [conn802462] warning: Finding the split vector for
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session ov
    er { _id: "hashed" } keyCount: 101067 numSplits: 1 lookedAt: 21815 took
    306ms
    Sat Aug 31 03:17:27.419 [conn802462] command admin.$cmd command: {
    splitVector: "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Sess
    ion", keyPattern: { _id: "hashed" }, min: { _id: -3074457345618258602 },
    max: { _id: -2687574190631340339 }, maxChunkSizeBytes: 6710
    8864, maxSplitPoints: 2, maxChunkObjects: 250000 } ntoreturn:1
    keyUpdates:0 numYields: 225 locks(micros) r:492272 reslen:90 307ms
    Sat Aug 31 03:17:27.420 [conn801949] warning: Finding the split vector for
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session ov
    er { _id: "hashed" } keyCount: 101067 numSplits: 1 lookedAt: 21815 took
    341ms
    Sat Aug 31 03:17:27.420 [conn801949] command admin.$cmd command: {
    splitVector: "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Sess
    ion", keyPattern: { _id: "hashed" }, min: { _id: -3074457345618258602 },
    max: { _id: -2687574190631340339 }, maxChunkSizeBytes: 6710
    8864, maxSplitPoints: 2, maxChunkObjects: 250000 } ntoreturn:1
    keyUpdates:0 numYields: 227 locks(micros) r:601027 reslen:90 341ms
    Sat Aug 31 03:17:27.449 [conn802818] warning: Finding the split vector for
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session ov
    er { _id: "hashed" } keyCount: 101067 numSplits: 1 lookedAt: 21815 took
    233ms
    Sat Aug 31 03:17:27.449 [conn802818] command admin.$cmd command: {
    splitVector: "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Sess
    ion", keyPattern: { _id: "hashed" }, min: { _id: -3074457345618258602 },
    max: { _id: -2687574190631340339 }, maxChunkSizeBytes: 6710
    8864, maxSplitPoints: 2, maxChunkObjects: 250000 } ntoreturn:1
    keyUpdates:0 numYields: 183 locks(micros) r:340055 reslen:90 239ms
    Sat Aug 31 03:17:31.390 [conn801418] query
    Spellbound_Smurf_Vo_User_Social.Smurf.Vo.User.Social query: { _id: { $in: {
    0: "100000005
    309176", 3: "100000031456696", 12: "100000144459637", 20:
    "100000287013881", 25: "100000417624481", 28: "100000462476779", 35: "1000
    00506687384", 39: "100000534491178", 44: "100000558792599", 46:
    "100000601382828", 48: "100000603220183", 50: "100000657283767", 61:
    "100000862623875", 63: "100000878014240", 71: "100001094867849", 74:
    "100001174976221", 82: "100001327519860", 90: "100001530294516
    ", 97: "100001812282384", 100: "100001851655320", 101: "100001902850203",
    110: "100002224971248", 118: "100002509978733", 120: "1000
    02523872324", 125: "100002627324870", 132: "100003057541064", 134:
    "100003103751867", 147: "100003576077637", 150: "100003696638782"
    , 152: "100003723393996", 154: "100003913716414", 155: "100003917903744",
    172: "100005133881333", 177: "100005405071613", 181: "1000
    05686350484", 187: "100005987256315", 204: "100006593370629", 210:
    "1175670353", 215: "1284448182", 223: "1453624322", 226: "1517300
    337", 230: "1534912987", 232: "1551166645", 235: "1573011460", 236:
    "1574744605", 240: "1599291286", 250: "517261011", 256: "6027130
    75", 261: "648493014", 262: "681644444" } } } ntoreturn:0 ntoskip:0
    nscanned:56 keyUpdates:0 numYields: 1 locks(micros) r:223923 nre
    turned:7 reslen:500 185ms
    Sat Aug 31 03:17:31.390 [conn797475] update
    Spellbound_Panda_Vo_User_Online.Panda.Vo.User.Online query: { _id:
    "100004719517701" } u
    pdate: { accessDate: 1377919051, _explicitType: "Panda.Vo.User.Online",
    _id: "100004719517701" } idhack:1 nupdated:1 keyUpdates:0 lo
    cks(micros) w:82 159ms
    Sat Aug 31 03:17:31.390 [conn798085] update
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session query: { _id:
    "100001157409620" }
    update: { $set: { accessDate: "2013-08-31T03:17:31+00:00", requestCounts:
    0, accessTimer: 0 } } idhack:1 nupdated:1 fastmod:1 keyUp
    dates:0 locks(micros) w:84 159ms
    Sat Aug 31 03:17:31.390 [conn798763] update
    Spellbound_Smurf_Vo_User_Counter.Smurf.Vo.User.Counter query: { _id:
    "100003699220862" }
    update: { $set: { startedQuests.Story_1001.tasks.T1: "done" } } idhack:1
    nupdated:1 keyUpdates:0 locks(micros) w:155 159ms
    Sat Aug 31 03:17:27.078 [conn801949] request split points lookup for chunk
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session {
    : -3074457345618258602 } -->> { : -2687574190631340339 }
    Sat Aug 31 03:17:27.112 [conn802462] request split points lookup for chunk
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session {
    : -3074457345618258602 } -->> { : -2687574190631340339 }
    Sat Aug 31 03:17:27.210 [initandlisten] connection accepted from
    10.126.105.209:36942 #802818 (1231 connections now open)
    Sat Aug 31 03:17:27.216 [conn802818] request split points lookup for chunk
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session {
    : -3074457345618258602 } -->> { : -2687574190631340339 }
    Sat Aug 31 03:17:27.418 [conn802462] warning: Finding the split vector for
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session ov
    er { _id: "hashed" } keyCount: 101067 numSplits: 1 lookedAt: 21815 took
    306ms
    Sat Aug 31 03:17:27.419 [conn802462] command admin.$cmd command: {
    splitVector: "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Sess
    ion", keyPattern: { _id: "hashed" }, min: { _id: -3074457345618258602 },
    max: { _id: -2687574190631340339 }, maxChunkSizeBytes: 6710
    8864, maxSplitPoints: 2, maxChunkObjects: 250000 } ntoreturn:1
    keyUpdates:0 numYields: 225 locks(micros) r:492272 reslen:90 307ms
    Sat Aug 31 03:17:27.420 [conn801949] warning: Finding the split vector for
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session ov
    er { _id: "hashed" } keyCount: 101067 numSplits: 1 lookedAt: 21815 took
    341ms
    Sat Aug 31 03:17:27.420 [conn801949] command admin.$cmd command: {
    splitVector: "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Sess
    ion", keyPattern: { _id: "hashed" }, min: { _id: -3074457345618258602 },
    max: { _id: -2687574190631340339 }, maxChunkSizeBytes: 6710
    8864, maxSplitPoints: 2, maxChunkObjects: 250000 } ntoreturn:1
    keyUpdates:0 numYields: 227 locks(micros) r:601027 reslen:90 341ms
    Sat Aug 31 03:17:27.449 [conn802818] warning: Finding the split vector for
    Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Session ov
    er { _id: "hashed" } keyCount: 101067 numSplits: 1 lookedAt: 21815 took
    233ms
    Sat Aug 31 03:17:27.449 [conn802818] command admin.$cmd command: {
    splitVector: "Spellbound_Panda_Vo_User_Session.Panda.Vo.User.Sess
    ion", keyPattern: { _id: "hashed" }, min: { _id: -3074457345618258602 },
    max: { _id: -2687574190631340339 }, maxChunkSizeBytes: 6710
    8864, maxSplitPoints: 2, maxChunkObjects: 250000 } ntoreturn:1
    keyUpdates:0 numYields: 183 locks(micros) r:340055 reslen:90 239ms
    Sat Aug 31 03:17:31.390 [conn801418] query
    Spellbound_Smurf_Vo_User_Social.Smurf.Vo.User.Social query: { _id: { $in: {
    0: "100000005
    309176", 3: "100000031456696", 12: "100000144459637", 20:
    "100000287013881", 25: "100000417624481", 28: "100000462476779", 35: "1000
    00506687384", 39: "100000534491178", 44: "100000558792599", 46:
    "100000601382828", 48: "100000603220183", 50: "100000657283767", 61:
    "100000862623875", 63: "100000878014240", 71: "100001094867849", 74:
    "100001174976221", 82: "100001327519860", 90: "100001530294516
    ", 97: "100001812282384", 100: "100001851655320", 101: "100001902850203",
    110: "100002224971248", 118: "100002509978733", 120: "1000
    02523872324", 125: "100002627324870", 132: "100003057541064", 134:
    "100003103751867", 147: "100003576077637", 150: "100003696638782"
    , 152: "100003723393996", 154: "100003913716414", 155: "100003917903744",
    172: "100005133881333", 177: "100005405071613", 181: "1000
    05686350484", 187: "100005987256315", 204: "100006593370629", 210:
    "1175670353", 215: "1284448182", 223: "1453624322", 226: "1517300
    337", 230: "1534912987", 232: "1551166645", 235: "1573011460", 236:
    "1574744605", 240: "1599291286", 250: "517261011", 256: "6027130
    75", 261: "648493014", 262: "681644444" } } } ntoreturn:0 ntoskip:0
    nscanned:56 keyUpdates:0 numYields: 1 locks(micros) r:223923 nre
    turned:7 reslen:500 185ms
    --
    --
    You received this message because you are subscribed to the Google
    Groups "mongodb-user" group.
    To post to this group, send email to mongodb-user@googlegroups.com
    To unsubscribe from this group, send email to
    mongodb-user+unsubscribe@googlegroups.com
    See also the IRC channel -- freenode.net#mongodb

    ---
    You received this message because you are subscribed to the Google Groups "mongodb-user" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user+unsubscribe@googlegroups.com.
    For more options, visit https://groups.google.com/groups/opt_out.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupmongodb-user @
categoriesmongodb
postedSep 2, '13 at 2:41a
activeSep 2, '13 at 2:45a
posts2
users1
websitemongodb.org
irc#mongodb

1 user in discussion

彪 杨: 2 posts

People

Translate

site design / logo © 2022 Grokbase