22.12.1 Performance Schema Table Index

The following table lists each Performance Schema table and provides a short description of each one.

Table 22.1 Performance Schema Tables

Table Name	Description
`accounts`	Connection statistics per client account
`cond_instances`	synchronization object instances
`events_stages_current`	Current stage events
`events_stages_history`	Most recent stage events per thread
`events_stages_history_long`	Most recent stage events overall
`events_stages_summary_by_account_by_event_name`	Stage events per account and event name
`events_stages_summary_by_host_by_event_name`	Stage events per host name and event name
`events_stages_summary_by_thread_by_event_name`	Stage waits per thread and event name
`events_stages_summary_by_user_by_event_name`	Stage events per user name and event name
`events_stages_summary_global_by_event_name`	Stage waits per event name
`events_statements_current`	Current statement events
`events_statements_history`	Most recent statement events per thread
`events_statements_history_long`	Most recent statement events overall
`events_statements_summary_by_account_by_event_name`	Statement events per account and event name
`events_statements_summary_by_digest`	Statement events per schema and digest value
`events_statements_summary_by_host_by_event_name`	Statement events per host name and event name
`events_statements_summary_by_thread_by_event_name`	Statement events per thread and event name
`events_statements_summary_by_user_by_event_name`	Statement events per user name and event name
`events_statements_summary_global_by_event_name`	Statement events per event name
`events_waits_current`	Current wait events
`events_waits_history`	Most recent wait events per thread
`events_waits_history_long`	Most recent wait events overall
`events_waits_summary_by_account_by_event_name`	Wait events per account and event name
`events_waits_summary_by_host_by_event_name`	Wait events per host name and event name
`events_waits_summary_by_instance`	Wait events per instance
`events_waits_summary_by_thread_by_event_name`	Wait events per thread and event name
`events_waits_summary_by_user_by_event_name`	Wait events per user name and event name
`events_waits_summary_global_by_event_name`	Wait events per event name
`file_instances`	File instances
`file_summary_by_event_name`	File events per event name
`file_summary_by_instance`	File events per file instance
`host_cache`	Information from the internal host cache
`hosts`	Connection statistics per client host name
`mutex_instances`	Mutex synchronization object instances
`objects_summary_global_by_type`	Object summaries
`performance_timers`	Which event timers are available
`rwlock_instances`	Lock synchronization object instances
`session_account_connect_attrs`	Connection attributes per for the current session
`session_connect_attrs`	Connection attributes for all sessions
`setup_actors`	How to initialize monitoring for new foreground threads
`setup_consumers`	Consumers for which event information can be stored
`setup_instruments`	Classes of instrumented objects for which events can be collected
`setup_objects`	Which objects should be monitored
`setup_timers`	Current event timer
`socket_instances`	Active connection instances
`socket_summary_by_event_name`	Socket waits and I/O per event name
`socket_summary_by_instance`	Socket waits and I/O per instance
`table_io_waits_summary_by_index_usage`	Table I/O waits per index
`table_io_waits_summary_by_table`	Table I/O waits per table
`table_lock_waits_summary_by_table`	Table lock waits per table
`threads`	Information about server threads
`users`	Connection statistics per client user name