-
Type:
Bug
-
Resolution: Done
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Labels:None
-
Server Triage
-
ALL
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}}