This group contains tables with names that match the pattern
'%HISTORY'
or
'%HISTORY_LONG'
:
mysql>SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
->WHERE TABLE_SCHEMA = 'performance_schema'
->AND (TABLE_NAME LIKE '%HISTORY' OR TABLE_NAME LIKE '%HISTORY_LONG');
+---------------------------+ | TABLE_NAME | +---------------------------+ | EVENTS_WAITS_HISTORY | | EVENTS_WAITS_HISTORY_LONG | +---------------------------+
The history tables, EVENTS_WAITS_HISTORY
and
EVENTS_WAITS_HISTORY_LONG
, contain the most
recent 10 events per thread and most recent 10,000 events,
respectively. As new events are added to a history table, older
events are discarded if the table is full. Events are not added
to the history tables until they have ended.
Event history tables can be truncated with
TRUNCATE TABLE
.
The history tables have the same structure as
EVENTS_WAITS_CURRENT
. See
Section 7.2, “Performance Schema Current-Events Table”.