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 TablesPerformance Schema accounts TablePerformance Schema cond_instances TablePerformance Schema events_stages_current TablePerformance Schema events_stages_history TablePerformance Schema events_stages_history_long TablePerformance Schema events_stages_summary_by_account_by_event_name TablePerformance Schema events_stages_summary_by_host_by_event_name TablePerformance Schema events_stages_summary_by_thread_by_event_name TablePerformance Schema events_stages_summary_by_user_by_event_name TablePerformance Schema events_stages_summary_global_by_event_name TablePerformance Schema events_statements_current TablePerformance Schema events_statements_history TablePerformance Schema events_statements_history_long TablePerformance Schema events_statements_summary_by_account_by_event_name TablePerformance Schema events_statements_summary_by_digest TablePerformance Schema events_statements_summary_by_host_by_event_name TablePerformance Schema events_statements_summary_by_program TablePerformance Schema events_statements_summary_by_thread_by_event_name TablePerformance Schema events_statements_summary_by_user_by_event_name TablePerformance Schema events_statements_summary_global_by_event_name TablePerformance Schema events_transactions_current TablePerformance Schema events_transactions_history TablePerformance Schema events_transactions_history_long TablePerformance Schema events_transactions_summary_by_account_by_event_name TablePerformance Schema events_transactions_summary_by_host_by_event_name TablePerformance Schema events_transactions_summary_by_thread_by_event_name TablePerformance Schema events_transactions_summary_by_user_by_event_name TablePerformance Schema events_transactions_summary_global_by_event_name TablePerformance Schema events_waits_current TablePerformance Schema events_waits_history TablePerformance Schema events_waits_history_long TablePerformance Schema events_waits_summary_by_account_by_event_name TablePerformance Schema events_waits_summary_by_host_by_event_name TablePerformance Schema events_waits_summary_by_instance TablePerformance Schema events_waits_summary_by_thread_by_event_name TablePerformance Schema events_waits_summary_by_user_by_event_name TablePerformance Schema events_waits_summary_global_by_event_name TablePerformance Schema file_instances TablePerformance Schema file_summary_by_event_name TablePerformance Schema file_summary_by_instance TablePerformance Schema global_status TablePerformance Schema host_cache TablePerformance Schema hosts TablePerformance Schema memory_summary_by_account_by_event_name TablePerformance Schema memory_summary_by_host_by_event_name TablePerformance Schema memory_summary_by_thread_by_event_name TablePerformance Schema memory_summary_by_user_by_event_name TablePerformance Schema memory_summary_global_by_event_name TablePerformance Schema metadata_locks TablePerformance Schema mutex_instances TablePerformance Schema objects_summary_global_by_type TablePerformance Schema performance_timers TablePerformance Schema prepared_statements_instances TablePerformance Schema replication_applier_configuration TablePerformance Schema replication_applier_status TablePerformance Schema replication_applier_status_by_coordinator TablePerformance Schema replication_applier_status_by_worker TablePerformance Schema replication_connection_configuration TablePerformance Schema rwlock_instances TablePerformance Schema session_account_connect_attrs TablePerformance Schema session_connect_attrs TablePerformance Schema session_status TablePerformance Schema setup_actors TablePerformance Schema setup_consumers TablePerformance Schema setup_instruments TablePerformance Schema setup_objects TablePerformance Schema setup_timers TablePerformance Schema socket_instances TablePerformance Schema socket_summary_by_event_name TablePerformance Schema socket_summary_by_instance TablePerformance Schema status_by_account TablePerformance Schema status_by_host TablePerformance Schema status_by_thread TablePerformance Schema status_by_user TablePerformance Schema table_handles TablePerformance Schema table_io_waits_summary_by_index_usage TablePerformance Schema table_io_waits_summary_by_table TablePerformance Schema table_lock_waits_summary_by_table TablePerformance Schema threads TablePerformance Schema users TablePerformance Schema user_variables_by_thread Table
Last updated
Was this helpful?