Performance Schema events_stages_summary_by_thread_by_event_name Table

The table lists stage events, summarized by thread and event name.

It contains the following columns:

Column
Description

Column

Description

THREAD_ID

Thread associated with the event. Together with EVENT_NAME uniquely identifies the row.

EVENT_NAME

Event name. Used together with THREAD_ID for grouping events.

COUNT_STAR

Number of summarized events, which includes all timed and untimed events.

SUM_TIMER_WAIT

Total wait time of the timed summarized events.

MIN_TIMER_WAIT

Minimum wait time of the timed summarized events.

AVG_TIMER_WAIT

Average wait time of the timed summarized events.

MAX_TIMER_WAIT

Maximum wait time of the timed summarized events.

Example

SELECT * FROM events_stages_summary_by_thread_by_event_name\G
...
*************************** 2287. row ***************************
     THREAD_ID: 64
    EVENT_NAME: stage/sql/Waiting for event metadata lock
    COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 2288. row ***************************
     THREAD_ID: 64
    EVENT_NAME: stage/sql/Waiting for commit lock
    COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 2289. row ***************************
     THREAD_ID: 64
    EVENT_NAME: stage/aria/Waiting for a resource
    COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0

This page is licensed: CC BY-SA / Gnu FDL

Last updated

Was this helpful?