• Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Environment:
      Mongodb w\ 3 replicaset
      Red Hat Enterprise Linux Server release 7.6 (Maipo)

      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)

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

              Created:
              Updated:
              Resolved: