Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-69797

Negative bytes read metric in slow query log lines

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Major - P3 Major - P3
    • None
    • 4.4.12
    • None
    • None
    • ALL
    • Hide

      Unknown

      Show
      Unknown
    • Execution Team 2023-02-20, Execution Team 2023-02-06, Execution Team 2023-03-06, Execution Team 2023-03-20, Execution Team 2023-04-17

    Description

      This result was identified while diagnosing a performance issue on Atlas. 

      {find: projectDocument filter: {_and: \\\{opportunities.orderInfo.orderNumber: {_exists: true _ne: null}}, \\\{opportunities.orderInfo.cwOrderId: {_exists: false}}} _db: rhdo-gallery-project-service-staging _clusterTime: {clusterTime: {_timestamp: {t: 1645959584 i: 2}} signature: {hash: {_binary: {base64: WK0oU7yTsO1sL5k3qTq5y4OnZrM= subType: 0}} keyId: 7005939129837945000}} lsid: {id: {_uuid: 0c6daeb3-bbe5-4be5-99e3-93cbf21c6563}}} planSummary: IXSCAN
      Unknown macro: { opportunities.orderInfo.cwOrderId}
      keysExamined: 111623 docsExamined: 109506 cursorExhausted: true numYields: 4993 nreturned: 23 queryHash: 274C58B8 planCacheKey: 1A09723E reslen: 985644 locks: {ReplicationStateTransition: {acquireCount: {w: 4994}} Global: {acquireCount: {r: 4994}} Database: {acquireCount: {r: 4994}} Collection: {acquireCount: {r: 4994}} Mutex:
      Unknown macro: {acquireCount}
      }} storage: {data: {bytesRead: -1890016436 timeReadingMicros: 158488225}}protocol: op_msg durationMillis: 159718

       

      The server was behaving normally, albeit with fairly degraded performance due to the workload. This entry was identified while reviewing the logs for potential index optimizations.

       

       

      Attachments

        Activity

          People

            henrik.edin@mongodb.com Henrik Edin
            khalen.fredieu@mongodb.com Khalen Fredieu
            Votes:
            1 Vote for this issue
            Watchers:
            19 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: