The events_transactions_summary_by_thread_by_event_name table was introduced in MariaDB 10.5.2.
The events_transactions_summary_by_thread_by_event_name table contains information on transaction events aggregated by thread and event name.
The table contains the following columns:
+----------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+---------+-------+ | THREAD_ID | bigint(20) unsigned | NO | | NULL | | | EVENT_NAME | varchar(128) | NO | | NULL | | | COUNT_STAR | bigint(20) unsigned | NO | | NULL | | | SUM_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | | | MIN_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | | | AVG_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | | | MAX_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | | | COUNT_READ_WRITE | bigint(20) unsigned | NO | | NULL | | | SUM_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | | | MIN_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | | | AVG_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | | | MAX_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | | | COUNT_READ_ONLY | bigint(20) unsigned | NO | | NULL | | | SUM_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | | | MIN_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | | | AVG_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | | | MAX_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | | +----------------------+---------------------+------+-----+---------+-------+
© 2023 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_transactions_summary_by_thread_by_event_name-tabl/