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

Increase default value of internalQueryMaxBlockingSortMemoryUsageBytes knob

    • Type: Icon: Task Task
    • Resolution: Won't Fix
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • QE 2024-06-10
    • 200

      After the change in SERVER-82037, the memory needed for the iterators
      is taken out of the sorter's maxMemoryUsageBytes. This means that some queries whose memory usage was earlier just near than the original limit will cross the new limit and spill, thereby regressing in performance. We should increase the default maxMemoryUsageBytes by the iterators max size (1 mb) to allow for the non-iterator memory usage to reach the original limit.

        1. perf0.001.png
          perf0.001.png
          83 kB
        2. perf0.png
          perf0.png
          83 kB

            Assignee:
            projjal.chanda@mongodb.com Projjal Chanda
            Reporter:
            projjal.chanda@mongodb.com Projjal Chanda
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: