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

Updates to query plan revision as of 3.0.7/3.1.7

    XMLWordPrintableJSON

Details

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

    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

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:
              7 years, 48 weeks, 5 days ago