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

      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: