Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-6401

Updates to query plan revision as of 3.0.7/3.1.7

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Major - P3
    • Resolution: Done
    • mongodb-3.0, mongodb-3.1.x
    • 01112017-cleanup
    • manual
    • None
    • true

    Description

      MongoDB 3.0.7 and 3.1.7 add two significant changes to historical query revision behaviour:

      • SERVER-17895 (Server should not clear collection plan cache periodically when write operations are issued)
      • SERVER-15225/SERVER-20139 (Enable CachedPlanStage replanning by default)

      These should be reflected in the query plan revision notes: http://docs.mongodb.org/manual/core/query-plans/#query-plan-revision

      • SERVER-17895 removes: "The collection receives 1,000 write operations."
      • SERVER-20139 adds: "If the cost of the cached query plan is too high as compared to an alternative plan, the query planner switches to the more efficient plan and caches this choice for future use."

      Attachments

        Issue Links

          Activity

            People

              kay.kim@mongodb.com Kay Kim (Inactive)
              stephen.steneker@mongodb.com Stennie Steneker
              Jonathan Dahl Jonathan Dahl
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                6 years, 23 weeks, 4 days ago