-
Type: Improvement
-
Resolution: Done
-
Priority: Major - P3
-
Affects Version/s: mongodb-3.0, mongodb-3.1.x
-
Component/s: manual
-
Labels:None
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-17895removes: "The collection receives 1,000 write operations."SERVER-20139adds: "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."
- is related to
-
DOCS-6372 Query Plans page is out of date
- Closed
-
SERVER-15225 CachedPlanStage should execute for trial period and re-plan if query performs poorly
- Closed
-
SERVER-17895 Server should not clear collection plan cache periodically when write operations are issued
- Closed
-
SERVER-20139 Enable CachedPlanStage replanning by default in 3.0
- Closed