Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual Excerpts from this Manual The events_transactions_history_long Table

The events_transactions_history_long table (added in MySQL 5.7.3) contains the most recent N transaction events. The value of N is autosized at server startup. To set the table size explicitly, set the performance_schema_events_transactions_history_long_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. When a thread ends, its rows are removed from the table.

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

The events_transactions_history_long table can be truncated with TRUNCATE TABLE.

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

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