Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-17895

Server should not clear collection plan cache periodically when write operations are issued

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 3.0.7, 3.1.7
    • Querying
    • None
    • Fully Compatible
    • Quint Iteration 7

    Description

      Each collection's query plan cache for is currently cleared after 1000 write operations are issued against the collection. This gives distribution changes a chance to affect planning decisions for query shapes that are already cached.

      However, clearing the entire plan cache is aggressive, and at worst will cause deployments with a heavy write load to effectively not use the query plan cache at all.

      This mechanism will be made obsolete by SERVER-15225. When SERVER-15225 is resolved, we should remove it entirely.

      Attachments

        Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-15225 CachedPlanStage should execute for trial period and re-plan if query performs poorly

          • Major - P3 - Major loss of function.
          • Closed
          related to

          Improvement - An improvement or enhancement to an existing feature or task. DOCS-6401 Updates to query plan revision as of 3.0.7/3.1.7

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-28314 Remove unused PlanCache::_writeOperations member

          • Trivial - P5 - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Activity

            People

              david.storch@mongodb.com David Storch
              rassi J Rassi
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: