[SERVER-60067] When index is dropped invalidate only SBE plan cache entries which depend on it Created: 19/Sep/21  Updated: 06/Dec/22  Resolved: 03/Feb/22

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

Type: Improvement Priority: Major - P3
Reporter: Anton Korshunov Assignee: Backlog - Query Optimization
Resolution: Won't Do Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to SERVER-60066 Implement plan cache invalidation on ... Closed
Assigned Teams:
Query Optimization
Sprint: QO 2021-10-18
Participants:

 Description   

This is a continuation of the work started inĀ SERVER-60066. We need to enhance a plan cache invalidation mechanism when an index is dropped to evict only those plan cache entries which hold plans which depend on the dropped index.



 Comments   
Comment by David Storch [ 03/Feb/22 ]

We're no longer planning to implement this improvement as part of the SBE plan cache project, for a few reasons:

  • The classic plan cache had similar behavior around cache invalidation when catalog entries occur, so we won't regress. We also don't necessarily have a strong motivation to improve this behavior as part of building the SBE plan cache.
  • We're unlikely to have time for it given our current schedule.
  • We don't currently have a design for how this will work. It's unclear how the new plan cache invalidation behavior would interact with the cache key versioning scheme that we introduced under SERVER-60066.

CC anton.korshunov

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