27.12.1 Performance Schema Table Reference

The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions.

Table 27.1 Performance Schema Tables

Table NameDescriptionIntroduced
accountsConnection statistics per client account
binary_log_transaction_compression_statsBinary log transaction compression8.0.20
clone_progressClone operation progress8.0.17
clone_statusClone operation status8.0.17
cond_instancesSynchronization object instances
data_lock_waitsData lock wait relationships
data_locksData locks held and requested
error_logServer error log recent entries8.0.22
events_errors_summary_by_account_by_errorErrors per account and error code
events_errors_summary_by_host_by_errorErrors per host and error code
events_errors_summary_by_thread_by_errorErrors per thread and error code
events_errors_summary_by_user_by_errorErrors per user and error code
events_errors_summary_global_by_errorErrors per error code
events_stages_currentCurrent stage events
events_stages_historyMost recent stage events per 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_histogram_by_digestStatement histograms per schema and digest value
events_statements_histogram_globalStatement histogram summarized globally
events_statements_historyMost recent statement events per 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_programStatement events per stored program
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_transactions_currentCurrent transaction events
events_transactions_historyMost recent transaction events per thread
events_transactions_history_longMost recent transaction events overall
events_transactions_summary_by_account_by_event_nameTransaction events per account and event name
events_transactions_summary_by_host_by_event_nameTransaction events per host name and event name
events_transactions_summary_by_thread_by_event_nameTransaction events per thread and event name
events_transactions_summary_by_user_by_event_nameTransaction events per user name and event name
events_transactions_summary_global_by_event_nameTransaction events per event name
events_waits_currentCurrent wait events
events_waits_historyMost recent wait events per 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
firewall_group_allowlistFirewall in-memory data for group profile allowlists8.0.23
firewall_groupsFirewall in-memory data for group profiles8.0.23
firewall_membershipFirewall in-memory data for group profile members8.0.23
global_statusGlobal status variables
global_variablesGlobal system variables
host_cacheInformation from internal host cache
hostsConnection statistics per client host name
keyring_component_statusStatus information for installed keyring component8.0.24
keyring_keysMetadata for keyring keys8.0.16
log_statusInformation about server logs for backup purposes
memory_summary_by_account_by_event_nameMemory operations per account and event name
memory_summary_by_host_by_event_nameMemory operations per host and event name
memory_summary_by_thread_by_event_nameMemory operations per thread and event name
memory_summary_by_user_by_event_nameMemory operations per user and event name
memory_summary_global_by_event_nameMemory operations globally per event name
metadata_locksMetadata locks and lock requests
mutex_instancesMutex synchronization object instances
ndb_sync_excluded_objectsNDB objects which cannot be synchronized8.0.21
ndb_sync_pending_objectsNDB objects waiting for synchronization8.0.21
objects_summary_global_by_typeObject summaries
performance_timersWhich event timers are available
persisted_variablesContents of mysqld-auto.cnf file
prepared_statements_instancesPrepared statement instances and statistics
processlistProcess list information8.0.22
replication_applier_configurationConfiguration parameters for replication applier on replica
replication_applier_filtersChannel-specific replication filters on current replica
replication_applier_global_filtersGlobal replication filters on current replica
replication_applier_statusCurrent status of replication applier on replica
replication_applier_status_by_coordinatorSQL or coordinator thread applier status
replication_applier_status_by_workerWorker thread applier status
replication_asynchronous_connection_failoverSource lists for asynchronous connection failover mechanism8.0.22
replication_asynchronous_connection_failover_managedManaged source lists for asynchronous connection failover mechanism8.0.23
replication_connection_configurationConfiguration parameters for connecting to source
replication_connection_statusCurrent status of connection to source
replication_group_member_statsReplication group member statistics
replication_group_membersReplication group member network and status
rwlock_instancesLock synchronization object instances
session_account_connect_attrsConnection attributes per for current session
session_connect_attrsConnection attributes for all sessions
session_statusStatus variables for current session
session_variablesSystem variables for current session
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_threadsInstrumented thread names and attributes
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
status_by_accountSession status variables per account
status_by_hostSession status variables per host name
status_by_threadSession status variables per session
status_by_userSession status variables per user name
table_handlesTable locks and lock requests
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
tls_channel_statusTLS status for each connection interface8.0.21
tp_thread_group_stateThread pool thread group states8.0.14
tp_thread_group_statsThread pool thread group statistics8.0.14
tp_thread_stateThread pool thread information8.0.14
user_defined_functionsRegistered loadable functions
user_variables_by_threadUser-defined variables per thread
usersConnection statistics per client user name
variables_by_threadSession system variables per session
variables_infoHow system variables were most recently set