Report metrics about temporary record stores and external files used for query spilling

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Fixed
    • Priority: Major - P3
    • 8.1.0-rc0, 7.0.13, 8.0.0-rc14
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • Fully Compatible
    • v8.0, v7.0, v6.0
    • QE 2024-07-08, QE 2024-07-22
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Expose the following metrics in serverStatus, and if possible, per-query in the slow query logs:

      • Number of active queries using a temporary record store or external files for spilling
      • Total bytes spilled
      • Total bytes written to disk
      • The number of spill events

              Assignee:
              Rui Liu
              Reporter:
              Louis Williams
              Votes:
              1 Vote for this issue
              Watchers:
              13 Start watching this issue

                Created:
                Updated:
                Resolved: