[SERVER-63102] Make separate internalQueryPlanEvaluationWorks knobs for the classic and SBE multi-planners Created: 28/Jan/22  Updated: 29/Oct/23  Resolved: 09/Feb/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.3.0, 5.2.1

Type: Improvement Priority: Major - P3
Reporter: David Storch Assignee: David Storch
Resolution: Fixed Votes: 0
Labels: RDY
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
Problem/Incident
Related
is related to SERVER-62150 SBE Multiplanning can be slow when su... Open
is related to SERVER-62981 Make SBE multi-planner's trial period... Closed
Backwards Compatibility: Fully Compatible
Backport Requested:
v5.2
Sprint: QE 2022-02-21
Participants:

 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.



 Comments   
Comment by Githook User [ 10/Feb/22 ]

Author:

{'name': 'David Storch', 'email': 'david.storch@mongodb.com', 'username': 'dstorch'}

Message: SERVER-63102 Introduce internalQueryPlanEvaluationWorksSbe

The 'internalQueryPlanEvaluationWorks' parameter now only
affects the classic engine. The newly added parameter has
similar behavior, but applies only to queries using SBE.

(cherry picked from commit a94caa502cf94fa6c8fcfea7283d7eaf3bd55ad5)
Branch: v5.2
https://github.com/mongodb/mongo/commit/6471c0558b198baeff86e7c87ca856ecc43957c7

Comment by Githook User [ 09/Feb/22 ]

Author:

{'name': 'David Storch', 'email': 'david.storch@mongodb.com', 'username': 'dstorch'}

Message: SERVER-63102 Introduce internalQueryPlanEvaluationWorksSbe

The 'internalQueryPlanEvaluationWorks' parameter now only
affects the classic engine. The newly added parameter has
similar behavior, but applies only to queries using SBE.
Branch: master
https://github.com/mongodb/mongo/commit/a94caa502cf94fa6c8fcfea7283d7eaf3bd55ad5

Generated at Thu Feb 08 05:56:54 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.