21.9.5.3. The events_statements_history_long Table

The events_statements_history_long table contains the most recent 10,000 events. The table size may be changed by modifying the performance_schema_events_statements_history_long_size system variable at server startup. As new events are added to the table, older events are discarded if the table is full. Events are not added to the table until they have ended.

The events_statements_history_long table has the same structure as events_statements_current. See Section 21.9.5.1, "The events_statements_current Table".

The events_statements_history_long table can be truncated with TRUNCATE TABLE.

The events_statements_history_long table was added in MySQL 5.6.3.