Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.7Mb
PDF (A4) - 37.7Mb
PDF (RPM) - 33.8Mb
HTML Download (TGZ) - 8.4Mb
HTML Download (Zip) - 8.4Mb
HTML Download (RPM) - 7.2Mb
Man Pages (TGZ) - 130.0Kb
Man Pages (Zip) - 185.6Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb

MySQL 8.0 Reference Manual  /  ...  /  Performance Schema Table Index

Pre-General Availability Draft: 2018-02-16

26.11.1 Performance Schema Table Index

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

Table 26.1 Performance Schema Tables

Table NameDescription
accountsConnection statistics per client account
cond_instancessynchronization object instances
data_lock_waitsData lock wait relationships
data_locksData locks held and requested
events_errors_summary_by_account_by_errorErrors per error code and account
events_errors_summary_by_host_by_errorErrors per error code and host
events_errors_summary_by_thread_by_errorErrors per error code and host
events_errors_summary_by_user_by_errorErrors per error code and host
events_errors_summary_global_by_errorErrors per error code
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_histogram_by_digestStatement histograms per schema and digest value
events_statements_histogram_globalStatement histogram summarized globally
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_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 for each 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 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
global_statusGlobal status variables
global_variablesGlobal system variables
host_cacheInformation from the internal host cache
hostsConnection statistics per client host name
instance_logs_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
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
replication_applier_configurationConfiguration parameters for the transaction applier on the slave
replication_applier_statusCurrent status of the transaction applier on the slave
replication_applier_status_by_coordinatorSQL or coordinator thread applier status
replication_applier_status_by_workerWorker thread applier status (empty unless slave is multi-threaded)
replication_connection_configurationConfiguration parameters for connecting to the master
replication_connection_statusCurrent status of the connection to the master
rwlock_instancesLock synchronization object instances
session_account_connect_attrsConnection attributes per for the 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
user_defined_functionsRegistered user-defined 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

User Comments
Sign Up Login You must be logged in to post a comment.