Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual Excerpts from this Manual

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

21.9.1 Performance Schema Table Index

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

Table 21.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_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
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
prepared_statements_instancesPrepared statement instances and statistics
replication_connection_configurationConfiguration parameters for connecting to the master
replication_connection_statusCurrent status of the connection to the master
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)
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_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
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
usersConnection statistics per client user name
user_variables_by_threadUser-defined variables per thread
variables_by_threadSession system variables per session

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