-
Type:
Task
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
None
-
3
-
TBD
-
None
-
None
-
None
-
None
-
None
-
None
-
None
-
0
MultiPlanningsStoppedCount: Count the number of times each stopping condition is hit in the multiplanner. Among the three stopping conditions, we can see the following: small queries hitting EOF (ideal), nReturned=101 for non-trivial queries, works limit (aka timing out) should be avoided if possible.
MultiPlanCandidatesCount: Count the number of candidate plans given to the multiplanner. This coupled with the high average number of works would point to the high cost of multiplanning.
ConcurrentMultiPlansCount: Count the number of concurrent multiplanning candidates.
- related to
-
SERVER-101604 Clean up bucket table
-
- Closed
-
-
SERVER-105489 Add new cached plan metrics
-
- Closed
-
-
SERVER-105988 Add Multiplanner exit scenario counters to explain
-
- Backlog
-
-
SERVER-101618 Don't throw if no plan cache entry is available
-
- Closed
-