Ch 04: Transactions in the Performance Schema

The Performance Schema supports transaction monitoring in MySQL 5.7 and later, and it is enabled by default in MySQL 8.

events_transactions_current
events_transactions_history
events_transactions_history_long

Abandoned transactions prevent purge of undo logs.

Transaction Summary Tables

event_transactions_summary_by_event_name
event_transactions_summary_by_account_by_event_name
event_transactions_summary_by_host_by_event_name
event_transactions_summary_by_thread_by_event_name
event_transactions_summary_by_user_by_event_name

R/O:

START TRANSACTION READ ONLY;

When INNODB determines that an autocommiting single-statement transaction can be treated as a read-only transaction, that is still counting toward the read-write statistics in the Performance Schema.