Created
July 6, 2013 19:25
-
-
Save benwbrum/5940952 to your computer and use it in GitHub Desktop.
13m record slow-down -- operations running after performance dropped to 100K records/hour or less
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| > db.currentOp(); | |
| { | |
| "inprog" : [ | |
| { | |
| "opid" : 60432862, | |
| "active" : true, | |
| "secs_running" : 0, | |
| "op" : "insert", | |
| "ns" : "mv_20130601.search_records", | |
| "insert" : { | |
| }, | |
| "client" : "127.0.0.1:42705", | |
| "desc" : "conn21", | |
| "threadId" : "0x7f1c8e720700", | |
| "connectionId" : 21, | |
| "locks" : { | |
| "^" : "w" | |
| }, | |
| "waitingForLock" : false, | |
| "numYields" : 0, | |
| "lockStats" : { | |
| "timeLockedMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(84) | |
| }, | |
| "timeAcquiringMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(174358) | |
| } | |
| } | |
| }, | |
| { | |
| "opid" : 60432864, | |
| "active" : true, | |
| "secs_running" : 0, | |
| "op" : "insert", | |
| "ns" : "mv_20130601.freereg1_csv_entries", | |
| "insert" : { | |
| }, | |
| "client" : "127.0.0.1:43665", | |
| "desc" : "conn46", | |
| "threadId" : "0x7f1c8f029700", | |
| "connectionId" : 46, | |
| "locks" : { | |
| "^" : "w" | |
| }, | |
| "waitingForLock" : false, | |
| "numYields" : 0, | |
| "lockStats" : { | |
| "timeLockedMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(37) | |
| }, | |
| "timeAcquiringMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(3) | |
| } | |
| } | |
| }, | |
| { | |
| "opid" : 60432857, | |
| "active" : true, | |
| "secs_running" : 0, | |
| "op" : "insert", | |
| "ns" : "mv_20130601.freereg1_csv_entries", | |
| "insert" : { | |
| }, | |
| "client" : "127.0.0.1:43666", | |
| "desc" : "conn47", | |
| "threadId" : "0x7f1c8e922700", | |
| "connectionId" : 47, | |
| "locks" : { | |
| "^" : "w" | |
| }, | |
| "waitingForLock" : false, | |
| "numYields" : 0, | |
| "lockStats" : { | |
| "timeLockedMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(71) | |
| }, | |
| "timeAcquiringMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(407699) | |
| } | |
| } | |
| }, | |
| { | |
| "opid" : 60432861, | |
| "active" : true, | |
| "secs_running" : 0, | |
| "op" : "insert", | |
| "ns" : "mv_20130601.search_records", | |
| "insert" : { | |
| }, | |
| "client" : "127.0.0.1:42692", | |
| "desc" : "conn8", | |
| "threadId" : "0x7f1c8ef28700", | |
| "connectionId" : 8, | |
| "locks" : { | |
| "^" : "w" | |
| }, | |
| "waitingForLock" : false, | |
| "numYields" : 0, | |
| "lockStats" : { | |
| "timeLockedMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(46) | |
| }, | |
| "timeAcquiringMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(292) | |
| } | |
| } | |
| }, | |
| { | |
| "opid" : 60432860, | |
| "active" : true, | |
| "secs_running" : 0, | |
| "op" : "insert", | |
| "ns" : "mv_20130601.search_records", | |
| "insert" : { | |
| }, | |
| "client" : "127.0.0.1:43668", | |
| "desc" : "conn49", | |
| "threadId" : "0x7f1c8ec25700", | |
| "connectionId" : 49, | |
| "locks" : { | |
| "^" : "w" | |
| }, | |
| "waitingForLock" : false, | |
| "numYields" : 0, | |
| "lockStats" : { | |
| "timeLockedMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(74) | |
| }, | |
| "timeAcquiringMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(38) | |
| } | |
| } | |
| }, | |
| { | |
| "opid" : 60432851, | |
| "active" : true, | |
| "secs_running" : 0, | |
| "op" : "insert", | |
| "ns" : "mv_20130601.search_records", | |
| "insert" : { | |
| }, | |
| "client" : "127.0.0.1:42753", | |
| "desc" : "conn26", | |
| "threadId" : "0x7f1c8ee27700", | |
| "connectionId" : 26, | |
| "locks" : { | |
| "^" : "w" | |
| }, | |
| "waitingForLock" : false, | |
| "numYields" : 0, | |
| "lockStats" : { | |
| "timeLockedMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(74) | |
| }, | |
| "timeAcquiringMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(830477) | |
| } | |
| } | |
| }, | |
| { | |
| "opid" : 60432852, | |
| "active" : true, | |
| "secs_running" : 0, | |
| "op" : "insert", | |
| "ns" : "mv_20130601.freereg1_csv_entries", | |
| "insert" : { | |
| }, | |
| "client" : "127.0.0.1:43663", | |
| "desc" : "conn44", | |
| "threadId" : "0x7f1c8ea23700", | |
| "connectionId" : 44, | |
| "locks" : { | |
| "^" : "w" | |
| }, | |
| "waitingForLock" : false, | |
| "numYields" : 0, | |
| "lockStats" : { | |
| "timeLockedMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(46) | |
| }, | |
| "timeAcquiringMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(830198) | |
| } | |
| } | |
| }, | |
| { | |
| "opid" : 60432863, | |
| "active" : true, | |
| "secs_running" : 0, | |
| "op" : "insert", | |
| "ns" : "mv_20130601.search_records", | |
| "insert" : { | |
| }, | |
| "client" : "127.0.0.1:43558", | |
| "desc" : "conn31", | |
| "threadId" : "0x7f1c8e821700", | |
| "connectionId" : 31, | |
| "locks" : { | |
| "^" : "w" | |
| }, | |
| "waitingForLock" : false, | |
| "numYields" : 0, | |
| "lockStats" : { | |
| "timeLockedMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(90) | |
| }, | |
| "timeAcquiringMicros" : { | |
| "r" : NumberLong(0), | |
| "w" : NumberLong(75610) | |
| } | |
| } | |
| } | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment