22.9.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 NameDescription
accountsConnection statistics per client account
cond_instancessynchronization object instances
events_stages_currentCurrent stage events
events_stages_historyMost recent stage events for each thread
events_stages_history_longMost recent stage events overall
events_stages_summary_by_account_by_event_nameStage events per account and event name
events_stages_summary_by_host_by_event_nameStage events per host name and event name
events_stages_summary_by_thread_by_event_nameStage waits per thread and event name
events_stages_summary_by_user_by_event_nameStage events per user name and event name
events_stages_summary_global_by_event_nameStage waits per event name
events_statements_currentCurrent statement events
events_statements_historyMost recent statement events for each thread
events_statements_history_longMost recent statement events overall
events_statements_summary_by_account_by_event_nameStatement events per account and event name
events_statements_summary_by_digestStatement events per schema and digest value
events_statements_summary_by_host_by_event_nameStatement events per host name and event name
events_statements_summary_by_thread_by_event_nameStatement events per thread and event name
events_statements_summary_by_user_by_event_nameStatement events per user name and event name
events_statements_summary_global_by_event_nameStatement events per event name
events_waits_currentCurrent wait events
events_waits_historyMost recent wait events for each thread
events_waits_history_longMost recent wait events overall
events_waits_summary_by_account_by_event_nameWait events per account and event name
events_waits_summary_by_host_by_event_nameWait events per host name and event name
events_waits_summary_by_instanceWait events per instance
events_waits_summary_by_thread_by_event_nameWait events per thread and event name
events_waits_summary_by_user_by_event_nameWait events per user name and event name
events_waits_summary_global_by_event_nameWait events per event name
file_instancesFile instances
file_summary_by_event_nameFile events per event name
file_summary_by_instanceFile events per file instance
host_cacheInformation from the internal host cache
hostsConnection statistics per client host name
mutex_instancesMutex synchronization object instances
objects_summary_global_by_typeObject summaries
performance_timersWhich event timers are available
rwlock_instancesLock synchronization object instances
session_account_connect_attrsConnection attributes per for the current session
session_connect_attrsConnection attributes for all sessions
setup_actorsHow to initialize monitoring for new foreground threads
setup_consumersConsumers for which event information can be stored
setup_instrumentsClasses of instrumented objects for which events can be collected
setup_objectsWhich objects should be monitored
setup_timersCurrent event timer
socket_instancesActive connection instances
socket_summary_by_event_nameSocket waits and I/O per event name
socket_summary_by_instanceSocket waits and I/O per instance
table_io_waits_summary_by_index_usageTable I/O waits per index
table_io_waits_summary_by_tableTable I/O waits per table
table_lock_waits_summary_by_tableTable lock waits per table
threadsInformation about server threads
usersConnection statistics per client user name