Details
-
Bug
-
Resolution: Done
-
Major - P3
-
None
-
None
-
None
-
None
-
Server Triage
-
ALL
Description
hello:
my mongo cluster has three mongos with six shard with three members.
now i find too many slow log on mongos.now has 200000+ every hour.but
just has little slow log on all shards.
but it is still slow.on mongos is 1484ms,but on shard is 1ms.
more mongos.log |grep 1234567
|
{"t":
|
|
|
{"$date":"2022-05-14T13:24:22.449+08:00"}
|
,"s":"I", "c":"COMMAND", "id":51803,
|
"ctx":"conn587389","msg":"Slow query","attr":{"type":"command","ns":"xiaoxu.orderMail",
|
"command":{"find":"OrderMail","filter":{"$and":[
|
|
|
{"mailNo":"1234567"}
|
,{"createTime":{"$gte":
|
|
|
{"$date":"2022-04-14T05:24:20.968Z"}
|
}},
|
{"createTime":{"$lte":
|
|
|
{"$date":"2022-05-15T05:24:20.968Z"}
|
}}]},"sort":
|
|
|
{"createTime":-1}
|
,
|
"nShards":1,"cursorExhausted":true,"numYields":0,
|
"nreturned":0,"reslen":234,"protocol":"op_msg","durationMillis":1484}}
|
more shard1.log
{"t":
|
|
|
{"$date":"2022-05-14T13:24:22.449+08:00"}
|
,"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn410512","msg":"Slow query",
|
"attr":{"type":"command","ns":"xiaoxu.OrderMail","command":{"find":"OrderMail","filter":{"$and":[
|
|
|
{"mailNo":"1234567"}
|
,
|
{"createTime":{"$gte":
|
|
|
{"$date":"2022-04-14T05:24:20.968Z"}
|
}},{"createTime":{"$lte":
|
|
|
{"$date":"2022-05-15T05:24:20.968Z"}
|
}}]},
|
"sort":
|
|
|
{"createTime":-1}
|
,
|
"storage":{},"protocol":"op_msg","durationMillis":1}}
|