Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.1Mb
PDF (A4) - 38.1Mb
PDF (RPM) - 33.0Mb
HTML Download (TGZ) - 8.1Mb
HTML Download (Zip) - 8.1Mb
HTML Download (RPM) - 7.0Mb
Man Pages (TGZ) - 132.7Kb
Man Pages (Zip) - 189.0Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

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

25.11.1 Performance Schema Table Index

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

Table 25.1 Performance Schema Tables

Table Name Description
accounts Connection statistics per client account
cond_instances synchronization object instances
data_lock_waits Data lock wait relationships
data_locks Data locks held and requested
events_errors_summary_by_account_by_error Errors per error code and account
events_errors_summary_by_host_by_error Errors per error code and host
events_errors_summary_by_thread_by_error Errors per error code and host
events_errors_summary_by_user_by_error Errors per error code and host
events_errors_summary_global_by_error Errors per error code
events_stages_current Current stage events
events_stages_history Most recent stage events for each 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_histogram_by_digest Statement histograms per schema and digest value
events_statements_histogram_global Statement histogram summarized globally
events_statements_history Most recent statement events for each 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_program Statement events per stored program
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_transactions_current Current transaction events
events_transactions_history Most recent transaction events for each thread
events_transactions_history_long Most recent transaction events overall
events_transactions_summary_by_account_by_event_name Transaction events per account and event name
events_transactions_summary_by_host_by_event_name Transaction events per host name and event name
events_transactions_summary_by_thread_by_event_name Transaction events per thread and event name
events_transactions_summary_by_user_by_event_name Transaction events per user name and event name
events_transactions_summary_global_by_event_name Transaction events per event name
events_waits_current Current wait events
events_waits_history Most recent wait events for each 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
global_status Global status variables
global_variables Global system variables
host_cache Information from the internal host cache
hosts Connection statistics per client host name
log_status Information about server logs for backup purposes
memory_summary_by_account_by_event_name Memory operations per account and event name
memory_summary_by_host_by_event_name Memory operations per host and event name
memory_summary_by_thread_by_event_name Memory operations per thread and event name
memory_summary_by_user_by_event_name Memory operations per user and event name
memory_summary_global_by_event_name Memory operations globally per event name
metadata_locks Metadata locks and lock requests
mutex_instances Mutex synchronization object instances
objects_summary_global_by_type Object summaries
performance_timers Which event timers are available
persisted_variables Contents of mysqld-auto.cnf file
prepared_statements_instances Prepared statement instances and statistics
replication_applier_configuration Configuration parameters for the transaction applier on the slave
replication_applier_status Current status of the transaction applier on the slave
replication_applier_status_by_coordinator SQL or coordinator thread applier status
replication_applier_status_by_worker Worker thread applier status (empty unless slave is multithreaded)
replication_connection_configuration Configuration parameters for connecting to the master
replication_connection_status Current status of the connection to the master
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
session_status Status variables for current session
session_variables System variables for current session
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_threads Instrumented thread names and attributes
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
status_by_account Session status variables per account
status_by_host Session status variables per host name
status_by_thread Session status variables per session
status_by_user Session status variables per user name
table_handles Table locks and lock requests
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
user_defined_functions Registered user-defined functions
user_variables_by_thread User-defined variables per thread
users Connection statistics per client user name
variables_by_thread Session system variables per session
variables_info How system variables were most recently set


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.