Performance Schema Tables

Explore the tables in the performance_schema database, which expose granular metrics on server events, locks, threads, and I/O for detailed performance analysis.

• List of Performance Schema Tables

• Performance Schema accounts Table

• Performance Schema cond_instances Table

• Performance Schema events_stages_current Table

• Performance Schema events_stages_history Table

• Performance Schema events_stages_history_long Table

• Performance Schema events_stages_summary_by_account_by_event_name Table

• Performance Schema events_stages_summary_by_host_by_event_name Table

• Performance Schema events_stages_summary_by_thread_by_event_name Table

• Performance Schema events_stages_summary_by_user_by_event_name Table

• Performance Schema events_stages_summary_global_by_event_name Table

• Performance Schema events_statements_current Table

• Performance Schema events_statements_history Table

• Performance Schema events_statements_history_long Table

• Performance Schema events_statements_summary_by_account_by_event_name Table

• Performance Schema events_statements_summary_by_digest Table

• Performance Schema events_statements_summary_by_host_by_event_name Table

• Performance Schema events_statements_summary_by_program Table

• Performance Schema events_statements_summary_by_thread_by_event_name Table

• Performance Schema events_statements_summary_by_user_by_event_name Table

• Performance Schema events_statements_summary_global_by_event_name Table

• Performance Schema events_transactions_current Table

• Performance Schema events_transactions_history Table

• Performance Schema events_transactions_history_long Table

• Performance Schema events_transactions_summary_by_account_by_event_name Table

• Performance Schema events_transactions_summary_by_host_by_event_name Table

• Performance Schema events_transactions_summary_by_thread_by_event_name Table

• Performance Schema events_transactions_summary_by_user_by_event_name Table

• Performance Schema events_transactions_summary_global_by_event_name Table

• Performance Schema events_waits_current Table

• Performance Schema events_waits_history Table

• Performance Schema events_waits_history_long Table

• Performance Schema events_waits_summary_by_account_by_event_name Table

• Performance Schema events_waits_summary_by_host_by_event_name Table

• Performance Schema events_waits_summary_by_instance Table

• Performance Schema events_waits_summary_by_thread_by_event_name Table

• Performance Schema events_waits_summary_by_user_by_event_name Table

• Performance Schema events_waits_summary_global_by_event_name Table

• Performance Schema file_instances Table

• Performance Schema file_summary_by_event_name Table

• Performance Schema file_summary_by_instance Table

• Performance Schema global_status Table

• Performance Schema host_cache Table

• Performance Schema hosts Table

• Performance Schema memory_summary_by_account_by_event_name Table

• Performance Schema memory_summary_by_host_by_event_name Table

• Performance Schema memory_summary_by_thread_by_event_name Table

• Performance Schema memory_summary_by_user_by_event_name Table

• Performance Schema memory_summary_global_by_event_name Table

• Performance Schema metadata_locks Table

• Performance Schema mutex_instances Table

• Performance Schema objects_summary_global_by_type Table

• Performance Schema performance_timers Table

• Performance Schema prepared_statements_instances Table

• Performance Schema replication_applier_configuration Table

• Performance Schema replication_applier_status Table

• Performance Schema replication_applier_status_by_coordinator Table

• Performance Schema replication_applier_status_by_worker Table

• Performance Schema replication_connection_configuration Table

• Performance Schema rwlock_instances Table

• Performance Schema session_account_connect_attrs Table

• Performance Schema session_connect_attrs Table

• Performance Schema session_status Table

• Performance Schema setup_actors Table

• Performance Schema setup_consumers Table

• Performance Schema setup_instruments Table

• Performance Schema setup_objects Table

• Performance Schema setup_timers Table

• Performance Schema socket_instances Table

• Performance Schema socket_summary_by_event_name Table

• Performance Schema socket_summary_by_instance Table

• Performance Schema status_by_account Table

• Performance Schema status_by_host Table

• Performance Schema status_by_thread Table

• Performance Schema status_by_user Table

• Performance Schema table_handles Table

• Performance Schema table_io_waits_summary_by_index_usage Table

• Performance Schema table_io_waits_summary_by_table Table

• Performance Schema table_lock_waits_summary_by_table Table

• Performance Schema threads Table

• Performance Schema users Table

• Performance Schema user_variables_by_thread Table

_{This page is licensed: CC BY-SA / Gnu FDL}