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

Simulate cases where $group in SBE spills more aggressively

    • Type: Icon: Task Task
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution

      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:
            parker.felix@mongodb.com Parker Felix
            Reporter:
            parker.felix@mongodb.com Parker Felix
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: