-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: 3.4.18, 4.0.4
-
Component/s: Replication
-
Labels:
-
Query Execution
There are a lot of slow log in local database because of fetching oplog timeout.， and the execStats output is very confused for users.
{ "op" : "getmore", "ns" : "local.oplog.rs", "query" : { "getMore" : NumberLong("16632085288"), "collection" : "oplog.rs", "maxTimeMS" : NumberLong(5000), "term" : NumberLong(2), "lastKnownCommittedOpTime" : { "ts" : Timestamp(1543233013, 1), "t" : NumberLong(2) } }, "originatingCommand" : { "find" : "oplog.rs", "filter" : { "ts" : { "$gte" : Timestamp(1542179367, 1) } }, "tailable" : true, "oplogReplay" : true, "awaitData" : true, "maxTimeMS" : NumberLong(60000), "term" : NumberLong(2) }, "cursorid" : 16632085288, "keysExamined" : 0, "docsExamined" : 0, "numYield" : 1, "locks" : { "Global" : { "acquireCount" : { "r" : NumberLong(6) } }, "Database" : { "acquireCount" : { "r" : NumberLong(3) } }, "oplog" : { "acquireCount" : { "r" : NumberLong(3) } } }, "nreturned" : 0, "responseLength" : 451, "protocol" : "op_command", "millis" : 5000, "planSummary" : "COLLSCAN", "execStats" : { "stage" : "COLLSCAN", "nReturned" : 107219, "executionTimeMillisEstimate" : 8414, "works" : 1166542, "advanced" : 107219, "needTime" : 529661, "needYield" : 1, "saveState" : 741052, "restoreState" : 741052, "isEOF" : 0, "invalidates" : 0, "direction" : "forward", "docsExamined" : 107219 }, "ts" : ISODate("2018-11-26T11:50:18.104Z"), "client" : "11.221.235.27", "allUsers" : [ { "user" : "__system", "db" : "local" } ], "user" : "__system@local" }