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

Query optimization

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • Mongodb w\ 3 replicaset
      Red Hat Enterprise Linux Server release 7.6 (Maipo)

    Description

      Problem Statement/Rationale

      We're experiencing some severe slowness on a production database.

      We think it could be related to some unoptimized queries.

      We'd like the support to help us finding some queries improvement.

      Please be sure to attach relevant logs with any sensitive data redacted.

      Steps to Reproduce

      You could replicate the issue by implementing the same amount of logical operation as in the current queries,.

      Expected Results

      The queries should cause slowness on the entire system.

      Actual Results

      As said, we observed some severe slowness while these queries are running.

      Additional Notes

      We'd like to know if we could get some queries improvement or if we should evaluate a  server ram increase (or setting the cacheSize parameter, since only about the 50% of memory is being used)

      Attachments

        Activity

          People

            chris.kelly@mongodb.com Chris Kelly
            desk@sorint.it Sorint Lab
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: