CPU regression in MongoDB for find operations with $in and deep projections

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      I've encountered a critical performance issue in MongoDB 8.0.15 - 8.0.20. I need your help diagnosing and finding a solution.

      After upgrading from version 8.0.14 to any of the versions 8.0.15 - 8.0.20, I observed a sharp increase in CPU consumption when executing identical queries. Rolling back to 8.0.14 completely returns performance to normal.

      Are there any known MongoDB Jira tickets describing this issue?

      I'm attaching a partial log of the slow operation from production:
       
      {{"planSummary": "IXSCAN { _id: 1 }","planningTimeMicros": 1963814,"keysExamined": 45,"docsExamined": 28,"nBatches": 1,"cursorExhausted": true,"numYields": 0,"nreturned": 28,"planCacheShapeHash": "DA96103F","queryHash": "DA96103F","planCacheKey": "8A0CFE77","queryFramework": "classic","reslen": 230741,"locks": {"Global": {"acquireCount":

      { "r": 1 }

      }},"readConcern":

      {"level": "local","provenance": "implicitDefault"}

      ,"storage": {"data": {"bytesRead": 880648,"timeReadingMicros": 57}},"cpuNanos": 259307384,"remote": "ip:55162","protocol": "op_msg","queues": {"ingress":

      { "admissions": 1 }

      ,"execution": { "admissions": 2, "totalTimeQueuedMicros": 1581208 }},"workingMillis": 416,"durationMillis": 1997}}}}

            Assignee:
            Server Triage Escalation
            Reporter:
            Денис Трачевский
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: