Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-87572

Add serverStatus() metric to count replanning events

    • Type: Icon: Improvement Improvement
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 8.1.0-rc0
    • 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:

      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.

            Assignee:
            ivan.fefer@mongodb.com Ivan Fefer
            Reporter:
            david.storch@mongodb.com David Storch
            Votes:
            0 Vote for this issue
            Watchers:
            13 Start watching this issue

              Created:
              Updated:
              Resolved: