Promote execution behavior knobs to query settings

XMLWordPrintableJSON

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

      Promote per-operation execution behavior knobs to be settable per query shape via Persistent Query Settings. Same recipe as the other promotion tickets: migrate readers to QueryKnobConfiguration (see the needs_replacement burn-down from SERVER-129580), then register and flip pqs_settable: true.

      Candidate knobs (each needs a per-knob risk assessment; it is fine to drop some during review):

      • internalQueryExecYieldIterations
      • internalQueryExecYieldPeriodMS
      • internalQueryJavaScriptFnTimeoutMillis
      • internalQueryEnableAggressiveSpillsInGroup
      • internalQuerySlotBasedExecutionHashAggMemoryCheckPerAdvanceAtLeast
      • internalQuerySlotBasedExecutionHashAggMemoryCheckPerAdvanceAtMost
      • internalQuerySlotBasedExecutionHashAggMemoryUseCheckMargin

      Constraints established in SERVER-129580: knobs must be read after query settings resolution, must not feed query shape computation, and must not be test_only.

            Assignee:
            Unassigned
            Reporter:
            Catalin Sumanaru
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: