Documentation Home
MySQL 8.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 39.8Mb
PDF (A4) - 39.9Mb
Man Pages (TGZ) - 257.9Kb
Man Pages (Zip) - 364.9Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb


MySQL 8.4 Reference Manual  /  ...  /  Server Option, System Variable, and Status Variable Reference

7.1.4 服务器选项、系统变量和状态变量参考

The following table lists all command-line options, system variables, and status 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. For system and status variables, 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 options and variables. Where appropriate, direct links to further information about the items are provided.

For a version of this table that is specific to NDB Cluster, see Section 25.4.2.5, “NDB Cluster mysqld Option and Variable Reference”.

Table 7.1 Command-Line Option, System Variable, and Status Variable Summary

Name Cmd-Line Option File System Var Status Var Var Scope Dynamic
Aborted_clients Yes Global No
Aborted_connects Yes Global No
Acl_cache_items_count Yes Global No
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
allow-suspicious-udfs Yes Yes
ansi Yes Yes
audit-log Yes 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_current_size Yes Global No
audit_log_database Yes Yes Yes Global No
Audit_log_direct_writes Yes Global No
audit_log_disable Yes Yes Yes Global Yes
audit_log_encryption Yes Yes Yes Global No
Audit_log_event_max_drop_size Yes Global No
Audit_log_events Yes Global No
Audit_log_events_filtered Yes Global No
Audit_log_events_lost Yes Global No
Audit_log_events_written 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_max_size 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
Audit_log_total_size Yes Global No
Audit_log_write_waits 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_supported_methods Yes Global No
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_disk_use Yes Global No
binlog_cache_size Yes Yes Yes Global Yes
Binlog_cache_use Yes Global No
binlog-checksum Yes Yes
binlog_checksum Yes Yes Yes Global Yes
binlog_direct_non_transactional_updates Yes Yes Yes Both Yes
binlog-do-db Yes 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-ignore-db Yes Yes
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_disk_use Yes Global No
binlog_stmt_cache_size Yes Yes Yes Global Yes
Binlog_stmt_cache_use Yes Global No
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
Bytes_received Yes Both No
Bytes_sent Yes Both No
caching_sha2_password_auto_generate_rsa_keys Yes Yes Yes Global No
caching_sha2_password_digest_rounds Yes Yes Yes Global No
caching_sha2_password_private_key_path Yes Yes Yes Global No
caching_sha2_password_public_key_path Yes Yes Yes Global No
Caching_sha2_password_rsa_public_key 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
chroot Yes 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
Com_admin_commands Yes Both No
Com_alter_db Yes Both No
Com_alter_event Yes Both No
Com_alter_function Yes Both No
Com_alter_procedure Yes Both No
Com_alter_resource_group Yes Global No
Com_alter_server Yes Both No
Com_alter_table Yes Both No
Com_alter_tablespace Yes Both No
Com_alter_user Yes Both No
Com_alter_user_default_role Yes Global No
Com_analyze Yes Both No
Com_assign_to_keycache Yes Both No
Com_begin Yes Both No
Com_binlog Yes Both No
Com_call_procedure Yes Both No
Com_change_db Yes Both No
Com_change_repl_filter Yes Both No
Com_change_replication_source Yes Both No
Com_check Yes Both No
Com_checksum Yes Both No
Com_clone Yes Global No
Com_commit Yes Both No
Com_create_db Yes Both No
Com_create_event Yes Both No
Com_create_function Yes Both No
Com_create_index Yes Both No
Com_create_procedure Yes Both No
Com_create_resource_group Yes Global No
Com_create_role Yes Global No
Com_create_server Yes Both No
Com_create_table Yes Both No
Com_create_trigger Yes Both No
Com_create_udf Yes Both No
Com_create_user Yes Both No
Com_create_view Yes Both No
Com_dealloc_sql Yes Both No
Com_delete Yes Both No
Com_delete_multi Yes Both No
Com_do Yes Both No
Com_drop_db Yes Both No
Com_drop_event Yes Both No
Com_drop_function Yes Both No
Com_drop_index Yes Both No
Com_drop_procedure Yes Both No
Com_drop_resource_group Yes Global No
Com_drop_role Yes Global No
Com_drop_server Yes Both No
Com_drop_table Yes Both No
Com_drop_trigger Yes Both No
Com_drop_user Yes Both No
Com_drop_view Yes Both No
Com_empty_query Yes Both No
Com_execute_sql Yes Both No
Com_explain_other Yes Both No
Com_flush Yes Both No
Com_get_diagnostics Yes Both No
Com_grant Yes Both No
Com_grant_roles Yes Global No
Com_group_replication_start Yes Global No
Com_group_replication_stop Yes Global No
Com_ha_close Yes Both No
Com_ha_open Yes Both No
Com_ha_read Yes Both No
Com_help Yes Both No
Com_insert Yes Both No
Com_insert_select Yes Both No
Com_install_component Yes Global No
Com_install_plugin Yes Both No
Com_kill Yes Both No
Com_load Yes Both No
Com_lock_tables Yes Both No
Com_optimize Yes Both No
Com_preload_keys Yes Both No
Com_prepare_sql Yes Both No
Com_purge Yes Both No
Com_purge_before_date Yes Both No
Com_release_savepoint Yes Both No
Com_rename_table Yes Both No
Com_rename_user Yes Both No
Com_repair Yes Both No
Com_replace Yes Both No
Com_replace_select Yes Both No
Com_replica_start Yes Both No
Com_replica_stop Yes Both No
Com_reset Yes Both No
Com_resignal Yes Both No
Com_restart Yes Both No
Com_revoke Yes Both No
Com_revoke_all Yes Both No
Com_revoke_roles Yes Global No
Com_rollback Yes Both No
Com_rollback_to_savepoint Yes Both No
Com_savepoint Yes Both No
Com_select Yes Both No
Com_set_option Yes Both No
Com_set_resource_group Yes Global No
Com_set_role Yes Global No
Com_show_authors Yes Both No
Com_show_binary_log_status Yes Both No
Com_show_binlog_events Yes Both No
Com_show_binlogs Yes Both No
Com_show_charsets Yes Both No
Com_show_collations Yes Both No
Com_show_contributors Yes Both No
Com_show_create_db Yes Both No
Com_show_create_event Yes Both No
Com_show_create_func Yes Both No
Com_show_create_proc Yes Both No
Com_show_create_table Yes Both No
Com_show_create_trigger Yes Both No
Com_show_create_user Yes Both No
Com_show_databases Yes Both No
Com_show_engine_logs Yes Both No
Com_show_engine_mutex Yes Both No
Com_show_engine_status Yes Both No
Com_show_errors Yes Both No
Com_show_events Yes Both No
Com_show_fields Yes Both No
Com_show_function_code Yes Both No
Com_show_function_status Yes Both No
Com_show_grants Yes Both No
Com_show_keys Yes Both No
Com_show_ndb_status Yes Both No
Com_show_open_tables Yes Both No
Com_show_plugins Yes Both No
Com_show_privileges Yes Both No
Com_show_procedure_code Yes Both No
Com_show_procedure_status Yes Both No
Com_show_processlist Yes Both No
Com_show_profile Yes Both No
Com_show_profiles Yes Both No
Com_show_relaylog_events Yes Both No
Com_show_replica_status Yes Both No
Com_show_replicas Yes Both No
Com_show_status Yes Both No
Com_show_storage_engines Yes Both No
Com_show_table_status Yes Both No
Com_show_tables Yes Both No
Com_show_triggers Yes Both No
Com_show_variables Yes Both No
Com_show_warnings Yes Both No
Com_shutdown Yes Both No
Com_signal Yes Both No
Com_stmt_close Yes Both No
Com_stmt_execute Yes Both No
Com_stmt_fetch Yes Both No
Com_stmt_prepare Yes Both No
Com_stmt_reprepare Yes Both No
Com_stmt_reset Yes Both No
Com_stmt_send_long_data Yes Both No
Com_truncate Yes Both No
Com_uninstall_component Yes Global No
Com_uninstall_plugin Yes Both No
Com_unlock_tables Yes Both No
Com_update Yes Both No
Com_update_multi Yes Both No
Com_xa_commit Yes Both No
Com_xa_end Yes Both No
Com_xa_prepare Yes Both No
Com_xa_recover Yes Both No
Com_xa_rollback Yes Both No
Com_xa_start Yes Both No
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
Compression Yes Session No
Compression_algorithm Yes Global No
Compression_level Yes Global No
concurrent_insert Yes Yes Yes Global Yes
connect_timeout Yes Yes Yes Global Yes
Connection_control_delay_generated Yes Global No
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_errors_accept Yes Global No
Connection_errors_internal Yes Global No
Connection_errors_max_connections Yes Global No
Connection_errors_peer_address Yes Global No
Connection_errors_select Yes Global No
Connection_errors_tcpwrap Yes Global No
connection_memory_chunk_size Yes Yes Yes Both Yes
connection_memory_limit Yes Yes Yes Both Yes
Connections Yes Global No
console Yes Yes
core-file Yes Yes
core_file Yes Global No
create_admin_listener_thread Yes Yes Yes Global No
Created_tmp_disk_tables Yes Both No
Created_tmp_files Yes Global No
Created_tmp_tables Yes Both No
cte_max_recursion_depth Yes Yes Yes Both Yes
Current_tls_ca Yes Global No
Current_tls_capath Yes Global No
Current_tls_cert Yes Global No
Current_tls_cipher Yes Global No
Current_tls_ciphersuites Yes Global No
Current_tls_crl Yes Global No
Current_tls_crlpath Yes Global No
Current_tls_key Yes Global No
Current_tls_version Yes Global No
daemonize Yes Yes
datadir Yes Yes Yes Global No
ddl-rewriter Yes Yes
debug Yes Yes Yes Both Yes
debug_sync Yes Session Yes
debug-sync-timeout Yes 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-time-zone Yes Yes
default_tmp_storage_engine Yes Yes Yes Both Yes
default_week_format Yes Yes Yes Both Yes
defaults-extra-file Yes
defaults-file Yes
defaults-group-suffix Yes
delay_key_write Yes Yes Yes Global Yes
Delayed_errors Yes Global No
delayed_insert_limit Yes Yes Yes Global Yes
Delayed_insert_threads Yes Global No
delayed_insert_timeout Yes Yes Yes Global Yes
delayed_queue_size Yes Yes Yes Global Yes
Delayed_writes Yes Global No
Deprecated_use_i_s_processlist_count Yes Global No
Deprecated_use_i_s_processlist_last_timestamp Yes Global No
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
dragnet.Status Yes Global No
early-plugin-load Yes 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
Error_log_buffered_bytes Yes Global No
Error_log_buffered_events Yes Global No
Error_log_expired_events Yes Global No
Error_log_latest_write Yes Global No
event_scheduler Yes Yes Yes Global Yes
exit-info Yes 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-locking Yes Yes
- Variable: skip_external_locking
external_user Yes Session No
federated Yes Yes
Firewall_access_denied Yes Global No
Firewall_access_granted Yes Global No
Firewall_cached_entries Yes Global No
flush Yes Yes Yes Global Yes
Flush_commands Yes Global No
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
gdb Yes Yes
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 Yes Global No
global_connection_memory_limit Yes Yes Yes Global Yes
global_connection_memory_tracking Yes Yes Yes Both Yes
Gr_all_consensus_proposals_count Yes Both No
Gr_all_consensus_time_sum Yes Both No
Gr_certification_garbage_collector_count Yes Both No
Gr_certification_garbage_collector_time_sum Yes Both No
Gr_consensus_bytes_received_sum Yes Both No
Gr_consensus_bytes_sent_sum Yes Both No
Gr_control_messages_sent_bytes_sum Yes Both No
Gr_control_messages_sent_count Yes Both No
Gr_control_messages_sent_roundtrip_time_sum Yes Both No
Gr_data_messages_sent_bytes_sum Yes Both No
Gr_data_messages_sent_count Yes Both No
Gr_data_messages_sent_roundtrip_time_sum Yes Both No
Gr_empty_consensus_proposals_count Yes Both No
Gr_extended_consensus_count Yes Both No
Gr_last_consensus_end_timestamp Yes Both No
Gr_total_messages_sent_count Yes Both No
Gr_transactions_consistency_after_sync_count Yes Both No
Gr_transactions_consistency_after_sync_time_sum Yes Both No
Gr_transactions_consistency_after_termination_count Yes Both No
Gr_transactions_consistency_after_termination_time_sum Yes Both No
Gr_transactions_consistency_before_begin_count Yes Both No
Gr_transactions_consistency_before_begin_time_sum Yes Both No
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_replication_recovery_compression_algorithms Yes Yes Yes Global Yes
group_replication_recovery_get_public_key Yes Yes Yes Global Yes
group_replication_recovery_public_key_path Yes Yes Yes Global Yes
group_replication_recovery_reconnect_interval Yes Yes Yes Global Yes
group_replication_recovery_retry_count Yes Yes Yes Global Yes
group_replication_recovery_ssl_ca Yes Yes Yes Global Yes
group_replication_recovery_ssl_capath Yes Yes Yes Global Yes
group_replication_recovery_ssl_cert Yes Yes Yes Global Yes
group_replication_recovery_ssl_cipher Yes Yes Yes Global Yes
group_replication_recovery_ssl_crl Yes Yes Yes Global Yes
group_replication_recovery_ssl_crlpath Yes Yes Yes Global Yes
group_replication_recovery_ssl_key Yes Yes Yes Global Yes
group_replication_recovery_ssl_verify_server_cert Yes Yes Yes Global Yes
group_replication_recovery_tls_ciphersuites Yes Yes Yes Global Yes
group_replication_recovery_tls_version Yes Yes Yes Global Yes
group_replication_recovery_use_ssl Yes Yes Yes Global Yes
group_replication_recovery_zstd_compression_level Yes Yes Yes Global Yes
group_replication_single_primary_mode Yes Yes Yes Global Yes
group_replication_ssl_mode Yes Yes Yes Global Yes
group_replication_start_on_boot Yes Yes Yes Global Yes
group_replication_tls_source Yes Yes Yes Global Yes
group_replication_transaction_size_limit Yes Yes Yes Global Yes
group_replication_unreachable_majority_timeout Yes Yes Yes Global Yes
group_replication_view_change_uuid Yes Yes Yes Global Yes
gtid_executed Yes Global No
gtid_executed_compression_period Yes Yes Yes Global Yes
gtid_mode Yes Yes Yes Global Yes
gtid_next Yes Session Yes
gtid_owned Yes Both No
gtid_purged Yes Global Yes
Handler_commit Yes Both No
Handler_delete Yes Both No
Handler_discover Yes Both No
Handler_external_lock Yes Both No
Handler_mrr_init Yes Both No
Handler_prepare Yes Both No
Handler_read_first Yes Both No
Handler_read_key Yes Both No
Handler_read_last Yes Both No
Handler_read_next Yes Both No
Handler_read_prev Yes Both No
Handler_read_rnd Yes Both No
Handler_read_rnd_next Yes Both No
Handler_rollback Yes Both No
Handler_savepoint Yes Both No
Handler_savepoint_rollback Yes Both No
Handler_update Yes Both No
Handler_write Yes Both No
have_compress Yes Global No
have_dynamic_loading Yes Global No
have_geometry Yes Global No
have_profiling Yes Global No
have_query_cache Yes Global No
have_rtree_keys Yes Global No
have_statement_timeout Yes Global No
have_symlink Yes Global No
help Yes Yes
histogram_generation_max_mem_size Yes Yes Yes Both Yes
host_cache_size Yes Yes Yes Global Yes
hostname Yes Global No
identity Yes Session Yes
immediate_server_version Yes Session Yes
information_schema_stats_expiry Yes Yes Yes Both Yes
init_connect Yes Yes Yes Global Yes
init_file Yes Yes Yes Global No
init_replica Yes Yes Yes Global Yes
init_slave Yes Yes Yes Global Yes
initialize Yes Yes
initialize-insecure Yes Yes
innodb_adaptive_flushing Yes Yes Yes Global Yes
innodb_adaptive_flushing_lwm Yes Yes Yes Global Yes
innodb_adaptive_hash_index Yes Yes Yes Global Yes
innodb_adaptive_hash_index_parts Yes Yes Yes Global No
innodb_adaptive_max_sleep_delay Yes Yes Yes Global Yes
innodb_autoextend_increment Yes Yes Yes Global Yes
innodb_autoinc_lock_mode Yes Yes Yes Global No
innodb_background_drop_list_empty Yes Yes Yes Global Yes
Innodb_buffer_pool_bytes_data Yes Global No
Innodb_buffer_pool_bytes_dirty Yes Global No
innodb_buffer_pool_chunk_size Yes Yes Yes Global No
innodb_buffer_pool_debug Yes Yes Yes Global No
innodb_buffer_pool_dump_at_shutdown Yes Yes Yes Global Yes
innodb_buffer_pool_dump_now Yes Yes Yes Global Yes
innodb_buffer_pool_dump_pct Yes Yes Yes Global Yes
Innodb_buffer_pool_dump_status Yes Global No
innodb_buffer_pool_filename Yes Yes Yes Global Yes
innodb_buffer_pool_in_core_file Yes Yes Yes Global Yes
innodb_buffer_pool_instances Yes Yes Yes Global No
innodb_buffer_pool_load_abort Yes Yes Yes Global Yes
innodb_buffer_pool_load_at_startup Yes Yes Yes Global No
innodb_buffer_pool_load_now Yes Yes Yes Global Yes
Innodb_buffer_pool_load_status Yes Global No
Innodb_buffer_pool_pages_data Yes Global No
Innodb_buffer_pool_pages_dirty Yes Global No
Innodb_buffer_pool_pages_flushed Yes Global No
Innodb_buffer_pool_pages_free Yes Global No
Innodb_buffer_pool_pages_latched Yes Global No
Innodb_buffer_pool_pages_misc Yes Global No
Innodb_buffer_pool_pages_total Yes Global No
Innodb_buffer_pool_read_ahead Yes Global No
Innodb_buffer_pool_read_ahead_evicted Yes Global No
Innodb_buffer_pool_read_ahead_rnd Yes Global No
Innodb_buffer_pool_read_requests Yes Global No
Innodb_buffer_pool_reads Yes Global No
Innodb_buffer_pool_resize_status Yes Global No
Innodb_buffer_pool_resize_status_code Yes Global No
Innodb_buffer_pool_resize_status_progress Yes Global No
innodb_buffer_pool_size Yes Yes Yes Global Yes
Innodb_buffer_pool_wait_free Yes Global No
Innodb_buffer_pool_write_requests Yes Global No
innodb_change_buffer_max_size Yes Yes Yes Global Yes
innodb_change_buffering Yes Yes Yes Global Yes
innodb_change_buffering_debug Yes Yes Yes Global Yes
innodb_checkpoint_disabled Yes Yes Yes Global Yes
innodb_checksum_algorithm Yes Yes Yes Global Yes
innodb_cmp_per_index_enabled Yes Yes Yes Global Yes
innodb_commit_concurrency Yes Yes Yes Global Yes
innodb_compress_debug Yes Yes Yes Global Yes
innodb_compression_failure_threshold_pct Yes Yes Yes Global Yes
innodb_compression_level Yes Yes Yes Global Yes
innodb_compression_pad_pct_max Yes Yes Yes Global Yes
innodb_concurrency_tickets Yes Yes Yes Global Yes
innodb_data_file_path Yes Yes Yes Global No
Innodb_data_fsyncs Yes Global No
innodb_data_home_dir Yes Yes Yes Global No
Innodb_data_pending_fsyncs Yes Global No
Innodb_data_pending_reads Yes Global No
Innodb_data_pending_writes Yes Global No
Innodb_data_read Yes Global No
Innodb_data_reads Yes Global No
Innodb_data_writes Yes Global No
Innodb_data_written Yes Global No
Innodb_dblwr_pages_written Yes Global No
Innodb_dblwr_writes Yes Global No
innodb_ddl_buffer_size Yes Yes Yes Both Yes
innodb_ddl_log_crash_reset_debug Yes Yes Yes Global Yes
innodb_ddl_threads Yes Yes Yes Both Yes
innodb_deadlock_detect Yes Yes Yes Global Yes
innodb_dedicated_server Yes Yes Yes Global No
innodb_default_row_format Yes Yes Yes Global Yes
innodb_directories Yes Yes Yes Global No
innodb_disable_sort_file_cache Yes Yes Yes Global Yes
innodb_doublewrite Yes Yes Yes Global Yes
innodb_doublewrite_batch_size Yes Yes Yes Global No
innodb_doublewrite_dir Yes Yes Yes Global No
innodb_doublewrite_files Yes Yes Yes Global No
innodb_doublewrite_pages Yes Yes Yes Global No
innodb_extend_and_initialize Yes Yes Yes Global Yes
innodb_fast_shutdown Yes Yes Yes Global Yes
innodb_fil_make_page_dirty_debug Yes Yes Yes Global Yes
innodb_file_per_table Yes Yes Yes Global Yes
innodb_fill_factor Yes Yes Yes Global Yes
innodb_flush_log_at_timeout Yes Yes Yes Global Yes
innodb_flush_log_at_trx_commit Yes Yes Yes Global Yes
innodb_flush_method Yes Yes Yes Global No
innodb_flush_neighbors Yes Yes Yes Global Yes
innodb_flush_sync Yes Yes Yes Global Yes
innodb_flushing_avg_loops Yes Yes Yes Global Yes
innodb_force_load_corrupted Yes Yes Yes Global No
innodb_force_recovery Yes Yes Yes Global No
innodb_fsync_threshold Yes Yes Yes Global Yes
innodb_ft_aux_table Yes Global Yes
innodb_ft_cache_size Yes Yes Yes Global No
innodb_ft_enable_diag_print Yes Yes Yes Global Yes
innodb_ft_enable_stopword Yes Yes Yes Both Yes
innodb_ft_max_token_size Yes Yes Yes Global No
innodb_ft_min_token_size Yes Yes Yes Global No
innodb_ft_num_word_optimize Yes Yes Yes Global Yes
innodb_ft_result_cache_limit Yes Yes Yes Global Yes
innodb_ft_server_stopword_table Yes Yes Yes Global Yes
innodb_ft_sort_pll_degree Yes Yes Yes Global No
innodb_ft_total_cache_size Yes Yes Yes Global No
innodb_ft_user_stopword_table Yes Yes Yes Both Yes
Innodb_have_atomic_builtins Yes Global No
innodb_idle_flush_pct Yes Yes Yes Global Yes
innodb_io_capacity Yes Yes Yes Global Yes
innodb_io_capacity_max Yes Yes Yes Global Yes
innodb_limit_optimistic_insert_debug Yes Yes Yes Global Yes
innodb_lock_wait_timeout Yes Yes Yes Both Yes
innodb_log_buffer_size Yes Yes Yes Global Yes
innodb_log_checkpoint_fuzzy_now Yes Yes Yes Global Yes
innodb_log_checkpoint_now Yes Yes Yes Global Yes
innodb_log_checksums Yes Yes Yes Global Yes
innodb_log_compressed_pages Yes Yes Yes Global Yes
innodb_log_file_size Yes Yes Yes Global No
innodb_log_files_in_group Yes Yes Yes Global No
innodb_log_group_home_dir Yes Yes Yes Global No
innodb_log_spin_cpu_abs_lwm Yes Yes Yes Global Yes
innodb_log_spin_cpu_pct_hwm Yes Yes Yes Global Yes
innodb_log_wait_for_flush_spin_hwm Yes Yes Yes Global Yes
Innodb_log_waits Yes Global No
innodb_log_write_ahead_size Yes Yes Yes Global Yes
Innodb_log_write_requests Yes Global No
innodb_log_writer_threads Yes Yes Yes Global Yes
Innodb_log_writes Yes Global No
innodb_lru_scan_depth Yes Yes Yes Global Yes
innodb_max_dirty_pages_pct Yes Yes Yes Global Yes
innodb_max_dirty_pages_pct_lwm Yes Yes Yes Global Yes
innodb_max_purge_lag Yes Yes Yes Global Yes
innodb_max_purge_lag_delay Yes Yes Yes Global Yes
innodb_max_undo_log_size Yes Yes Yes Global Yes
innodb_merge_threshold_set_all_debug Yes Yes Yes Global Yes
innodb_monitor_disable Yes Yes Yes Global Yes
innodb_monitor_enable Yes Yes Yes Global Yes
innodb_monitor_reset Yes Yes Yes Global Yes
innodb_monitor_reset_all Yes Yes Yes Global Yes
Innodb_num_open_files Yes Global No
innodb_numa_interleave Yes Yes Yes Global No
innodb_old_blocks_pct Yes Yes Yes Global Yes
innodb_old_blocks_time Yes Yes Yes Global Yes
innodb_online_alter_log_max_size Yes Yes Yes Global Yes
innodb_open_files Yes Yes Yes Global Yes
innodb_optimize_fulltext_only Yes Yes Yes Global Yes
Innodb_os_log_fsyncs Yes Global No
Innodb_os_log_pending_fsyncs Yes Global No
Innodb_os_log_pending_writes Yes Global No
Innodb_os_log_written Yes Global No
innodb_page_cleaners Yes Yes Yes Global No
Innodb_page_size Yes Global No
innodb_page_size Yes Yes Yes Global No
Innodb_pages_created Yes Global No
Innodb_pages_read Yes Global No
Innodb_pages_written Yes Global No
innodb_parallel_read_threads Yes Yes Yes Session Yes
innodb_print_all_deadlocks Yes Yes Yes Global Yes
innodb_print_ddl_logs Yes Yes Yes Global Yes
innodb_purge_batch_size Yes Yes Yes Global Yes
innodb_purge_rseg_truncate_frequency Yes Yes Yes Global Yes
innodb_purge_threads Yes Yes Yes Global No
innodb_random_read_ahead Yes Yes Yes Global Yes
innodb_read_ahead_threshold Yes Yes Yes Global Yes
innodb_read_io_threads Yes Yes Yes Global No
innodb_read_only Yes Yes Yes Global No
innodb_redo_log_archive_dirs Yes Yes Yes Global Yes
innodb_redo_log_capacity Yes Yes Yes Global Yes
Innodb_redo_log_capacity_resized Yes Global No
Innodb_redo_log_checkpoint_lsn Yes Global No
Innodb_redo_log_current_lsn Yes Global No
Innodb_redo_log_enabled Yes Global No
innodb_redo_log_encrypt Yes Yes Yes Global Yes
Innodb_redo_log_flushed_to_disk_lsn Yes Global No
Innodb_redo_log_logical_size Yes Global No
Innodb_redo_log_physical_size Yes Global No
Innodb_redo_log_read_only Yes Global No
Innodb_redo_log_resize_status Yes Global No
Innodb_redo_log_uuid Yes Global No
innodb_replication_delay Yes Yes Yes Global Yes
innodb_rollback_on_timeout Yes Yes Yes Global No
innodb_rollback_segments Yes Yes Yes Global Yes
Innodb_row_lock_current_waits Yes Global No
Innodb_row_lock_time Yes Global No
Innodb_row_lock_time_avg Yes Global No
Innodb_row_lock_time_max Yes Global No
Innodb_row_lock_waits Yes Global No
Innodb_rows_deleted Yes Global No
Innodb_rows_inserted Yes Global No
Innodb_rows_read Yes Global No
Innodb_rows_updated Yes Global No
innodb_saved_page_number_debug Yes Yes Yes Global Yes
innodb_segment_reserve_factor Yes Yes Yes Global Yes
innodb_sort_buffer_size Yes Yes Yes Global No
innodb_spin_wait_delay Yes Yes Yes Global Yes
innodb_spin_wait_pause_multiplier Yes Yes Yes Global Yes
innodb_stats_auto_recalc Yes Yes Yes Global Yes
innodb_stats_include_delete_marked Yes Yes Yes Global Yes
innodb_stats_method Yes Yes Yes Global Yes
innodb_stats_on_metadata Yes Yes Yes Global Yes
innodb_stats_persistent Yes Yes Yes Global Yes
innodb_stats_persistent_sample_pages Yes Yes Yes Global Yes
innodb_stats_transient_sample_pages Yes Yes Yes Global Yes
innodb-status-file Yes Yes
innodb_status_output Yes Yes Yes Global Yes
innodb_status_output_locks Yes Yes Yes Global Yes
innodb_strict_mode Yes Yes Yes Both Yes
innodb_sync_array_size Yes Yes Yes Global No
innodb_sync_debug Yes Yes Yes Global No
innodb_sync_spin_loops Yes Yes Yes Global Yes
Innodb_system_rows_deleted Yes Global No
Innodb_system_rows_inserted Yes Global No
Innodb_system_rows_read Yes Global No
Innodb_system_rows_updated Yes Global No
innodb_table_locks Yes Yes Yes Both Yes
innodb_temp_data_file_path Yes Yes Yes Global No
innodb_temp_tablespaces_dir Yes Yes Yes Global No
innodb_thread_concurrency Yes Yes Yes Global Yes
innodb_thread_sleep_delay Yes Yes Yes Global Yes
innodb_tmpdir Yes Yes Yes Both Yes
Innodb_truncated_status_writes Yes Global No
innodb_trx_purge_view_update_only_debug Yes Yes Yes Global Yes
innodb_trx_rseg_n_slots_debug Yes Yes Yes Global Yes
innodb_undo_directory Yes Yes Yes Global No
innodb_undo_log_encrypt Yes Yes Yes Global Yes
innodb_undo_log_truncate Yes Yes Yes Global Yes
innodb_undo_tablespaces Yes Yes Yes Global Yes
Innodb_undo_tablespaces_active Yes Global No
Innodb_undo_tablespaces_explicit Yes Global No
Innodb_undo_tablespaces_implicit Yes Global No
Innodb_undo_tablespaces_total Yes Global No
innodb_use_fdatasync Yes Yes Yes Global Yes
innodb_use_native_aio Yes Yes Yes Global No
innodb_validate_tablespace_paths Yes Yes Yes Global No
innodb_version Yes Global No
innodb_write_io_threads Yes Yes Yes Global No
insert_id Yes Session Yes
install Yes
install-manual Yes
interactive_timeout Yes Yes Yes Both Yes
internal_tmp_mem_storage_engine Yes Yes Yes Both Yes
join_buffer_size Yes Yes Yes Both Yes
keep_files_on_create Yes Yes Yes Both Yes
Key_blocks_not_flushed Yes Global No
Key_blocks_unused Yes Global No
Key_blocks_used Yes Global No
key_buffer_size Yes Yes Yes Global Yes
key_cache_age_threshold Yes Yes Yes Global Yes
key_cache_block_size Yes Yes Yes Global Yes
key_cache_division_limit Yes Yes Yes Global Yes
Key_read_requests Yes Global No
Key_reads Yes Global No
Key_write_requests Yes Global No
Key_writes Yes Global No
keyring_aws_cmk_id Yes Yes Yes Global Yes
keyring_aws_conf_file Yes Yes Yes Global No
keyring_aws_data_file Yes Yes Yes Global No
keyring_aws_region Yes Yes Yes Global Yes
keyring_hashicorp_auth_path Yes Yes Yes Global Yes
keyring_hashicorp_ca_path Yes Yes Yes Global Yes
keyring_hashicorp_caching Yes Yes Yes Global Yes
keyring_hashicorp_commit_auth_path Yes Global No
keyring_hashicorp_commit_ca_path Yes Global No
keyring_hashicorp_commit_caching Yes Global No
keyring_hashicorp_commit_role_id Yes Global No
keyring_hashicorp_commit_server_url Yes Global No
keyring_hashicorp_commit_store_path Yes Global No
keyring_hashicorp_role_id Yes Yes Yes Global Yes
keyring_hashicorp_secret_id Yes Yes Yes Global Yes
keyring_hashicorp_server_url Yes Yes Yes Global Yes
keyring_hashicorp_store_path Yes Yes Yes Global Yes
keyring-migration-destination Yes Yes
keyring-migration-from-component Yes Yes
keyring-migration-host Yes Yes
keyring-migration-password Yes Yes
keyring-migration-port Yes Yes
keyring-migration-socket Yes Yes
keyring-migration-source Yes Yes
keyring-migration-to-component Yes Yes
keyring-migration-user Yes Yes
keyring_okv_conf_dir Yes Yes Yes Global Yes
keyring_operations Yes Global Yes
large_files_support Yes Global No
large_page_size Yes Global No
large_pages Yes Yes Yes Global No
last_insert_id Yes Session Yes
Last_query_cost Yes Session No
Last_query_partial_plans Yes Session No
lc_messages Yes Yes Yes Both Yes
lc_messages_dir Yes Yes Yes Global No
lc_time_names Yes Yes Yes Both Yes
license Yes Global No
local_infile Yes Yes Yes Global Yes
local-service Yes
lock_order Yes Yes Yes Global No
lock_order_debug_loop Yes Yes Yes Global No
lock_order_debug_missing_arc Yes Yes Yes Global No
lock_order_debug_missing_key Yes Yes Yes Global No
lock_order_debug_missing_unlock Yes Yes Yes Global No
lock_order_dependencies Yes Yes Yes Global No
lock_order_extra_dependencies Yes Yes Yes Global No
lock_order_output_directory Yes Yes Yes Global No
lock_order_print_txt Yes Yes Yes Global No
lock_order_trace_loop Yes Yes Yes Global No
lock_order_trace_missing_arc Yes Yes Yes Global No
lock_order_trace_missing_key Yes Yes Yes Global No
lock_order_trace_missing_unlock Yes Yes Yes Global No
lock_wait_timeout Yes Yes Yes Both Yes
Locked_connects Yes Global No
locked_in_memory Yes Global No
log-bin Yes Yes
log_bin Yes Global No
log_bin_basename Yes Global No
log_bin_index Yes Yes Yes Global No
log_bin_trust_function_creators Yes Yes Yes Global Yes
log_error Yes Yes Yes Global No
log_error_services Yes Yes Yes Global Yes
log_error_suppression_list Yes Yes Yes Global Yes
log_error_verbosity Yes Yes Yes Global Yes
log-isam Yes Yes
log_output Yes Yes Yes Global Yes
log_queries_not_using_indexes Yes Yes Yes Global Yes
log_raw Yes Yes Yes Global Yes
log_replica_updates Yes Yes Yes Global No
log-short-format Yes Yes
log_slave_updates Yes Yes Yes Global No
log_slow_admin_statements Yes Yes Yes Global Yes
log_slow_extra Yes Yes Yes Global Yes
log_slow_replica_statements Yes Yes Yes Global Yes
log_slow_slave_statements Yes Yes Yes Global Yes
log_statements_unsafe_for_binlog Yes Yes Yes Global Yes
log-tc Yes Yes
log-tc-size Yes Yes
log_throttle_queries_not_using_indexes Yes Yes Yes Global Yes
log_timestamps Yes Yes Yes Global Yes
long_query_time Yes Yes Yes Both Yes
low_priority_updates Yes Yes Yes Both Yes
lower_case_file_system Yes Global No
lower_case_table_names Yes Yes Yes Global No
mandatory_roles Yes Yes Yes Global Yes
master-retry-count Yes Yes
master_verify_checksum Yes Yes Yes Global Yes
max_allowed_packet Yes Yes Yes Both Yes
max_binlog_cache_size Yes Yes Yes Global Yes
max-binlog-dump-events Yes Yes
max_binlog_size Yes Yes Yes Global Yes
max_binlog_stmt_cache_size Yes Yes Yes Global Yes
max_connect_errors Yes Yes Yes Global Yes
max_connections Yes Yes Yes Global Yes
max_delayed_threads Yes Yes Yes Both Yes
max_digest_length Yes Yes Yes Global No
max_error_count Yes Yes Yes Both Yes
max_execution_time Yes Yes Yes Both Yes
Max_execution_time_exceeded Yes Both No
Max_execution_time_set Yes Both No
Max_execution_time_set_failed Yes Both No
max_heap_table_size Yes Yes Yes Both Yes
max_insert_delayed_threads Yes Both Yes
max_join_size Yes Yes Yes Both Yes
max_length_for_sort_data Yes Yes Yes Both Yes
max_points_in_geometry Yes Yes Yes Both Yes
max_prepared_stmt_count Yes Yes Yes Global Yes
max_relay_log_size Yes Yes Yes Global Yes
max_seeks_for_key Yes Yes Yes Both Yes
max_sort_length Yes Yes Yes Both Yes
max_sp_recursion_depth Yes Yes Yes Both Yes
Max_used_connections Yes Global No
Max_used_connections_time Yes Global No
max_user_connections Yes Yes Yes Both Yes
max_write_lock_count Yes Yes Yes Global Yes
mecab_charset Yes Global No
mecab_rc_file Yes Yes Yes Global No
memlock Yes Yes
- Variable: locked_in_memory
min_examined_row_limit Yes Yes Yes Both Yes
myisam-block-size Yes Yes
myisam_data_pointer_size Yes Yes Yes Global Yes
myisam_max_sort_file_size Yes Yes Yes Global Yes
myisam_mmap_size Yes Yes Yes Global No
myisam_recover_options Yes Yes Yes Global No
myisam_sort_buffer_size Yes Yes Yes Both Yes
myisam_stats_method Yes Yes Yes Both Yes
myisam_use_mmap Yes Yes Yes Global Yes
mysql_firewall_database Yes Yes Yes Global No
mysql_firewall_mode Yes Yes Yes Global Yes
mysql_firewall_reload_interval_seconds Yes Yes Yes Global No
mysql_firewall_trace Yes Yes Yes Global Yes
mysql-native-password Yes Yes
mysql_native_password_proxy_users Yes Yes Yes Global Yes
mysqlx Yes Yes
Mysqlx_aborted_clients Yes Global No
Mysqlx_address Yes Global No
mysqlx_bind_address Yes Yes Yes Global No
Mysqlx_bytes_received Yes Both No
Mysqlx_bytes_received_compressed_payload Yes Both No
Mysqlx_bytes_received_uncompressed_frame Yes Both No
Mysqlx_bytes_sent Yes Both No
Mysqlx_bytes_sent_compressed_payload Yes Both No
Mysqlx_bytes_sent_uncompressed_frame Yes Both No
Mysqlx_compression_algorithm Yes Session No
mysqlx_compression_algorithms Yes Yes Yes Global Yes
Mysqlx_compression_level Yes Session No
mysqlx_connect_timeout Yes Yes Yes Global Yes
Mysqlx_connection_accept_errors Yes Both No
Mysqlx_connection_errors Yes Both No
Mysqlx_connections_accepted Yes Global No
Mysqlx_connections_closed Yes Global No
Mysqlx_connections_rejected Yes Global No
Mysqlx_crud_create_view Yes Both No
Mysqlx_crud_delete Yes Both No
Mysqlx_crud_drop_view Yes Both No
Mysqlx_crud_find Yes Both No
Mysqlx_crud_insert Yes Both No
Mysqlx_crud_modify_view Yes Both No
Mysqlx_crud_update Yes Both No
Mysqlx_cursor_close Yes Both No
Mysqlx_cursor_fetch Yes Both No
Mysqlx_cursor_open Yes Both No
mysqlx_deflate_default_compression_level Yes Yes Yes Global Yes
mysqlx_deflate_max_client_compression_level Yes Yes Yes Global Yes
mysqlx_document_id_unique_prefix Yes Yes Yes Global Yes
mysqlx_enable_hello_notice Yes Yes Yes Global Yes
Mysqlx_errors_sent Yes Both No
Mysqlx_errors_unknown_message_type Yes Both No
Mysqlx_expect_close Yes Both No
Mysqlx_expect_open Yes Both No
mysqlx_idle_worker_thread_timeout Yes Yes Yes Global Yes
Mysqlx_init_error Yes Both No
mysqlx_interactive_timeout Yes Yes Yes Global Yes
mysqlx_lz4_default_compression_level Yes Yes Yes Global Yes
mysqlx_lz4_max_client_compression_level Yes Yes Yes Global Yes
mysqlx_max_allowed_packet Yes Yes Yes Global Yes
mysqlx_max_connections Yes Yes Yes Global Yes
Mysqlx_messages_sent Yes Both No
mysqlx_min_worker_threads Yes Yes Yes Global Yes
Mysqlx_notice_global_sent Yes Both No
Mysqlx_notice_other_sent Yes Both No
Mysqlx_notice_warning_sent Yes Both No
Mysqlx_notified_by_group_replication Yes Both No
Mysqlx_port Yes Global No
mysqlx_port Yes Yes Yes Global No
mysqlx_port_open_timeout Yes Yes Yes Global No
Mysqlx_prep_deallocate Yes Both No
Mysqlx_prep_execute Yes Both No
Mysqlx_prep_prepare Yes Both No
mysqlx_read_timeout Yes Yes Yes Session Yes
Mysqlx_rows_sent Yes Both No
Mysqlx_sessions Yes Global No
Mysqlx_sessions_accepted Yes Global No
Mysqlx_sessions_closed Yes Global No
Mysqlx_sessions_fatal_error Yes Global No
Mysqlx_sessions_killed Yes Global No
Mysqlx_sessions_rejected Yes Global No
Mysqlx_socket Yes Global No
mysqlx_socket Yes Yes Yes Global No
Mysqlx_ssl_accept_renegotiates Yes Global No
Mysqlx_ssl_accepts Yes Global No
Mysqlx_ssl_active Yes Both No
mysqlx_ssl_ca Yes Yes Yes Global No
mysqlx_ssl_capath Yes Yes Yes Global No
mysqlx_ssl_cert Yes Yes Yes Global No
Mysqlx_ssl_cipher Yes Both No
mysqlx_ssl_cipher Yes Yes Yes Global No
Mysqlx_ssl_cipher_list Yes Both No
mysqlx_ssl_crl Yes Yes Yes Global No
mysqlx_ssl_crlpath Yes Yes Yes Global No
Mysqlx_ssl_ctx_verify_depth Yes Both No
Mysqlx_ssl_ctx_verify_mode Yes Both No
Mysqlx_ssl_finished_accepts Yes Global No
mysqlx_ssl_key Yes Yes Yes Global No
Mysqlx_ssl_server_not_after Yes Global No
Mysqlx_ssl_server_not_before Yes Global No
Mysqlx_ssl_verify_depth Yes Global No
Mysqlx_ssl_verify_mode Yes Global No
Mysqlx_ssl_version Yes Both No
Mysqlx_stmt_create_collection Yes Both No
Mysqlx_stmt_create_collection_index Yes Both No
Mysqlx_stmt_disable_notices Yes Both No
Mysqlx_stmt_drop_collection Yes Both No
Mysqlx_stmt_drop_collection_index Yes Both No
Mysqlx_stmt_enable_notices Yes Both No
Mysqlx_stmt_ensure_collection Yes Both No
Mysqlx_stmt_execute_mysqlx Yes Both No
Mysqlx_stmt_execute_sql Yes Both No
Mysqlx_stmt_execute_xplugin Yes Both No
Mysqlx_stmt_get_collection_options Yes Both No
Mysqlx_stmt_kill_client Yes Both No
Mysqlx_stmt_list_clients Yes Both No
Mysqlx_stmt_list_notices Yes Both No
Mysqlx_stmt_list_objects Yes Both No
Mysqlx_stmt_modify_collection_options Yes Both No
Mysqlx_stmt_ping Yes Both No
mysqlx_wait_timeout Yes Yes Yes Session Yes
Mysqlx_worker_threads Yes Global No
Mysqlx_worker_threads_active Yes Global No
mysqlx_write_timeout Yes Yes Yes Session Yes
mysqlx_zstd_default_compression_level Yes Yes Yes Global Yes
mysqlx_zstd_max_client_compression_level Yes Yes Yes Global Yes
named_pipe Yes Yes Yes Global No
named_pipe_full_access_group Yes Yes Yes Global No
ndb_allow_copying_alter_table Yes Yes Yes Both Yes
Ndb_api_adaptive_send_deferred_count Yes Global No
Ndb_api_adaptive_send_deferred_count_replica Yes Global No
Ndb_api_adaptive_send_deferred_count_session Yes Global No
Ndb_api_adaptive_send_deferred_count_slave Yes Global No
Ndb_api_adaptive_send_forced_count Yes Global No
Ndb_api_adaptive_send_forced_count_replica Yes Global No
Ndb_api_adaptive_send_forced_count_session Yes Global No
Ndb_api_adaptive_send_forced_count_slave Yes Global No
Ndb_api_adaptive_send_unforced_count Yes Global No
Ndb_api_adaptive_send_unforced_count_replica Yes Global No
Ndb_api_adaptive_send_unforced_count_session Yes Global No
Ndb_api_adaptive_send_unforced_count_slave Yes Global No
Ndb_api_bytes_received_count Yes Global No
Ndb_api_bytes_received_count_replica Yes Global No
Ndb_api_bytes_received_count_session Yes Session No
Ndb_api_bytes_received_count_slave Yes Global No
Ndb_api_bytes_sent_count Yes Global No
Ndb_api_bytes_sent_count_replica Yes Global No
Ndb_api_bytes_sent_count_session Yes Session No
Ndb_api_bytes_sent_count_slave Yes Global No
Ndb_api_event_bytes_count Yes Global No
Ndb_api_event_bytes_count_injector Yes Global No
Ndb_api_event_data_count Yes Global No
Ndb_api_event_data_count_injector Yes Global No
Ndb_api_event_nondata_count Yes Global No
Ndb_api_event_nondata_count_injector Yes Global No
Ndb_api_pk_op_count Yes Global No
Ndb_api_pk_op_count_replica Yes Global No
Ndb_api_pk_op_count_session Yes Session No
Ndb_api_pk_op_count_slave Yes Global No
Ndb_api_pruned_scan_count Yes Global No
Ndb_api_pruned_scan_count_replica Yes Global No
Ndb_api_pruned_scan_count_session Yes Session No
Ndb_api_pruned_scan_count_slave Yes Global No
Ndb_api_range_scan_count Yes Global No
Ndb_api_range_scan_count_replica Yes Global No
Ndb_api_range_scan_count_session Yes Session No
Ndb_api_range_scan_count_slave Yes Global No
Ndb_api_read_row_count Yes Global No
Ndb_api_read_row_count_replica Yes Global No
Ndb_api_read_row_count_session Yes Session No
Ndb_api_read_row_count_slave Yes Global No
Ndb_api_scan_batch_count Yes Global No
Ndb_api_scan_batch_count_replica Yes Global No
Ndb_api_scan_batch_count_session Yes Session No
Ndb_api_scan_batch_count_slave Yes Global No
Ndb_api_table_scan_count Yes Global No
Ndb_api_table_scan_count_replica Yes Global No
Ndb_api_table_scan_count_session Yes Session No
Ndb_api_table_scan_count_slave Yes Global No
Ndb_api_trans_abort_count Yes Global No
Ndb_api_trans_abort_count_replica Yes Global No
Ndb_api_trans_abort_count_session Yes Session No
Ndb_api_trans_abort_count_slave Yes Global No
Ndb_api_trans_close_count Yes Global No
Ndb_api_trans_close_count_replica Yes Global No
Ndb_api_trans_close_count_session Yes Session No
Ndb_api_trans_close_count_slave Yes Global No
Ndb_api_trans_commit_count Yes Global No
Ndb_api_trans_commit_count_replica Yes Global No
Ndb_api_trans_commit_count_session Yes Session No
Ndb_api_trans_commit_count_slave Yes Global No
Ndb_api_trans_local_read_row_count Yes Global No
Ndb_api_trans_local_read_row_count_replica Yes Global No
Ndb_api_trans_local_read_row_count_session Yes Session No
Ndb_api_trans_local_read_row_count_slave Yes Global No
Ndb_api_trans_start_count Yes Global No
Ndb_api_trans_start_count_replica Yes Global No
Ndb_api_trans_start_count_session Yes Session No
Ndb_api_trans_start_count_slave Yes Global No
Ndb_api_uk_op_count Yes Global No
Ndb_api_uk_op_count_replica Yes Global No
Ndb_api_uk_op_count_session Yes Session No
Ndb_api_uk_op_count_slave Yes Global No
Ndb_api_wait_exec_complete_count Yes Global No
Ndb_api_wait_exec_complete_count_replica Yes Global No
Ndb_api_wait_exec_complete_count_session Yes Session No
Ndb_api_wait_exec_complete_count_slave Yes Global No
Ndb_api_wait_meta_request_count Yes Global No
Ndb_api_wait_meta_request_count_replica Yes Global No
Ndb_api_wait_meta_request_count_session Yes Session No
Ndb_api_wait_meta_request_count_slave Yes Global No
Ndb_api_wait_nanos_count Yes Global No
Ndb_api_wait_nanos_count_replica Yes Global No
Ndb_api_wait_nanos_count_session Yes Session No
Ndb_api_wait_nanos_count_slave Yes Global No
Ndb_api_wait_scan_result_count Yes Global No
Ndb_api_wait_scan_result_count_replica Yes Global No
Ndb_api_wait_scan_result_count_session Yes Session No
Ndb_api_wait_scan_result_count_slave Yes Global No
ndb_applier_allow_skip_epoch Yes Yes Yes Global No
ndb_autoincrement_prefetch_sz Yes Yes Yes Both Yes
ndb_batch_size Yes Yes Yes Both Yes
ndb_blob_read_batch_bytes Yes Yes Yes Both Yes
ndb_blob_write_batch_bytes Yes Yes Yes Both Yes
ndb_clear_apply_status Yes Yes Global Yes
ndb_cluster_connection_pool Yes Yes Yes Global No
ndb_cluster_connection_pool_nodeids Yes Yes Yes Global No
Ndb_cluster_node_id Yes Global No
Ndb_config_from_host Yes Both No
Ndb_config_from_port Yes Both No
Ndb_config_generation Yes Global No
Ndb_conflict_fn_epoch Yes Global No
Ndb_conflict_fn_epoch_trans Yes Global No
Ndb_conflict_fn_epoch2 Yes Global No
Ndb_conflict_fn_epoch2_trans Yes Global No
Ndb_conflict_fn_max Yes Global No
Ndb_conflict_fn_max_del_win Yes Global No
Ndb_conflict_fn_max_del_win_ins Yes Global No
Ndb_conflict_fn_max_ins Yes Global No
Ndb_conflict_fn_old Yes Global No
Ndb_conflict_last_conflict_epoch Yes Global No
Ndb_conflict_last_stable_epoch Yes Global No
Ndb_conflict_reflected_op_discard_count Yes Global No
Ndb_conflict_reflected_op_prepare_count Yes Global No
Ndb_conflict_refresh_op_count Yes Global No
ndb_conflict_role Yes Yes Yes Global Yes
Ndb_conflict_trans_conflict_commit_count Yes Global No
Ndb_conflict_trans_detect_iter_count Yes Global No
Ndb_conflict_trans_reject_count Yes Global No
Ndb_conflict_trans_row_conflict_count Yes Global No
Ndb_conflict_trans_row_reject_count Yes Global No
ndb-connectstring Yes Yes
ndb_data_node_neighbour Yes Yes Yes Global Yes
ndb_dbg_check_shares Yes Yes Yes Both Yes
ndb_default_column_format Yes Yes Yes Global Yes
ndb_default_column_format Yes Yes Yes Global Yes
ndb_deferred_constraints Yes Yes Yes Both Yes
ndb_deferred_constraints Yes Yes Yes Both Yes
ndb_distribution Yes Yes Yes Global Yes
ndb_distribution Yes Yes Yes Global Yes
Ndb_epoch_delete_delete_count Yes Global No
ndb_eventbuffer_free_percent Yes Yes Yes Global Yes
ndb_eventbuffer_max_alloc Yes Yes Yes Global Yes
Ndb_execute_count Yes Global No
ndb_extra_logging Yes Yes Yes Global Yes
ndb_force_send Yes Yes Yes Both Yes
ndb_fully_replicated Yes Yes Yes Both Yes
ndb_index_stat_enable Yes Yes Yes Both Yes
ndb_index_stat_option Yes Yes Yes Both Yes
ndb_join_pushdown Yes Both Yes
Ndb_last_commit_epoch_server Yes Global No
Ndb_last_commit_epoch_session Yes Session No
ndb_log_apply_status Yes Yes Yes Global No
ndb_log_apply_status Yes Yes Yes Global No
ndb_log_bin Yes Yes Both No
ndb_log_binlog_index Yes Yes Global Yes
ndb_log_empty_epochs Yes Yes Yes Global Yes
ndb_log_empty_epochs Yes Yes Yes Global Yes
ndb_log_empty_update Yes Yes Yes Global Yes
ndb_log_empty_update Yes Yes Yes Global Yes
ndb_log_exclusive_reads Yes Yes Yes Both Yes
ndb_log_exclusive_reads Yes Yes Yes Both Yes
ndb_log_fail_terminate Yes Yes Yes Global No
ndb_log_orig Yes Yes Yes Global No
ndb_log_orig Yes Yes Yes Global No
ndb_log_transaction_compression Yes Yes Yes Global Yes
ndb_log_transaction_compression_level_zstd Yes Yes Yes Global Yes
ndb_log_transaction_dependency Yes Yes Yes Global No
ndb_log_transaction_id Yes Yes Yes Global No
ndb_log_transaction_id Yes Global No
ndb_log_update_as_write Yes Yes Yes Global Yes
ndb_log_update_minimal Yes Yes Yes Global Yes
ndb_log_updated_only Yes Yes Yes Global Yes
ndb_metadata_check Yes Yes Yes Global Yes
ndb_metadata_check_interval Yes Yes Yes Global Yes
Ndb_metadata_detected_count Yes Global No
Ndb_metadata_excluded_count Yes Global No
ndb_metadata_sync Yes Global Yes
Ndb_metadata_synced_count Yes Global No
ndb_mgm_tls Yes Yes Global No
- Variable: yes Yes Global No
ndb-mgmd-host Yes Yes
ndb_nodeid Yes Yes Yes Global No
Ndb_number_of_data_nodes Yes Global No
ndb_optimization_delay Yes Yes Yes Global Yes
ndb-optimized-node-selection Yes
ndb_optimized_node_selection Yes Yes Yes Global No
Ndb_pruned_scan_count Yes Global No
Ndb_pushed_queries_defined Yes Global No
Ndb_pushed_queries_dropped Yes Global No
Ndb_pushed_queries_executed Yes Global No
Ndb_pushed_reads Yes Global No
ndb_read_backup Yes Yes Yes Global Yes
ndb_recv_thread_activation_threshold Yes Yes Yes Global Yes
ndb_recv_thread_cpu_mask Yes Yes Yes Global Yes
ndb_replica_batch_size Yes Yes Yes Global Yes
ndb_replica_blob_write_batch_bytes Yes Yes Yes Global Yes
Ndb_replica_max_replicated_epoch Yes Global No
ndb_report_thresh_binlog_epoch_slip Yes Yes Yes Global Yes
ndb_report_thresh_binlog_mem_usage Yes Yes Yes Global Yes
ndb_row_checksum Yes Both Yes
Ndb_scan_count Yes Global No
ndb_schema_dist_lock_wait_timeout Yes Yes Yes Global Yes
ndb_schema_dist_timeout Yes Yes Yes Global No
ndb_schema_dist_timeout Yes Yes Yes Global No
ndb_schema_dist_upgrade_allowed Yes Yes Yes Global No
ndb_show_foreign_key_mock_tables Yes Yes Yes Global Yes
ndb_slave_conflict_role Yes Yes Yes Global Yes
Ndb_slave_max_replicated_epoch Yes Global No
Ndb_system_name Yes Global No
ndb_table_no_logging Yes Session Yes
ndb_table_temporary Yes Session Yes
ndb_tls_search_path Yes Yes Global No
- Variable: yes Yes Global No
Ndb_trans_hint_count_session Yes Both No
ndb-transid-mysql-connection-map Yes
ndb_use_copying_alter_table Yes Both No
ndb_use_exact_count Yes Both Yes
ndb_use_transactions Yes Yes Yes Both Yes
ndb_version Yes Global No
ndb_version_string Yes Global No
ndb_wait_connected Yes Yes Yes Global No
ndb_wait_setup Yes Yes Yes Global No
ndbcluster Yes Yes
ndbinfo Yes
ndbinfo_database Yes Global No
ndbinfo_max_bytes Yes Yes Both Yes
ndbinfo_max_rows Yes Yes Both Yes
ndbinfo_offline Yes Global Yes
ndbinfo_show_hidden Yes Yes Both Yes
ndbinfo_table_prefix Yes Global No
ndbinfo_version Yes Global No
net_buffer_length Yes Yes Yes Both Yes
net_read_timeout Yes Yes Yes Both Yes
net_retry_count Yes Yes Yes Both Yes
net_write_timeout Yes Yes Yes Both Yes
ngram_token_size Yes Yes Yes Global No
no-defaults Yes
no-monitor Yes Yes
Not_flushed_delayed_rows Yes Global No
offline_mode Yes Yes Yes Global Yes
old_alter_table Yes Yes Yes Both Yes
Ongoing_anonymous_gtid_violating_transaction_count Yes Global No
Ongoing_anonymous_transaction_count Yes Global No
Ongoing_automatic_gtid_violating_transaction_count Yes Global No
Open_files Yes Global No
open_files_limit Yes Yes Yes Global No
Open_streams Yes Global No
Open_table_definitions Yes Global No
Open_tables Yes Both No
Opened_files Yes Global No
Opened_table_definitions Yes Both No
Opened_tables Yes Both No
optimizer_prune_level Yes Yes Yes Both Yes
optimizer_search_depth Yes Yes Yes Both Yes
optimizer_switch Yes Yes Yes Both Yes
optimizer_trace Yes Yes Yes Both Yes
optimizer_trace_features Yes Yes Yes Both Yes
optimizer_trace_limit Yes Yes Yes Both Yes
optimizer_trace_max_mem_size Yes Yes Yes Both Yes
optimizer_trace_offset Yes Yes Yes Both Yes
original_commit_timestamp Yes Session Yes
original_server_version Yes Session Yes
parser_max_mem_size Yes Yes Yes Both Yes
partial_revokes Yes Yes Yes Global Yes
password_history Yes Yes Yes Global Yes
password_require_current Yes Yes Yes Global Yes
password_reuse_interval Yes Yes Yes Global Yes
performance_schema Yes Yes Yes Global No
Performance_schema_accounts_lost Yes Global No
performance_schema_accounts_size Yes Yes Yes Global No
Performance_schema_cond_classes_lost Yes Global No
Performance_schema_cond_instances_lost Yes Global No
performance-schema-consumer-events-stages-current Yes Yes
performance-schema-consumer-events-stages-history Yes Yes
performance-schema-consumer-events-stages-history-long Yes Yes
performance-schema-consumer-events-statements-cpu Yes Yes
performance-schema-consumer-events-statements-current Yes Yes
performance-schema-consumer-events-statements-history Yes Yes
performance-schema-consumer-events-statements-history-long Yes Yes
performance-schema-consumer-events-transactions-current Yes Yes
performance-schema-consumer-events-transactions-history Yes Yes
performance-schema-consumer-events-transactions-history-long Yes Yes
performance-schema-consumer-events-waits-current Yes Yes
performance-schema-consumer-events-waits-history Yes Yes
performance-schema-consumer-events-waits-history-long Yes Yes
performance-schema-consumer-global-instrumentation Yes Yes
performance-schema-consumer-statements-digest Yes Yes
performance-schema-consumer-thread-instrumentation Yes Yes
Performance_schema_digest_lost Yes Global No
performance_schema_digests_size Yes Yes Yes Global No
performance_schema_error_size Yes Yes Yes Global No
performance_schema_events_stages_history_long_size Yes Yes Yes Global No
performance_schema_events_stages_history_size Yes Yes Yes Global No
performance_schema_events_statements_history_long_size Yes Yes Yes Global No
performance_schema_events_statements_history_size Yes Yes Yes Global No
performance_schema_events_transactions_history_long_size Yes Yes Yes Global No
performance_schema_events_transactions_history_size Yes Yes Yes Global No
performance_schema_events_waits_history_long_size Yes Yes Yes Global No
performance_schema_events_waits_history_size Yes Yes Yes Global No
Performance_schema_file_classes_lost Yes Global No
Performance_schema_file_handles_lost Yes Global No
Performance_schema_file_instances_lost Yes Global No
Performance_schema_hosts_lost Yes Global No
performance_schema_hosts_size Yes Yes Yes Global No
Performance_schema_index_stat_lost Yes Global No
performance-schema-instrument Yes Yes
Performance_schema_locker_lost Yes Global No
performance_schema_max_cond_classes Yes Yes Yes Global No
performance_schema_max_cond_instances Yes Yes Yes Global No
performance_schema_max_digest_length Yes Yes Yes Global No
performance_schema_max_digest_sample_age Yes Yes Yes Global Yes
performance_schema_max_file_classes Yes Yes Yes Global No
performance_schema_max_file_handles Yes Yes Yes Global No
performance_schema_max_file_instances Yes Yes Yes Global No
performance_schema_max_index_stat Yes Yes Yes Global No
performance_schema_max_memory_classes Yes Yes Yes Global No
performance_schema_max_metadata_locks Yes Yes Yes Global No
performance_schema_max_meter_classes Yes Yes Yes Global No
performance_schema_max_metric_classes Yes Yes Yes Global No
performance_schema_max_mutex_classes Yes Yes Yes Global No
performance_schema_max_mutex_instances Yes Yes Yes Global No
performance_schema_max_prepared_statements_instances Yes Yes Yes Global No
performance_schema_max_program_instances Yes Yes Yes Global No
performance_schema_max_rwlock_classes Yes Yes Yes Global No
performance_schema_max_rwlock_instances Yes Yes Yes Global No
performance_schema_max_socket_classes Yes Yes Yes Global No
performance_schema_max_socket_instances Yes Yes Yes Global No
performance_schema_max_sql_text_length Yes Yes Yes Global No
performance_schema_max_stage_classes Yes Yes Yes Global No
performance_schema_max_statement_classes Yes Yes Yes Global No
performance_schema_max_statement_stack Yes Yes Yes Global No
performance_schema_max_table_handles Yes Yes Yes Global No
performance_schema_max_table_instances Yes Yes Yes Global No
performance_schema_max_table_lock_stat Yes Yes Yes Global No
performance_schema_max_thread_classes Yes Yes Yes Global No
performance_schema_max_thread_instances Yes Yes Yes Global No
Performance_schema_memory_classes_lost Yes Global No
Performance_schema_metadata_lock_lost Yes Global No
Performance_schema_meter_lost Yes Global No
Performance_schema_metric_lost Yes Global No
Performance_schema_mutex_classes_lost Yes Global No
Performance_schema_mutex_instances_lost Yes Global No
Performance_schema_nested_statement_lost Yes Global No
Performance_schema_prepared_statements_lost Yes Global No
Performance_schema_program_lost Yes Global No
Performance_schema_rwlock_classes_lost Yes Global No
Performance_schema_rwlock_instances_lost Yes Global No
Performance_schema_session_connect_attrs_longest_seen Yes Global No
Performance_schema_session_connect_attrs_lost Yes Global No
performance_schema_session_connect_attrs_size Yes Yes Yes Global No
performance_schema_setup_actors_size Yes Yes Yes Global No
performance_schema_setup_objects_size Yes Yes Yes Global No
performance_schema_show_processlist Yes Yes Yes Global Yes
Performance_schema_socket_classes_lost Yes Global No
Performance_schema_socket_instances_lost Yes Global No
Performance_schema_stage_classes_lost Yes Global No
Performance_schema_statement_classes_lost Yes Global No
Performance_schema_table_handles_lost Yes Global No
Performance_schema_table_instances_lost Yes Global No
Performance_schema_table_lock_stat_lost Yes Global No
Performance_schema_thread_classes_lost Yes Global No
Performance_schema_thread_instances_lost Yes Global No
Performance_schema_users_lost Yes Global No
performance_schema_users_size Yes Yes Yes Global No
persist_only_admin_x509_subject Yes Yes Yes Global No
persist_sensitive_variables_in_plaintext Yes Yes Yes Global No
persisted_globals_load Yes Yes Yes Global No
pid_file Yes Yes Yes Global No
plugin_dir Yes Yes Yes Global No
plugin-load Yes Yes
plugin-load-add Yes Yes
plugin-xxx Yes Yes
port Yes Yes Yes Global No
port-open-timeout Yes Yes
preload_buffer_size Yes Yes Yes Both Yes
Prepared_stmt_count Yes Global No
print-defaults Yes
print_identified_with_as_hex Yes Yes Yes Both Yes
profiling Yes Both Yes
profiling_history_size Yes Yes Yes Both Yes
protocol_compression_algorithms Yes Yes Yes Global Yes
protocol_version Yes Global No
proxy_user Yes Session No
pseudo_replica_mode Yes Session Yes
pseudo_slave_mode Yes Session Yes
pseudo_thread_id Yes Session Yes
Queries Yes Both No
query_alloc_block_size Yes Yes Yes Both Yes
query_prealloc_size Yes Yes Yes Both Yes
Questions Yes Both No
rand_seed1 Yes Session Yes
rand_seed2 Yes Session Yes
range_alloc_block_size Yes Yes Yes Both Yes
range_optimizer_max_mem_size Yes Yes Yes Both Yes
rbr_exec_mode Yes Session Yes
read_buffer_size Yes Yes Yes Both Yes
read_only Yes Yes Yes Global Yes
read_rnd_buffer_size Yes Yes Yes Both Yes
regexp_stack_limit Yes Yes Yes Global Yes
regexp_time_limit Yes Yes Yes Global Yes
relay_log Yes Yes Yes Global No
relay_log_basename Yes Global No
relay_log_index Yes Yes Yes Global No
relay_log_purge Yes Yes Yes Global Yes
relay_log_recovery Yes Yes Yes Global No
relay_log_space_limit Yes Yes Yes Global No
remove Yes
replica_allow_batching Yes Yes Yes Global Yes
replica_checkpoint_group Yes Yes Yes Global Yes
replica_checkpoint_period Yes Yes Yes Global Yes
replica_compressed_protocol Yes Yes Yes Global Yes
replica_exec_mode Yes Yes Yes Global Yes
replica_load_tmpdir Yes Yes Yes Global No
replica_max_allowed_packet Yes Yes Yes Global Yes
replica_net_timeout Yes Yes Yes Global Yes
Replica_open_temp_tables Yes Global No
replica_parallel_type Yes Yes Yes Global Yes
replica_parallel_workers Yes Yes Yes Global Yes
replica_pending_jobs_size_max Yes Yes Yes Global Yes
replica_preserve_commit_order Yes Yes Yes Global Yes
replica_skip_errors Yes Yes Yes Global No
replica_sql_verify_checksum Yes Yes Yes Global Yes
replica_transaction_retries Yes Yes Yes Global Yes
replica_type_conversions Yes Yes Yes Global Yes
replicate-do-db Yes Yes
replicate-do-table Yes Yes
replicate-ignore-db Yes Yes
replicate-ignore-table Yes Yes
replicate-rewrite-db Yes Yes
replicate-same-server-id Yes Yes
replicate-wild-do-table Yes Yes
replicate-wild-ignore-table Yes Yes
replication_optimize_for_static_plugin_config Yes Yes Yes Global Yes
replication_sender_observe_commit_only Yes Yes Yes Global Yes
report_host Yes Yes Yes Global No
report_password Yes Yes Yes Global No
report_port Yes Yes Yes Global No
report_user Yes Yes Yes Global No
require_row_format Yes Session Yes
require_secure_transport Yes Yes Yes Global Yes
Resource_group_supported Yes Global No
resultset_metadata Yes Session Yes
rewriter_enabled Yes Global Yes
rewriter_enabled_for_threads_without_privilege_checks Yes Global Yes
Rewriter_number_loaded_rules Yes Global No
Rewriter_number_reloads Yes Global No
Rewriter_number_rewritten_queries Yes Global No
Rewriter_reload_error Yes Global No
rewriter_verbose Yes Global Yes
rpl_read_size Yes Yes Yes Global Yes
Rpl_semi_sync_master_clients Yes Global No
rpl_semi_sync_master_enabled Yes Yes Yes Global Yes
Rpl_semi_sync_master_net_avg_wait_time Yes Global No
Rpl_semi_sync_master_net_wait_time Yes Global No
Rpl_semi_sync_master_net_waits Yes Global No
Rpl_semi_sync_master_no_times Yes Global No
Rpl_semi_sync_master_no_tx Yes Global No
Rpl_semi_sync_master_status Yes Global No
Rpl_semi_sync_master_timefunc_failures Yes Global No
rpl_semi_sync_master_timeout Yes Yes Yes Global Yes
rpl_semi_sync_master_trace_level Yes Yes Yes Global Yes
Rpl_semi_sync_master_tx_avg_wait_time Yes Global No
Rpl_semi_sync_master_tx_wait_time Yes Global No
Rpl_semi_sync_master_tx_waits Yes Global No
rpl_semi_sync_master_wait_for_slave_count Yes Yes Yes Global Yes
rpl_semi_sync_master_wait_no_slave Yes Yes Yes Global Yes
rpl_semi_sync_master_wait_point Yes Yes Yes Global Yes
Rpl_semi_sync_master_wait_pos_backtraverse Yes Global No
Rpl_semi_sync_master_wait_sessions Yes Global No
Rpl_semi_sync_master_yes_tx Yes Global No
rpl_semi_sync_replica_enabled Yes Yes Yes Global Yes
Rpl_semi_sync_replica_status Yes Global No
rpl_semi_sync_replica_trace_level Yes Yes Yes Global Yes
rpl_semi_sync_slave_enabled Yes Yes Yes Global Yes
Rpl_semi_sync_slave_status Yes Global No
rpl_semi_sync_slave_trace_level Yes Yes Yes Global Yes
Rpl_semi_sync_source_clients Yes Global No
rpl_semi_sync_source_enabled Yes Yes Yes Global Yes
Rpl_semi_sync_source_net_avg_wait_time Yes Global No
Rpl_semi_sync_source_net_wait_time Yes Global No
Rpl_semi_sync_source_net_waits Yes Global No
Rpl_semi_sync_source_no_times Yes Global No
Rpl_semi_sync_source_no_tx Yes Global No
Rpl_semi_sync_source_status Yes Global No
Rpl_semi_sync_source_timefunc_failures Yes Global No
rpl_semi_sync_source_timeout Yes Yes Yes Global Yes
rpl_semi_sync_source_trace_level Yes Yes Yes Global Yes
Rpl_semi_sync_source_tx_avg_wait_time Yes Global No
Rpl_semi_sync_source_tx_wait_time Yes Global No
Rpl_semi_sync_source_tx_waits Yes Global No
rpl_semi_sync_source_wait_for_replica_count Yes Yes Yes Global Yes
rpl_semi_sync_source_wait_no_replica Yes Yes Yes Global Yes
rpl_semi_sync_source_wait_point Yes Yes Yes Global Yes
Rpl_semi_sync_source_wait_pos_backtraverse Yes Global No
Rpl_semi_sync_source_wait_sessions Yes Global No
Rpl_semi_sync_source_yes_tx Yes Global No
rpl_stop_replica_timeout Yes Yes Yes Global Yes
rpl_stop_slave_timeout Yes Yes Yes Global Yes
Rsa_public_key Yes Global No
safe-user-create Yes Yes
schema_definition_cache Yes Yes Yes Global Yes
secondary_engine_cost_threshold Yes Session Yes
Secondary_engine_execution_count Yes Both No
secure_file_priv Yes Yes Yes Global No
Select_full_join Yes Both No
Select_full_range_join Yes Both No
select_into_buffer_size Yes Yes Yes Both Yes
select_into_disk_sync Yes Yes Yes Both Yes
select_into_disk_sync_delay Yes Yes Yes Both Yes
Select_range Yes Both No
Select_range_check Yes Both No
Select_scan Yes Both No
server_id Yes Yes Yes Global Yes
server_id_bits Yes Yes Yes Global No
server_uuid Yes Global No
session_track_gtids Yes Yes Yes Both Yes
session_track_schema Yes Yes Yes Both Yes
session_track_state_change Yes Yes Yes Both Yes
session_track_system_variables Yes Yes Yes Both Yes
session_track_transaction_info Yes Yes Yes Both Yes
set_operations_buffer_size Yes Yes Yes Both Yes
sha256_password_auto_generate_rsa_keys Yes Yes Yes Global No
sha256_password_private_key_path Yes Yes Yes Global No
sha256_password_proxy_users Yes Yes Yes Global Yes
sha256_password_public_key_path Yes Yes Yes Global No
shared_memory Yes Yes Yes Global No
shared_memory_base_name Yes Yes Yes Global No
show_create_table_skip_secondary_engine Yes Yes Yes Session Yes
show_create_table_verbosity Yes Yes Yes Both Yes
show_gipk_in_create_table_and_information_schema Yes Yes Yes Both Yes
show-replica-auth-info Yes Yes
show-slave-auth-info Yes Yes
skip_external_locking Yes Yes Yes Global No
skip-grant-tables Yes Yes
skip_name_resolve Yes Yes Yes Global No
skip-ndbcluster Yes Yes
skip_networking Yes Yes Yes Global No
skip-new Yes Yes
skip_replica_start Yes Yes Yes Global No
skip_show_database Yes Yes Yes Global No
skip_slave_start Yes Yes Yes Global No
skip-ssl Yes Yes
skip-stack-trace Yes Yes
slave_allow_batching Yes Yes Yes Global Yes
slave_checkpoint_group Yes Yes Yes Global Yes
slave_checkpoint_period Yes Yes Yes Global Yes
slave_compressed_protocol Yes Yes Yes Global Yes
slave_exec_mode Yes Yes Yes Global Yes
slave_load_tmpdir Yes Yes Yes Global No
slave_max_allowed_packet Yes Yes Yes Global Yes
slave_net_timeout Yes Yes Yes Global Yes
Slave_open_temp_tables Yes Global No
slave_parallel_type Yes Yes Yes Global Yes
slave_parallel_workers Yes Yes Yes Global Yes
slave_pending_jobs_size_max Yes Yes Yes Global Yes
slave_preserve_commit_order Yes Yes Yes Global Yes
Slave_rows_last_search_algorithm_used Yes Global No
slave_skip_errors Yes Yes Yes Global No
slave-sql-verify-checksum Yes Yes
slave_sql_verify_checksum Yes Yes Yes Global Yes
slave_transaction_retries Yes Yes Yes Global Yes
slave_type_conversions Yes Yes Yes Global Yes
Slow_launch_threads Yes Both No
slow_launch_time Yes Yes Yes Global Yes
Slow_queries Yes Both No
slow_query_log Yes Yes Yes Global Yes
slow_query_log_file Yes Yes Yes Global Yes
slow-start-timeout Yes Yes
socket Yes Yes Yes Global No
sort_buffer_size Yes Yes Yes Both Yes
Sort_merge_passes Yes Both No
Sort_range Yes Both No
Sort_rows Yes Both No
Sort_scan Yes Both No
source_verify_checksum Yes Yes Yes Global Yes
sporadic-binlog-dump-fail Yes Yes
sql_auto_is_null Yes Both Yes
sql_big_selects Yes Both Yes
sql_buffer_result Yes Both Yes
sql_generate_invisible_primary_key Yes Yes Yes Both Yes
sql_log_bin Yes Session Yes
sql_log_off Yes Both Yes
sql_mode Yes Yes Yes Both Yes
sql_notes Yes Both Yes
sql_quote_show_create Yes Both Yes
sql_replica_skip_counter Yes Global Yes
sql_require_primary_key Yes Yes Yes Both Yes
sql_safe_updates Yes Both Yes
sql_select_limit Yes Both Yes
sql_slave_skip_counter Yes Global Yes
sql_warnings Yes Both Yes
Ssl_accept_renegotiates Yes Global No
Ssl_accepts Yes Global No
ssl_ca Yes Yes Yes Global Yes
Ssl_callback_cache_hits Yes Global No
ssl_capath Yes Yes Yes Global Yes
ssl_cert Yes Yes Yes Global Yes
Ssl_cipher Yes Both No
ssl_cipher Yes Yes Yes Global Yes
Ssl_cipher_list Yes Both No
Ssl_client_connects Yes Global No
Ssl_connect_renegotiates Yes Global No
ssl_crl Yes Yes Yes Global Yes
ssl_crlpath Yes Yes Yes Global Yes
Ssl_ctx_verify_depth Yes Global No
Ssl_ctx_verify_mode Yes Global No
Ssl_default_timeout Yes Both No
Ssl_finished_accepts Yes Global No
Ssl_finished_connects Yes Global No
ssl_fips_mode Yes Yes Yes Global No
ssl_key Yes Yes Yes Global Yes
Ssl_server_not_after Yes Both No
Ssl_server_not_before Yes Both No
Ssl_session_cache_hits Yes Global No
Ssl_session_cache_misses Yes Global No
Ssl_session_cache_mode Yes Global No
ssl_session_cache_mode Yes Yes Yes Global Yes
Ssl_session_cache_overflows Yes Global No
Ssl_session_cache_size Yes Global No
Ssl_session_cache_timeout Yes Global No
ssl_session_cache_timeout Yes Yes Yes Global Yes
Ssl_session_cache_timeouts Yes Global No
Ssl_sessions_reused Yes Session No
Ssl_used_session_cache_entries Yes Global No
Ssl_verify_depth Yes Both No
Ssl_verify_mode Yes Both No
Ssl_version Yes Both No
standalone Yes Yes
stored_program_cache Yes Yes Yes Global Yes
stored_program_definition_cache Yes Yes Yes Global Yes
super-large-pages Yes Yes
super_read_only Yes Yes Yes Global Yes
symbolic-links Yes Yes
sync_binlog Yes Yes Yes Global Yes
sync_master_info Yes Yes Yes Global Yes
sync_relay_log Yes Yes Yes Global Yes
sync_relay_log_info Yes Yes Yes Global Yes
sync_source_info Yes Yes Yes Global Yes
sysdate-is-now Yes Yes
syseventlog.facility Yes Yes Yes Global Yes
syseventlog.include_pid Yes Yes Yes Global Yes
syseventlog.tag Yes Yes Yes Global Yes
system_time_zone Yes Global No
table_definition_cache Yes Yes Yes Global Yes
table_encryption_privilege_check Yes Yes Yes Global Yes
Table_locks_immediate Yes Global No
Table_locks_waited Yes Global No
table_open_cache Yes Yes Yes Global Yes
Table_open_cache_hits Yes Both No
table_open_cache_instances Yes Yes Yes Global No
Table_open_cache_misses Yes Both No
Table_open_cache_overflows Yes Both No
tablespace_definition_cache Yes Yes Yes Global Yes
tc-heuristic-recover Yes Yes
Tc_log_max_pages_used Yes Global No
Tc_log_page_size Yes Global No
Tc_log_page_waits Yes Global No
Telemetry_metrics_supported Yes Global No
Telemetry_traces_supported Yes Global No
telemetry.live_sessions Yes Global No
telemetry.metrics_reader_frequency_1 Yes Global No
telemetry.metrics_reader_frequency_2 Yes Global No
telemetry.metrics_reader_frequency_3 Yes Global No
telemetry.otel_bsp_max_export_batch_size Yes Global No
telemetry.otel_bsp_max_queue_size Yes Global No
telemetry.otel_bsp_schedule_delay Yes Global No
telemetry.otel_exporter_otlp_metrics_certificates Yes Global No
telemetry.otel_exporter_otlp_metrics_cipher Yes Global No
telemetry.otel_exporter_otlp_metrics_cipher_suite Yes Global No
telemetry.otel_exporter_otlp_metrics_client_certificates Yes Global No
telemetry.otel_exporter_otlp_metrics_client_key Yes Global No
telemetry.otel_exporter_otlp_metrics_compression Yes Global No
telemetry.otel_exporter_otlp_metrics_endpoint Yes Global No
telemetry.otel_exporter_otlp_metrics_headers Yes Global No
telemetry.otel_exporter_otlp_metrics_max_tls Yes Global No
telemetry.otel_exporter_otlp_metrics_min_tls Yes Global No
telemetry.otel_exporter_otlp_metrics_protocol Yes Global No
telemetry.otel_exporter_otlp_metrics_timeout Yes Global No
telemetry.otel_exporter_otlp_traces_certificates Yes Global No
telemetry.otel_exporter_otlp_traces_cipher Yes Global No
telemetry.otel_exporter_otlp_traces_cipher_suite Yes Global No
telemetry.otel_exporter_otlp_traces_client_certificates Yes Global No
telemetry.otel_exporter_otlp_traces_client_key Yes Global No
telemetry.otel_exporter_otlp_traces_compression Yes Global No
telemetry.otel_exporter_otlp_traces_endpoint Yes Global No
telemetry.otel_exporter_otlp_traces_headers Yes Global No
telemetry.otel_exporter_otlp_traces_max_tls Yes Global No
telemetry.otel_exporter_otlp_traces_min_tls Yes Global No
telemetry.otel_exporter_otlp_traces_protocol Yes Global No
telemetry.otel_exporter_otlp_traces_timeout Yes Global No
telemetry.otel_log_level Yes Global Yes
telemetry.otel_resource_attributes Yes Global No
telemetry.query_text_enabled Yes Global Yes
telemetry.trace_enabled Yes Global Yes
temptable_max_mmap Yes Yes Yes Global Yes
temptable_max_ram Yes Yes Yes Global Yes
temptable_use_mmap Yes Yes Yes Global Yes
terminology_use_previous Yes Yes Yes Both Yes
thread_cache_size Yes Yes Yes Global Yes
thread_handling Yes Yes Yes Global No
thread_pool_algorithm Yes Yes Yes Global No
thread_pool_dedicated_listeners Yes Yes Yes Global No
thread_pool_high_priority_connection Yes Yes Yes Both Yes
thread_pool_max_active_query_threads Yes Yes Yes Global Yes
thread_pool_max_transactions_limit Yes Yes Yes Global Yes
thread_pool_max_unused_threads Yes Yes Yes Global Yes
thread_pool_prio_kickup_timer Yes Yes Yes Global Yes
thread_pool_query_threads_per_group Yes Yes Yes Global Yes
thread_pool_size Yes Yes Yes Global No
thread_pool_stall_limit Yes Yes Yes Global Yes
thread_pool_transaction_delay Yes Yes Yes Global Yes
thread_stack Yes Yes Yes Global No
Threads_cached Yes Global No
Threads_connected Yes Global No
Threads_created Yes Global No
Threads_running Yes Global No
time_zone Yes Both Yes
timestamp Yes Session Yes
tls_certificates_enforced_validation Yes Yes Global No
tls_ciphersuites Yes Yes Yes Global Yes
Tls_library_version Yes Global No
Tls_sni_server_name Yes Session No
tls_version Yes Yes Yes Global Yes
tmp_table_size Yes Yes Yes Both Yes
tmpdir Yes Yes Yes Global No
transaction_alloc_block_size Yes Yes Yes Both Yes
transaction_allow_batching Yes Session Yes
transaction_isolation Yes Yes Yes Both Yes
transaction_prealloc_size Yes Yes Yes Both Yes
transaction_read_only Yes Yes Yes Both Yes
unique_checks Yes Both Yes
updatable_views_with_limit Yes Yes Yes Both Yes
upgrade Yes Yes
Uptime Yes Global No
Uptime_since_flush_status Yes Global No
use_secondary_engine Yes Session Yes
user Yes Yes
validate-config Yes Yes
validate-password Yes Yes
validate_password_check_user_name Yes Yes Yes Global Yes
validate_password_dictionary_file Yes Yes Yes Global Yes
validate_password_dictionary_file_last_parsed Yes Global No
validate_password_dictionary_file_words_count Yes Global No
validate_password_length Yes Yes Yes Global Yes
validate_password_mixed_case_count Yes Yes Yes Global Yes
validate_password_number_count Yes Yes Yes Global Yes
validate_password_policy Yes Yes Yes Global Yes
validate_password_special_char_count Yes Yes Yes Global Yes
validate_password.changed_characters_percentage Yes Yes Yes Global Yes
validate_password.check_user_name Yes Yes Yes Global Yes
validate_password.dictionary_file Yes Yes Yes Global Yes
validate_password.dictionary_file_last_parsed Yes Global No
validate_password.dictionary_file_words_count Yes Global No
validate_password.length Yes Yes Yes Global Yes
validate_password.mixed_case_count Yes Yes Yes Global Yes
validate_password.number_count Yes Yes Yes Global Yes
validate_password.policy Yes Yes Yes Global Yes
validate_password.special_char_count Yes Yes Yes Global Yes
validate-user-plugins Yes Yes
verbose Yes Yes
version Yes Global No
version_comment Yes Global No
version_compile_machine Yes Global No
version_compile_os Yes Global No
version_compile_zlib Yes Global No
version_tokens_session Yes Yes Yes Both Yes
version_tokens_session_number Yes Yes Yes Both No
wait_timeout Yes Yes Yes Both Yes
warning_count Yes Session No
windowing_use_high_precision Yes Yes Yes Both Yes
xa_detach_on_prepare Yes Yes Yes Both Yes

Notes:

1. This option is dynamic, but should be set only by server. You should not set this variable manually.