-
Type: Improvement
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
-
Fully Compatible
-
QE 2024-07-22, QE 2024-08-05, QE 2024-08-19, QE 2024-09-02, QE 2024-09-16
We've recently done several work items in order to make interesting query system related event counters available in serverStatus() and FTDC:
SERVER-63642: Metrics related to the classic and SBE multi-plannersSERVER-40382: Plan cache memory consumptionSERVER-71529: Metrics for plan cache sizeSERVER-70025: Plan cache hits and misses
One related metric that we don't have yet is a counter for the number of times that plan cache replanning occurs. This would be interesting both in field/diagnostics contexts, since high replanning rates may be associated with performance problems that could be worked around with features like hints or persistent query settings (see SERVER-79039). It would also be interesting for query product management to be able to study the prevalence of replanning events. This could help us understand how to improve or evolve the product's behavior with respect to replanning.
- is depended on by
-
COMPASS-8237 Investigate changes in SERVER-87572: Add serverStatus() metric to count replanning events
- Needs Triage
-
TOOLS-3659 Investigate changes in SERVER-87572: Add serverStatus() metric to count replanning events
- Closed
- related to
-
SERVER-87860 Add serverStatus() / FTDC counters for the number of queries answered using a fast path
- Closed