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

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Done
    • Affects Version/s: mongodb-3.0, mongodb-3.1.x
    • Fix Version/s: 01112017-cleanup
    • Component/s: manual
    • Labels:
      None
    • # Replies:
      1
    • Last comment by Customer:
      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

              • Votes:
                1 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since reply:
                  3 years, 45 weeks, 1 day ago
                  Date of 1st Reply: