Simulate cases where $group in SBE spills more aggressively

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Done
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • Fully Compatible
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      SERVER-70395, SUPPORT-2778. The symptom is that queries are spilling to disk way more than they did in the classic engine. In addition to spilling to disk more frequently, SBE was also much slower than classic when spilling to disk. This combination of factors would cause severe performance degradation across the entire cluster.

      We can simulate this by adjusting the memory threshold for spilling between engines.

      Result - we can run this scenario in the testing harness against the placeholder algorithm.

              Assignee:
              Evan Bergeron
              Reporter:
              Parker Felix
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: