Tables in the
performance_schema database can
be grouped as follows:
Setup tables. These tables are used to configure and display monitoring characteristics.
Current events table. The
events_waits_currenttable contains the most recent event for each thread.
History tables. These tables have the same structure as
events_waits_currentbut contain more rows. The
events_waits_historytable contains the most recent 10 events per thread.
events_waits_history_longcontains the most recent 10,000 events.
Summary tables. These tables contain information aggregated over groups of events, including those that have been discarded from the history tables.
Instance tables. These tables document what types of objects are instrumented. An instrumented object, when used by the server, produces an event. These tables provide event names and explanatory notes or status information.
Miscellaneous tables. These do not fall into any of the other table groups.