Performance Schema events_waits_summary_by_thread_by_event_name Table
The Performance Schema events_waits_summary_by_thread_by_event_name table contains wait events summarized by thread and event name. It contains the following columns:
| 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 |
SUM_TIMER_WAIT | Total wait time of the summarized events that are timed. |
MIN_TIMER_WAIT | Minimum wait time of the summarized events that are timed. |
AVG_TIMER_WAIT | Average wait time of the summarized events that are timed. |
MAX_TIMER_WAIT | Maximum wait time of the summarized events that are timed. |
The *_TIMER_WAIT columns only calculate results for timed events, as non-timed events have a NULL wait time.
Example
SELECT * FROM events_waits_summary_by_thread_by_event_name\G
...
*************************** 6424. row ***************************
THREAD_ID: 64
EVENT_NAME: wait/io/socket/sql/server_unix_socket
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 6425. row ***************************
THREAD_ID: 64
EVENT_NAME: wait/io/socket/sql/client_connection
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 6426. row ***************************
THREAD_ID: 64
EVENT_NAME: idle
COUNT_STAR: 73
SUM_TIMER_WAIT: 22005252162000000
MIN_TIMER_WAIT: 3000000
AVG_TIMER_WAIT: 301441810000000
MAX_TIMER_WAIT: 4912417573000000
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
