I’ve migrated mongo replica set from 4.2.5 to 4.4.13. Suddenly performance of queries, which use multikey index, has dropped significantly. Preference of queries is secondaryPreferred
The pattern of Slow log
warrnings is
"keysExamined": 24,
"docsExamined": 24,
"numYields": 8,
"nreturned": 24,
"reslen": 639001,
"locks": {
"ReplicationStateTransition": {
"acquireCount": {
"w": 9
}
},
"Global": {
"acquireCount": {
"r": 9
}
},
"Database": {
"acquireCount": {
"r": 9
}
},
"Collection": {
"acquireCount": {
"r": 9
}
},
"Mutex": {
"acquireCount": {
"r": 1
}
}
},
"storage": {},
"protocol": "op_msg",
"durationMillis": 174
Could someone provide any clues? Can it be related with locks.ReplicationStateInfo