7.1.5 Server System Variable Reference

Skip to Main Content

MySQL 8.4 Reference Manual Including MySQL NDB Cluster 8.4

7.1.5 Server System Variable Reference

The following table lists all system variables applicable within mysqld.

The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in one unified list, with an indication of where each option or variable is valid. If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted immediately below the corresponding option. The scope of the variable (Var Scope) 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.2 System Variable Summary

Name Cmd-Line Option File System Var Var Scope Dynamic
activate_all_roles_on_login Yes Yes Yes Global Yes
admin_address Yes Yes Yes Global No
admin_port Yes Yes Yes Global No
admin_ssl_ca Yes Yes Yes Global Yes
admin_ssl_capath Yes Yes Yes Global Yes
admin_ssl_cert Yes Yes Yes Global Yes
admin_ssl_cipher Yes Yes Yes Global Yes
admin_ssl_crl Yes Yes Yes Global Yes
admin_ssl_crlpath Yes Yes Yes Global Yes
admin_ssl_key Yes Yes Yes Global Yes
admin_tls_ciphersuites Yes Yes Yes Global Yes
admin_tls_version Yes Yes Yes Global Yes
audit_log_buffer_size Yes Yes Yes Global No
audit_log_compression Yes Yes Yes Global No
audit_log_connection_policy Yes Yes Yes Global Yes
audit_log_current_session Yes Both No
audit_log_database Yes Yes Yes Global No
audit_log_disable Yes Yes Yes Global Yes
audit_log_encryption Yes Yes Yes Global No
audit_log_exclude_accounts Yes Yes Yes Global Yes
audit_log_file Yes Yes Yes Global No
audit_log_filter_id Yes Both No
audit_log_flush Yes Global Yes
audit_log_flush_interval_seconds Yes Yes Global No
audit_log_format Yes Yes Yes Global No
audit_log_format_unix_timestamp Yes Yes Yes Global Yes
audit_log_include_accounts Yes Yes Yes Global Yes
audit_log_password_history_keep_days Yes Yes Yes Global Yes
audit_log_policy Yes Yes Yes Global No
audit_log_prune_seconds Yes Yes Yes Global Yes
audit_log_read_buffer_size Yes Yes Yes Both Yes
audit_log_rotate_on_size Yes Yes Yes Global Yes
audit_log_statement_policy Yes Yes Yes Global Yes
audit_log_strategy Yes Yes Yes Global No
authentication_kerberos_service_key_tab Yes Yes Yes Global No
authentication_kerberos_service_principal Yes Yes Yes Global Yes
authentication_ldap_sasl_auth_method_name Yes Yes Yes Global Yes
authentication_ldap_sasl_bind_base_dn Yes Yes Yes Global Yes
authentication_ldap_sasl_bind_root_dn Yes Yes Yes Global Yes
authentication_ldap_sasl_bind_root_pwd Yes Yes Yes Global Yes
authentication_ldap_sasl_ca_path Yes Yes Yes Global Yes
authentication_ldap_sasl_connect_timeout Yes Yes Yes Global Yes
authentication_ldap_sasl_group_search_attr Yes Yes Yes Global Yes
authentication_ldap_sasl_group_search_filter Yes Yes Yes Global Yes
authentication_ldap_sasl_init_pool_size Yes Yes Yes Global Yes
authentication_ldap_sasl_log_status Yes Yes Yes Global Yes
authentication_ldap_sasl_max_pool_size Yes Yes Yes Global Yes
authentication_ldap_sasl_referral Yes Yes Yes Global Yes
authentication_ldap_sasl_response_timeout Yes Yes Yes Global Yes
authentication_ldap_sasl_server_host Yes Yes Yes Global Yes
authentication_ldap_sasl_server_port Yes Yes Yes Global Yes
authentication_ldap_sasl_tls Yes Yes Yes Global Yes
authentication_ldap_sasl_user_search_attr Yes Yes Yes Global Yes
authentication_ldap_simple_auth_method_name Yes Yes Yes Global Yes
authentication_ldap_simple_bind_base_dn Yes Yes Yes Global Yes
authentication_ldap_simple_bind_root_dn Yes Yes Yes Global Yes
authentication_ldap_simple_bind_root_pwd Yes Yes Yes Global Yes
authentication_ldap_simple_ca_path Yes Yes Yes Global Yes
authentication_ldap_simple_connect_timeout Yes Yes Yes Global Yes
authentication_ldap_simple_group_search_attr Yes Yes Yes Global Yes
authentication_ldap_simple_group_search_filter Yes Yes Yes Global Yes
authentication_ldap_simple_init_pool_size Yes Yes Yes Global Yes
authentication_ldap_simple_log_status Yes Yes Yes Global Yes
authentication_ldap_simple_max_pool_size Yes Yes Yes Global Yes
authentication_ldap_simple_referral Yes Yes Yes Global Yes
authentication_ldap_simple_response_timeout Yes Yes Yes Global Yes
authentication_ldap_simple_server_host Yes Yes Yes Global Yes
authentication_ldap_simple_server_port Yes Yes Yes Global Yes
authentication_ldap_simple_tls Yes Yes Yes Global Yes
authentication_ldap_simple_user_search_attr Yes Yes Yes Global Yes
authentication_policy Yes Yes Yes Global Yes
authentication_webauthn_rp_id Yes Yes Yes Global Yes
authentication_windows_log_level Yes Yes Yes Global No
authentication_windows_use_principal_name Yes Yes Yes Global No
auto_generate_certs Yes Yes Yes Global No
auto_increment_increment Yes Yes Yes Both Yes
auto_increment_offset Yes Yes Yes Both Yes
autocommit Yes Yes Yes Both Yes
automatic_sp_privileges Yes Yes Yes Global Yes
back_log Yes Yes Yes Global No
basedir Yes Yes Yes Global No
big_tables Yes Yes Yes Both Yes
bind_address Yes Yes Yes Global No
binlog_cache_size Yes Yes Yes Global Yes
binlog_checksum Yes Yes Yes Global Yes
binlog_direct_non_transactional_updates Yes Yes Yes Both Yes
binlog_encryption Yes Yes Yes Global Yes
binlog_error_action Yes Yes Yes Global Yes
binlog_expire_logs_auto_purge Yes Yes Yes Global Yes
binlog_expire_logs_seconds Yes Yes Yes Global Yes
binlog_format Yes Yes Yes Both Yes
binlog_group_commit_sync_delay Yes Yes Yes Global Yes
binlog_group_commit_sync_no_delay_count Yes Yes Yes Global Yes
binlog_gtid_simple_recovery Yes Yes Yes Global No
binlog_max_flush_queue_time Yes Yes Yes Global Yes
binlog_order_commits Yes Yes Yes Global Yes
binlog_rotate_encryption_master_key_at_startup Yes Yes Yes Global No
binlog_row_event_max_size Yes Yes Yes Global No
binlog_row_image Yes Yes Yes Both Yes
binlog_row_metadata Yes Yes Yes Global Yes
binlog_row_value_options Yes Yes Yes Both Yes
binlog_rows_query_log_events Yes Yes Yes Both Yes
binlog_stmt_cache_size Yes Yes Yes Global Yes
binlog_transaction_compression Yes Yes Yes Both Yes
binlog_transaction_compression_level_zstd Yes Yes Yes Both Yes
binlog_transaction_dependency_history_size Yes Yes Yes Global Yes
block_encryption_mode Yes Yes Yes Both Yes
build_id Yes Global No
bulk_insert_buffer_size Yes Yes Yes Both Yes
caching_sha2_password_auto_generate_rsa_keys Yes Yes Yes Global No
caching_sha2_password_digest_rounds Yes Yes Yes Global Yes
caching_sha2_password_private_key_path Yes Yes Yes Global No
caching_sha2_password_public_key_path Yes Yes Yes Global No
character_set_client Yes Both Yes
character_set_connection Yes Both Yes
character_set_database (note 1) Yes Both Yes
character_set_filesystem Yes Yes Yes Both Yes
character_set_results Yes Both Yes
character_set_server Yes Yes Yes Both Yes
character_set_system Yes Global No
character_sets_dir Yes Yes Yes Global No
check_proxy_users Yes Yes Yes Global Yes
clone_autotune_concurrency Yes Yes Yes Global Yes
clone_block_ddl Yes Yes Yes Global Yes
clone_buffer_size Yes Yes Yes Global Yes
clone_ddl_timeout Yes Yes Yes Global Yes
clone_delay_after_data_drop Yes Yes Yes Global Yes
clone_donor_timeout_after_network_failure Yes Yes Yes Global Yes
clone_enable_compression Yes Yes Yes Global Yes
clone_max_concurrency Yes Yes Yes Global Yes
clone_max_data_bandwidth Yes Yes Yes Global Yes
clone_max_network_bandwidth Yes Yes Yes Global Yes
clone_ssl_ca Yes Yes Yes Global Yes
clone_ssl_cert Yes Yes Yes Global Yes
clone_ssl_key Yes Yes Yes Global Yes
clone_valid_donor_list Yes Yes Yes Global Yes
collation_connection Yes Both Yes
collation_database (note 1) Yes Both Yes
collation_server Yes Yes Yes Both Yes
completion_type Yes Yes Yes Both Yes
component_masking.dictionaries_flush_interval_seconds Yes Yes Yes Global No
component_masking.masking_database Yes Yes Yes Global No
component_scheduler.enabled Yes Yes Yes Global Yes
concurrent_insert Yes Yes Yes Global Yes
connect_timeout Yes Yes Yes Global Yes
connection_control_failed_connections_threshold Yes Yes Yes Global Yes
connection_control_max_connection_delay Yes Yes Yes Global Yes
connection_control_min_connection_delay Yes Yes Yes Global Yes
connection_memory_chunk_size Yes Yes Yes Both Yes
connection_memory_limit Yes Yes Yes Both Yes
core_file Yes Global No
create_admin_listener_thread Yes Yes Yes Global No
cte_max_recursion_depth Yes Yes Yes Both Yes
datadir Yes Yes Yes Global No
debug Yes Yes Yes Both Yes
debug_sync Yes Session Yes
default_collation_for_utf8mb4 Yes Both Yes
default_password_lifetime Yes Yes Yes Global Yes
default_storage_engine Yes Yes Yes Both Yes
default_table_encryption Yes Yes Yes Both Yes
default_tmp_storage_engine Yes Yes Yes Both Yes
default_week_format Yes Yes Yes Both Yes
delay_key_write Yes Yes Yes Global Yes
delayed_insert_limit Yes Yes Yes Global Yes
delayed_insert_timeout Yes Yes Yes Global Yes
delayed_queue_size Yes Yes Yes Global Yes
disabled_storage_engines Yes Yes Yes Global No
disconnect_on_expired_password Yes Yes Yes Global No
div_precision_increment Yes Yes Yes Both Yes
dragnet.log_error_filter_rules Yes Yes Yes Global Yes
end_markers_in_json Yes Yes Yes Both Yes
enforce_gtid_consistency Yes Yes Yes Global Yes
enterprise_encryption.maximum_rsa_key_size Yes Yes Yes Global Yes
enterprise_encryption.rsa_support_legacy_padding Yes Yes Yes Global Yes
eq_range_index_dive_limit Yes Yes Yes Both Yes
error_count Yes Session No
event_scheduler Yes Yes Yes Global Yes
explain_format Yes Yes Yes Both Yes
explain_json_format_version Yes Yes Yes Both Yes
explicit_defaults_for_timestamp Yes Yes Yes Both Yes
external_user Yes Session No
flush Yes Yes Yes Global Yes
flush_time Yes Yes Yes Global Yes
foreign_key_checks Yes Both Yes
ft_boolean_syntax Yes Yes Yes Global Yes
ft_max_word_len Yes Yes Yes Global No
ft_min_word_len Yes Yes Yes Global No
ft_query_expansion_limit Yes Yes Yes Global No
ft_stopword_file Yes Yes Yes Global No
general_log Yes Yes Yes Global Yes
general_log_file Yes Yes Yes Global Yes
generated_random_password_length Yes Yes Yes Both Yes
global_connection_memory_limit Yes Yes Yes Global Yes
global_connection_memory_tracking Yes Yes Yes Both Yes
group_concat_max_len Yes Yes Yes Both Yes
group_replication_advertise_recovery_endpoints Yes Yes Yes Global Yes
group_replication_allow_local_lower_version_join Yes Yes Yes Global Yes
group_replication_auto_increment_increment Yes Yes Yes Global Yes
group_replication_autorejoin_tries Yes Yes Yes Global Yes
group_replication_bootstrap_group Yes Yes Yes Global Yes
group_replication_clone_threshold Yes Yes Yes Global Yes
group_replication_communication_debug_options Yes Yes Yes Global Yes
group_replication_communication_max_message_size Yes Yes Yes Global Yes
group_replication_communication_stack Yes Global Yes
group_replication_components_stop_timeout Yes Yes Yes Global Yes
group_replication_compression_threshold Yes Yes Yes Global Yes
group_replication_consistency Yes Yes Yes Both Yes
group_replication_enforce_update_everywhere_checks Yes Yes Yes Global Yes
group_replication_exit_state_action Yes Yes Yes Global Yes
group_replication_flow_control_applier_threshold Yes Yes Yes Global Yes
group_replication_flow_control_certifier_threshold Yes Yes Yes Global Yes
group_replication_flow_control_hold_percent Yes Yes Yes Global Yes
group_replication_flow_control_max_quota Yes Yes Yes Global Yes
group_replication_flow_control_member_quota_percent Yes Yes Yes Global Yes
group_replication_flow_control_min_quota Yes Yes Yes Global Yes
group_replication_flow_control_min_recovery_quota Yes Yes Yes Global Yes
group_replication_flow_control_mode Yes Yes Yes Global Yes
group_replication_flow_control_period Yes Yes Yes Global Yes
group_replication_flow_control_release_percent Yes Yes Yes Global Yes
group_replication_force_members Yes Yes Yes Global Yes
group_replication_group_name Yes Yes Yes Global Yes
group_replication_group_seeds Yes Yes Yes Global Yes
group_replication_gtid_assignment_block_size Yes Yes Yes Global Yes
group_replication_ip_allowlist Yes Yes Yes Global Yes
group_replication_local_address Yes Yes Yes Global Yes
group_replication_member_expel_timeout Yes Yes Yes Global Yes
group_replication_member_weight Yes Yes Yes Global Yes
group_replication_message_cache_size Yes Yes Yes Global Yes
group_replication_paxos_single_leader Yes Yes Yes Global Yes
group_replication_poll_spin_loops Yes Yes Yes Global Yes
[group_

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