[COMPASS-7587] Investigate changes in SERVER-75678: Consider adding a plan cache serverStatus counter for queries which are not eligible for caching Created: 19/Jan/24  Updated: 07/Feb/24  Resolved: 07/Feb/24

Status: Closed
Project: Compass
Component/s: None
Affects Version/s: None
Fix Version/s: No version

Type: Investigation Priority: Major - P3
Reporter: Backlog - Core Eng Program Management Team Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-75678 Consider adding a plan cache serverSt... Closed
Assigned Teams:
Developer Tools
Documentation Changes: Not Needed

 Description   
Original Downstream Change Summary

We now differentiate from plan cache misses and skips (queries whose plan is never even attempted to cache)

Description of Linked Ticket

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 Jessica Sigafoos [ 07/Feb/24 ]

No action required from the DevTools team

Comment by PM Bot [ 19/Jan/24 ]

Fix Version updated for upstream SERVER-75678:
7.3.0-rc0

Generated at Wed Feb 07 22:47:01 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.