7.1.6 Server Status Variable Reference

Skip to Main Content

MySQL 8.4 Reference Manual Including MySQL NDB Cluster 8.4

7.1.6 Server Status Variable Reference

The following table lists all status variables applicable within mysqld.

The table lists each variable's data type and scope. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the variables. Where appropriate, direct links to further information about the items are provided.

Table 7.3 Status Variable Summary

Variable Name Variable Type Variable Scope
Aborted_clients Integer Global
Aborted_connects Integer Global
Acl_cache_items_count Integer Global
Audit_log_current_size Integer Global
Audit_log_direct_writes Integer Global
Audit_log_event_max_drop_size Integer Global
Audit_log_events Integer Global
Audit_log_events_filtered Integer Global
Audit_log_events_lost Integer Global
Audit_log_events_written Integer Global
Audit_log_total_size Integer Global
Audit_log_write_waits Integer Global
Authentication_ldap_sasl_supported_methods String Global
Binlog_cache_disk_use Integer Global
Binlog_cache_use Integer Global
Binlog_stmt_cache_disk_use Integer Global
Binlog_stmt_cache_use Integer Global
Bytes_received Integer Both
Bytes_sent Integer Both
Caching_sha2_password_rsa_public_key String Global
Com_admin_commands Integer Both
Com_alter_db Integer Both
Com_alter_event Integer Both
Com_alter_function Integer Both
Com_alter_procedure Integer Both
Com_alter_resource_group Integer Global
Com_alter_server Integer Both
Com_alter_table Integer Both
Com_alter_tablespace Integer Both
Com_alter_user Integer Both
Com_alter_user_default_role Integer Global
Com_analyze Integer Both
Com_assign_to_keycache Integer Both
Com_begin Integer Both
Com_binlog Integer Both
Com_call_procedure Integer Both
Com_change_db Integer Both
Com_change_repl_filter Integer Both
Com_change_replication_source Integer Both
Com_check Integer Both
Com_checksum Integer Both
Com_clone Integer Global
Com_commit Integer Both
Com_create_db Integer Both
Com_create_event Integer Both
Com_create_function Integer Both
Com_create_index Integer Both
Com_create_procedure Integer Both
Com_create_resource_group Integer Global
Com_create_role Integer Global
Com_create_server Integer Both
Com_create_table Integer Both
Com_create_trigger Integer Both
Com_create_udf Integer Both
Com_create_user Integer Both
Com_create_view Integer Both
Com_dealloc_sql Integer Both
Com_delete Integer Both
Com_delete_multi Integer Both
Com_do Integer Both
Com_drop_db Integer Both
Com_drop_event Integer Both
Com_drop_function Integer Both
Com_drop_index Integer Both
Com_drop_procedure Integer Both
Com_drop_resource_group Integer Global
Com_drop_role Integer Global
Com_drop_server Integer Both
Com_drop_table Integer Both
Com_drop_trigger Integer Both
Com_drop_user Integer Both
Com_drop_view Integer Both
Com_empty_query Integer Both
Com_execute_sql Integer Both
Com_explain_other Integer Both
Com_flush Integer Both
Com_get_diagnostics Integer Both
Com_grant Integer Both
Com_grant_roles Integer Global
Com_group_replication_start Integer Global
Com_group_replication_stop Integer Global
Com_ha_close Integer Both
Com_ha_open Integer Both
Com_ha_read Integer Both
Com_help Integer Both
Com_insert Integer Both
Com_insert_select Integer Both
Com_install_component Integer Global
Com_install_plugin Integer Both
Com_kill Integer Both
Com_load Integer Both
Com_lock_tables Integer Both
Com_optimize Integer Both
Com_preload_keys Integer Both
Com_prepare_sql Integer Both
Com_purge Integer Both
Com_purge_before_date Integer Both
Com_release_savepoint Integer Both
Com_rename_table Integer Both
Com_rename_user Integer Both
Com_repair Integer Both
Com_replace Integer Both
Com_replace_select Integer Both
Com_replica_start Integer Both
Com_replica_stop Integer Both
Com_reset Integer Both
Com_resignal Integer Both
Com_restart Integer Both
Com_revoke Integer Both
Com_revoke_all Integer Both
Com_revoke_roles Integer Global
Com_rollback Integer Both
Com_rollback_to_savepoint Integer Both
Com_savepoint Integer Both
Com_select Integer Both
Com_set_option Integer Both
Com_set_resource_group Integer Global
Com_set_role Integer Global
Com_show_authors Integer Both
Com_show_binary_log_status Integer Both
Com_show_binlog_events Integer Both
Com_show_binlogs Integer Both
Com_show_charsets Integer Both
Com_show_collations Integer Both
Com_show_contributors Integer Both
Com_show_create_db Integer Both
Com_show_create_event Integer Both
Com_show_create_func Integer Both
Com_show_create_proc Integer Both
Com_show_create_table Integer Both
Com_show_create_trigger Integer Both
Com_show_create_user Integer Both
Com_show_databases Integer Both
Com_show_engine_logs Integer Both
Com_show_engine_mutex Integer Both
Com_show_engine_status Integer Both
Com_show_errors Integer Both
Com_show_events Integer Both
Com_show_fields Integer Both
Com_show_function_code Integer Both
Com_show_function_status Integer Both
Com_show_grants Integer Both
Com_show_keys Integer Both
Com_show_ndb_status Integer Both
Com_show_open_tables Integer Both
Com_show_plugins Integer Both
Com_show_privileges Integer Both
Com_show_procedure_code Integer Both
Com_show_procedure_status Integer Both
Com_show_processlist Integer Both
Com_show_profile Integer Both
Com_show_profiles Integer Both
Com_show_relaylog_events Integer Both
Com_show_replica_status Integer Both
Com_show_replicas Integer Both
Com_show_status Integer Both
Com_show_storage_engines Integer Both
Com_show_table_status Integer Both
Com_show_tables Integer Both
Com_show_triggers Integer Both
Com_show_variables Integer Both
Com_show_warnings Integer Both
Com_shutdown Integer Both
Com_signal Integer Both
Com_stmt_close Integer Both
Com_stmt_execute Integer Both
Com_stmt_fetch Integer Both
Com_stmt_prepare Integer Both
Com_stmt_reprepare Integer Both
Com_stmt_reset Integer Both
Com_stmt_send_long_data Integer Both
Com_truncate Integer Both
Com_uninstall_component Integer Global
Com_uninstall_plugin Integer Both
Com_unlock_tables Integer Both
Com_update Integer Both
Com_update_multi Integer Both
Com_xa_commit Integer Both
Com_xa_end Integer Both
Com_xa_prepare Integer Both
Com_xa_recover Integer Both
Com_xa_rollback Integer Both
Com_xa_start Integer Both
Compression Integer Session
Compression_algorithm String Global
Compression_level Integer Global
Connection_control_delay_generated Integer Global
Connection_errors_accept Integer Global
Connection_errors_internal Integer Global
Connection_errors_max_connections Integer Global
Connection_errors_peer_address Integer Global
Connection_errors_select Integer Global
Connection_errors_tcpwrap Integer Global
Connections Integer Global
Created_tmp_disk_tables Integer Both
Created_tmp_files Integer Global
Created_tmp_tables Integer Both
Current_tls_ca File name Global
Current_tls_capath Directory name Global
Current_tls_cert File name Global
Current_tls_cipher String Global
Current_tls_ciphersuites String Global
Current_tls_crl File name Global
Current_tls_crlpath Directory name Global
Current_tls_key File name Global
Current_tls_version String Global
Delayed_errors Integer Global
Delayed_insert_threads Integer Global
Delayed_writes Integer Global
Deprecated_use_i_s_processlist_count Integer Global
Deprecated_use_i_s_processlist_last_timestamp Integer Global
dragnet.Status String Global
Error_log_buffered_bytes Integer Global
Error_log_buffered_events Integer Global
Error_log_expired_events Integer Global
Error_log_latest_write Integer Global
Firewall_access_denied Integer Global
Firewall_access_granted Integer Global
Firewall_access_suspicious Integer Global
Firewall_cached_entries Integer Global
Flush_commands Integer Global
Global_connection_memory Integer Global
Gr_all_consensus_proposals_count Integer Both
Gr_all_consensus_time_sum Integer Both
Gr_certification_garbage_collector_count Integer Both
Gr_certification_garbage_collector_time_sum Integer Both
Gr_consensus_bytes_received_sum Integer Both
Gr_consensus_bytes_sent_sum Integer Both
Gr_control_messages_sent_bytes_sum Integer Both
Gr_control_messages_sent_count Integer Both
Gr_control_messages_sent_roundtrip_time_sum Integer Both
Gr_data_messages_sent_bytes_sum Integer Both
Gr_data_messages_sent_count Integer Both
Gr_data_messages_sent_roundtrip_time_sum Integer Both
Gr_empty_consensus_proposals_count Integer Both
Gr_extended_consensus_count Integer Both
Gr_flow_control_throttle_active_count Integer Global
Gr_flow_control_throttle_count Integer Global
Gr_flow_control_throttle_last_throttle_timestamp Datetime Global
Gr_flow_control_throttle_time_sum Integer Global
Gr_last_consensus_end_timestamp Integer Both
Gr_total_messages_sent_count Integer Both
Gr_transactions_consistency_after_sync_count Integer Both
Gr_transactions_consistency_after_sync_time_sum Integer Both
Gr_transactions_consistency_after_termination_count Integer Both
Gr_transactions_consistency_after_termination_time_sum Integer Both
Gr_transactions_consistency_before_begin_count Integer Both
Gr_transactions_consistency_before_begin_time_sum Integer Both
Handler_commit Integer Both
Handler_delete Integer Both
Handler_discover Integer Both
Handler_external_lock Integer Both
Handler_mrr_init Integer Both
Handler_prepare Integer Both
Handler_read_first Integer Both
Handler_read_key Integer Both
Handler_read_last Integer Both
Handler_read_next Integer Both
Handler_read_prev Integer Both
Handler_read_rnd Integer Both
Handler_read_rnd_next Integer Both
Handler_rollback Integer Both
Handler_savepoint Integer Both
Handler_savepoint_rollback Integer Both
Handler_update Integer Both
Handler_write Integer Both
Innodb_buffer_pool_bytes_data Integer Global
Innodb_buffer_pool_bytes_dirty Integer Global
Innodb_buffer_pool_dump_status String Global
Innodb_buffer_pool_load_status String Global
Innodb_buffer_pool_pages_data Integer Global
Innodb_buffer_pool_pages_dirty Integer Global
Innodb_buffer_pool_pages_flushed Integer Global
Innodb_buffer_pool_pages_free Integer Global
Innodb_buffer_pool_pages_latched Integer Global
Innodb_buffer_pool_pages_misc Integer Global
Innodb_buffer_pool_pages_total Integer Global
Innodb_buffer_pool_read_ahead Integer Global
Innodb_buffer_pool_read_ahead_evicted Integer Global
Innodb_buffer_pool_read_ahead_rnd Integer Global
Innodb_buffer_pool_read_requests Integer Global
Innodb_buffer_pool_reads Integer Global
Innodb_buffer_pool_resize_status String Global
Innodb_buffer_pool_resize_status_code Integer Global
Innodb_buffer_pool_resize_status_progress Integer Global
Innodb_buffer_pool_wait_free Integer Global
Innodb_buffer_pool_write_requests Integer Global
Innodb_data_fsyncs Integer Global
Innodb_data_pending_fsyncs Integer Global
Innodb_data_pending_reads Integer Global
Innodb_data_pending_writes Integer Global
Innodb_data_read Integer Global
Innodb_data_reads Integer Global
[Innodb_data_writes](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/serv

（本文超出站点单文档体积上限，已截断）