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

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.7, 3.1.7
    • Component/s: Querying
    • Labels:
      None
    • Backwards Compatibility:
      Fully Compatible
    • Backport Completed:
    • Sprint:
      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

              Assignee:
              david.storch David Storch
              Reporter:
              rassi J Rassi
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: