[SERVER-75678] Consider adding a plan cache serverStatus counter for queries which are not eligible for caching Created: 05/Apr/23 Updated: 19/Jan/24 Resolved: 19/Jan/24 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 7.3.0-rc0 |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Anton Korshunov | Assignee: | Carlos Alonso Pérez |
| Resolution: | Done | Votes: | 0 |
| Labels: | neweng, query-director-triage, query-product-scope-1, query-product-urgency-3, query-product-value-2, quick-tech-debt | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||||||
| Assigned Teams: |
Query Optimization
|
||||||||||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||||||||||
| Sprint: | QO 2024-01-22 | ||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||
| Description |
|
This is a follow up ticket from SERVER-70025. Currently we only count cache plan cache hits and misses, regardless of the query type. That is, we expect a plan for the given query to be in the cache, and as such can be recovered from the cache, or missed from the cache, and needs to be replanned. However, there is a difference between "didn't use cache because there wasn't a cache entry" and "didn't use cache because this query is ineligible for caching". We may want to consider adding a third counter (in additional to "hits" and "misses") to account for this difference. |
| Comments |
| Comment by Githook User [ 18/Jan/24 ] |
|
Author: {'name': 'Carlos Alonso', 'email': 'calonso@users.noreply.github.com', 'username': 'calonso'}Message: GitOrigin-RevId: e925b31178c02716f0959103ccec937f87294401 |
| Comment by David Storch [ 28/Nov/23 ] |
|
Putting this back in the triage queue. Per my discussion with anton.korshunov@mongodb.com, this seems like a worthwhile improvement in order to avoid the confusion described by |
| Comment by Ana Meza [ 18/Apr/23 ] |
|
Passing to Product-Triage to identify priority |