Increase default value of internalQueryMaxBlockingSortMemoryUsageBytes knob

XMLWordPrintableJSON

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

      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
              Reporter:
              Projjal Chanda
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: