The events_waits_summary_by_account_by_event_name
table, along with many other new Performance Schema tables, was added in MariaDB 10.0.
The Performance Schema events_waits_summary_by_account_by_event_name
table contains wait events summarized by account and event name. It contains the following columns:
Column | Description |
---|---|
USER |
User. Used together with HOST and EVENT_NAME for grouping events. |
HOST |
Host. Used together with USER and EVENT_NAME for grouping events. |
EVENT_NAME |
Event name. Used together with USER and HOST 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.
SELECT * FROM events_waits_summary_by_account_by_event_name\G ... *************************** 915. row *************************** USER: NULL HOST: NULL EVENT_NAME: wait/io/socket/sql/server_tcpip_socket COUNT_STAR: 0 SUM_TIMER_WAIT: 0 MIN_TIMER_WAIT: 0 AVG_TIMER_WAIT: 0 MAX_TIMER_WAIT: 0 *************************** 916. row *************************** USER: NULL HOST: NULL 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 *************************** 917. row *************************** USER: NULL HOST: NULL 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 *************************** 918. row *************************** USER: NULL HOST: NULL EVENT_NAME: idle COUNT_STAR: 0 SUM_TIMER_WAIT: 0 MIN_TIMER_WAIT: 0 AVG_TIMER_WAIT: 0 MAX_TIMER_WAIT: 0
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/performance-schema-events_waits_summary_by_account_by_event_name-table/