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

Make separate internalQueryPlanEvaluationWorks knobs for the classic and SBE multi-planners

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 5.3.0, 5.2.1
    • None
    • Fully Compatible
    • v5.2
    • QE 2022-02-21

    Description

      The classic engine and SBE have completely different implementations of multi-planning (a.k.a. runtime plan selection). In SERVER-62981, we separated the internalQueryPlanEvaluationCollFraction knob into two. That is, we introduced a new internalQueryPlanEvaluationCollFractionSbe knob which applies only to SBE and changed internalQueryPlanEvaluationCollFraction so that it applies only the classic engine. Since the two multi-planning implementations are distinct and may have different properties, it should be possible for users to tune their behavior independently.

      In the same vein, we should separate internalQueryPlanEvaluationWorks into two knobs. Again, internalQueryPlanEvaluationWorks would be just for the classic engine and internalQueryPlanEvaluationWorksSbe would apply only to SBE. That way, if the default value of 10,000 for SBE proves to be too low, users or support engineers can increase its value without disturbing the behavior of queries using the classic engine.

      Attachments

        Issue Links

          Activity

            People

              david.storch@mongodb.com David Storch
              david.storch@mongodb.com David Storch
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: