下表汇总了所有可用的Performance Schema表。有关更详细的信息,请参见各个表的描述。
表27.1性能模式表
账户
binary_log_transaction_compression_stats
clone_progress
clone_status
cond_instances
data_lock_waits
data_locks.
error_log.
events_errors_summary_by_account_by_error.
events_errors_summary_by_host_by_error
events_errors_summary_by_thread_by_error
events_errors_summary_by_user_by_error.
events_errors_summary_global_by_error.
events_stages_current
events_stages_history.
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name.
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name.
events_statements_current
events_statements_histogram_by_digest
events_statements_histogram_global
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name.
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_program.
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name.
events_statements_summary_global_by_event_name.
events_transactions_current
events_transactions_history
events_transactions_history_long.
events_transactions_summary_by_account_by_event_name
events_transactions_summary_by_host_by_event_name.
events_transactions_summary_by_thread_by_event_name
events_transactions_summary_by_user_by_event_name.
events_transactions_summary_global_by_event_name
events_waits_current
events_waits_history.
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance.
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances.
file_summary_by_event_name.
file_summary_by_instance.
firewall_group_allowlist.
防火墙_小组
firewall_membership
global_status
global_variables.
host_cache.
主机
keyring_component_status.
keyring_keys
log_status
memory_summary_by_account_by_event_name
memory_summary_by_host_by_event_name
memory_summary_by_thread_by_event_name
memory_summary_by_user_by_event_name.
memory_summary_global_by_event_name
元数据_Locks.
umex_instances.
ndb_sync_excluded_objects
ndb_sync_pending_objects
objects_summary_global_by_type
performance_timers
persisted_variables.
prepared_statements_instances
流行列表
Replication_applier_Configuration.
Replication_applier_filters.
replication_applier_global_filters
replication_applier_status
replication_applier_status_by_coordinator
Replication_applier_Status_By_Worker.
replication_asynchronous_connection_failover
replication_asynchronous_connection_failover_managed
replication_connection_configuration
replication_connection_status
replication_group_member_stats
Replication_Group_Members.
rwlock_instances.
session_account_connect_attrs.
session_connect_attrs
session_status.
session_variables
setup_actors.
setup_consumers
setup_instruments
setup_objects.
setup_threads
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
status_by_account
status_by_host
status_by_thread
status_by_user.
table_handles.
table_io_waits_summary_by_index_usage.
table_io_waits_summary_by_table.
table_lock_waits_summary_by_table
线程
tls_channel_status
tp_thread_group_state
tp_thread_group_stats
tp_thread_state
user_defining_functions.
user_variables_by_thread
用户
variables_by_thread
variables_info