Performance Schema events_stages_summary_global_by_event_name Table

MariaDB starting with 10.0

The events_stages_summary_global_by_event_name table was added in MariaDB 10.0 (along with many other new Performance Schema tables).

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

It contains the following columns:

ColumnDescription
EVENT_NAMEEvent name.
COUNT_STARNumber of summarized events, which includes all timed and untimed events.
SUM_TIMER_WAITTotal wait time of the timed summarized events.
MIN_TIMER_WAITMinimum wait time of the timed summarized events.
AVG_TIMER_WAITAverage wait time of the timed summarized events.
MAX_TIMER_WAITMaximum wait time of the timed summarized events.

Example

SELECT * FROM events_stages_summary_global_by_event_name\G
...
*************************** 106. row ***************************
    EVENT_NAME: stage/sql/Waiting for trigger metadata lock
    COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 107. row ***************************
    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
*************************** 108. row ***************************
    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
*************************** 109. row ***************************
    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

Comments

Comments loading...