[SERVER-64315] Re-enable caching of single solution plans Created: 08/Mar/22  Updated: 29/Oct/23  Resolved: 04/May/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 6.0.0-rc5, 6.1.0-rc0

Type: Task Priority: Major - P3
Reporter: Anton Korshunov Assignee: David Storch
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
depends on SERVER-66015 Auto-parameterization works incorrect... Closed
depends on SERVER-65083 Thread seeing different set of indice... Closed
depends on SERVER-65085 SBE plan cache entries can be incorre... Closed
Gantt Dependency
Problem/Incident
Related
related to SERVER-64314 Temporary disable caching of single s... Closed
is related to SERVER-61083 Start caching plans that only have a ... Closed
is related to SERVER-13341 Cache single solution query plans Needs Scheduling
Backwards Compatibility: Fully Compatible
Backport Requested:
v6.0
Sprint: QE 2022-04-04, QE 2022-03-21, QE 2022-04-18, QE 2022-05-02, QE 2022-05-16
Participants:
Linked BF Score: 148

 Description   

The classic plan cache did not create a cache entry for queries that only have a single solution. (Improving this is tracked by SERVER-13341.) The SBE plan cache, on the other hand, will cache single solution plans. This allows us to skip the cost of recompiling the SBE plan, even if there is no need to skip multi-planning.

The work for this improvement was originally implemented under SERVER-61083 but then subsequently disabled by SERVER-64314 since we observed some subtle correctness issues that were tricky to diagnose. The work for this ticket is to re-enable caching of single solution plans in the SBE plan cache. This will involve investigating and fixing the relevant build failures in addition to reverting the patch from SERVER-64314 that temporarily disabled single-solution SBE plan caching.



 Comments   
Comment by Githook User [ 04/May/22 ]

Author:

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

Message: SERVER-64315 Re-enable caching of SBE plans when there is a single query solution

This reverts commit f8589f840c8fee60abc482d2d2c41979e356922a.

(cherry picked from commit f462237ac17a9c8a3e4a5a3fb6bbe6a966d4be85)
Branch: v6.0
https://github.com/mongodb/mongo/commit/a616699c511fb395f3c0c6f53e705b306927a687

Comment by Githook User [ 04/May/22 ]

Author:

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

Message: SERVER-64315 Re-enable caching of SBE plans when there is a single query solution

This reverts commit f8589f840c8fee60abc482d2d2c41979e356922a.
Branch: master
https://github.com/mongodb/mongo/commit/f462237ac17a9c8a3e4a5a3fb6bbe6a966d4be85

Generated at Thu Feb 08 06:00:03 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.