W3cubDocs

/MariaDB

Performance Schema events_stages_summary_by_thread_by_event_name Table

MariaDB starting with 10.0

The events_stages_summary_by_thread_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:

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

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.

© 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_stages_summary_by_thread_by_event_name-table/