Hi @MaBeuLux88_xxx,
I don’t observe saturation for CPU, RAM, IOPS.
Swapping disabled.
The developers claim they don’t use such queries .
The full log message:
{"t":{"$date":"2021-01-26T12:21:07.922+03:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn410437","msg":"Slow query","attr":{"type":"command","ns":"zzz.$cmd","command":{"update":"xxx.yyy","ordered":false,"lsid":{"id":{"$uuid":"2fbe313b-2d87-4f18-8a1b-36321d373c32"}},"txnNumber":156218,"$clusterTime":{"clusterTime":{"$timestamp":{"t":1611652867,"i":1835}},"signature":{"hash":{"$binary":{"base64":"AAAAAAAAAAAAAAAAAAAAAAAAAAA=","subType":"0"}},"keyId":0}},"$db":"irkkt"},"numYields":15,"reslen":245,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":115}},"ReplicationStateTransition":{"acquireCount":{"w":116}},"Global":{"acquireCount":{"w":115}},"Database":{"acquireCount":{"w":115}},"Collection":{"acquireCount":{"w":115}},"Mutex":{"acquireCount":{"r":100}}},"flowControl":{"acquireCount":65,"timeAcquiringMicros":65},"storage":{"data":{"bytesRead":20458,"bytesWritten":2135043,"timeReadingMicros":270,"timeWritingMicros":12256},"timeWaitingMicros":{"cache":626588}},"protocol":"op_msg","durationMillis":698}}
In Studio 3T, I see a collection scan, but I’m not sure if I looked right.
Best regards,
Konstantin