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
PreviousPerformance Schema events_stages_summary_by_host_by_event_name TableNextPerformance Schema events_stages_summary_by_user_by_event_name Table
Last updated
Was this helpful?