Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-7587

Investigate changes in SERVER-75678: Consider adding a plan cache serverStatus counter for queries which are not eligible for caching

    XMLWordPrintableJSON

Details

    • Icon: Investigation Investigation
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • No version
    • None
    • None
    • None
    • Developer Tools
    • 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. 

      Attachments

        Activity

          People

            Unassigned Unassigned
            backlog-server-pm Backlog - Core Eng Program Management Team
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: