Skip navigation links
MySQL 5.5 Reference Manual :: 20 MySQL Performance Schema :: 20.7 Performance Schema Table Descriptions
20.7.1 Performance Schema Setup Tables »
Section Navigation      [Toggle]

20.7. Performance Schema Table Descriptions

[+/-]

20.7.1. Performance Schema Setup Tables
20.7.2. Performance Schema Current-Events Table
20.7.3. Performance Schema History Tables
20.7.4. Performance Schema Summary Tables
20.7.5. Performance Schema Instance Tables
20.7.6. Performance Schema Miscellaneous Tables

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_CURRENT table contains the most recent event for each thread.

  • History tables. These tables have the same structure as EVENTS_WAITS_CURRENT but contain more rows. The EVENTS_WAITS_HISTORY table contains the most recent 10 events per thread. EVENTS_WAITS_HISTORY_LONG contains the most recent 10,000 events.

    To change the sizes of these tables, set the performance_schema_events_waits_history_size and performance_schema_events_waits_history_long_size system variables at server startup.

  • Summary tables. These tables contain information aggregated over all 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.