Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 33.9Mb
PDF (A4) - 34.0Mb
PDF (RPM) - 33.2Mb
EPUB - 8.5Mb
HTML Download (TGZ) - 8.2Mb
HTML Download (Zip) - 8.2Mb
HTML Download (RPM) - 7.1Mb
Eclipse Doc Plugin (TGZ) - 9.0Mb
Eclipse Doc Plugin (Zip) - 11.1Mb
Man Pages (TGZ) - 219.4Kb
Man Pages (Zip) - 322.3Kb
Info (Gzip) - 3.2Mb
Info (Zip) - 3.2Mb
Excerpts from this Manual

22.9.7.2 The events_transactions_history Table

The events_transactions_history table (added in MySQL 5.7.3) contains the most recent N transaction events per thread. The value of N is autosized at server startup. To set the table size explicitly, set the performance_schema_events_transactions_history_size system variable at server startup. Transaction events are not added to the table until they have ended. As new events are added, older events are discarded if the table is full.

The events_transactions_history table has the same structure as events_transactions_current. See Section 22.9.7.1, “The events_transactions_current Table”.

The events_transactions_history table can be truncated with TRUNCATE TABLE.

For information about configuration of transaction event collection, see Section 22.9.7, “Performance Schema Transaction Tables”.


User Comments
Sign Up Login You must be logged in to post a comment.