table contains the
N most recent
transaction events that have ended globally, across all
threads. Transaction events are not added to the table until
they have ended. When the table becomes full, the oldest row
is discarded when a new row is added, regardless of which
thread generated either row.
The Performance Schema autosizes the value of
N is autosized at server startup.
To set the table size explicitly, set the
system variable at server startup.
table has the same columns as
Section 18.104.22.168, “The events_transactions_current Table”. Unlike
has no indexing.
For more information about the relationship between the three transaction event tables, see Section 26.9, “Performance Schema Tables for Current and Historical Events”.
For information about configuring whether to collect transaction events, see Section 26.12.7, “Performance Schema Transaction Tables”.