-
Type:
Question
-
Resolution: Done
-
Priority:
Major - P3
-
None
-
Affects Version/s: 4.0.12
-
Component/s: None
-
Labels:None
Hi,support !
We find the slow queries about below(these queries all use shard key filter , and i tried to adjust wt cache lower(to decrease io usage) ,but did't work, i provide logs ,diag data and i need you to help me reslove the issue):
//2021-08-06T18:14:39.413+0800 I COMMAND [conn283674] command dmsBik4Bos.bik4bos command: find { find: "bik4bos", filter: { bikeNo: "7780170950" }, projection: { bizType: 1, rideStatus: 1, bikeType: 1, pos.lat: 1, pos.lng: 1, pos.type: 1, pos.timeStamp: 1, alert: 1, alertMsg: 1, lock: 1, licensePlateNo: 1, lastMaintainTime: 1, serviceAreaId: 1, zeroBatteryScanCount: 1, smallAreaId: 1, rackDeployTime: 1, manualLabel: 1, manualLabelMsg: 1, fault: 1, faultMsg: 1, cityGuid: 1, modelGuid: 1, largeBatteryPercent: 1, opFaultCheck: 1, bikeNo: 1, lockVersion: 1, bigAreaId: 1, siteId: 1, opFault: 1, gridId: 1, opStatus: 1, licensePlateType: 1, lastScanUser: 1 }, limit: 1, singleBatch: true, $db: "dmsBik4Bos", $clusterTime: { clusterTime: Timestamp(1628244877, 3136), signature: { hash: BinData(0, 8BF6B66C9B87883E83465F8833EFAC596C2026FE), keyId: 6962514570933960916 } }, lsid: { id: UUID("a26797f2-7427-471f-9dab-3c2fa649560f") }, $readPreference: { mode: "primaryPreferred" } } nShards:1 cursorExhausted:1 numYields:0 nreturned:1 reslen:1980 protocol:op_msg 1799ms