MySQL服务器系统变量(mysqld)
下表列出了适用于的所有系统变量mysqld
。
该表在一个统一列表中列出了命令行选项(Cmd-line),在配置文件中有效的选项(Option file),服务器系统变量(System Var)和状态变量(Status var),并指出了每个选项的位置或变量有效。如果在命令行或选项文件中设置的服务器选项与相应系统变量的名称不同,则将在相应选项的下方立即标记变量名称。变量的范围(Var Scope)是全局,会话或两者。有关设置和使用变量的详细信息,请参见相应的项目描述。在适当的地方,提供了指向有关该项目的更多信息的直接链接。
表5.2系统变量摘要
Name | Cmd-Line | Option File | System Var | Var Scope | Dynamic |
---|---|---|---|---|---|
ctivate_all_roles_on_login | Yes | Yes | Yes | Global | Yes |
dmin_address | Yes | Yes | Yes | Global | No |
dmin_port | Yes | Yes | Yes | Global | No |
udit_log_buffer_size | Yes | Yes | Yes | Global | No |
udit_log_compression | Yes | Yes | Yes | Global | No |
udit_log_connection_policy | Yes | Yes | Yes | Global | Yes |
udit_log_current_session | Yes | Both | No | ||
udit_log_encryption | Yes | Yes | Yes | Global | No |
udit_log_exclude_accounts | Yes | Yes | Yes | Global | Yes |
udit_log_file | Yes | Yes | Yes | Global | No |
udit_log_filter_id | Yes | Both | No | ||
udit_log_flush | Yes | Global | Yes | ||
udit_log_format | Yes | Yes | Yes | Global | No |
udit_log_include_accounts | Yes | Yes | Yes | Global | Yes |
udit_log_password_history_keep_days | Yes | Yes | Yes | Global | Yes |
udit_log_policy | Yes | Yes | Yes | Global | No |
udit_log_read_buffer_size | Yes | Yes | Yes | Varies | Varies |
udit_log_rotate_on_size | Yes | Yes | Yes | Global | Yes |
udit_log_statement_policy | Yes | Yes | Yes | Global | Yes |
udit_log_strategy | Yes | Yes | Yes | Global | No |
uthentication_ldap_sasl_auth_method_name | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_bind_base_dn | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_bind_root_dn | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_bind_root_pwd | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_ca_path | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_group_search_attr | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_group_search_filter | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_init_pool_size | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_log_status | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_max_pool_size | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_server_host | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_server_port | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_tls | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_sasl_user_search_attr | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_auth_method_name | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_bind_base_dn | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_bind_root_dn | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_bind_root_pwd | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_ca_path | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_group_search_attr | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_group_search_filter | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_init_pool_size | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_log_status | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_max_pool_size | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_server_host | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_server_port | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_tls | Yes | Yes | Yes | Global | Yes |
uthentication_ldap_simple_user_search_attr | Yes | Yes | Yes | Global | Yes |
uthentication_windows_log_level | Yes | Yes | Yes | Global | No |
uthentication_windows_use_principal_name | Yes | Yes | Yes | Global | No |
uto_generate_certs | Yes | Yes | Yes | Global | No |
uto_increment_increment | Yes | Yes | Yes | Both | Yes |
uto_increment_offset | Yes | Yes | Yes | Both | Yes |
utocommit | Yes | Yes | Yes | Both | Yes |
utomatic_sp_privileges | Yes | Yes | Yes | Global | Yes |
void_temporal_upgrade | 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_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_metadat | 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_dependency_history_size | Yes | Yes | Yes | Global | Yes |
binlog_transaction_dependency_tracking | Yes | Yes | Yes | Global | Yes |
block_encryption_mode | Yes | Yes | Yes | Both | Yes |
bulk_insert_buffer_size | Yes | Yes | Yes | Both | Yes |
caching_sha2_password_auto_generate_rsa_keys | 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 |
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_buffer_size | Yes | Yes | Yes | Global | Yes |
clone_ddl_timeout | 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_c | 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 |
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 |
core_file | Yes | Global | No | ||
create_admin_listener_thread | Yes | Yes | Yes | Global | No |
cte_max_recursion_depth | Yes | Yes | Yes | Both | Yes |
daemon_memcached_enable_binlog | Yes | Yes | Yes | Global | No |
daemon_memcached_engine_lib_name | Yes | Yes | Yes | Global | No |
daemon_memcached_engine_lib_path | Yes | Yes | Yes | Global | No |
daemon_memcached_option | Yes | Yes | Yes | Global | No |
daemon_memcached_r_batch_size | Yes | Yes | Yes | Global | No |
daemon_memcached_w_batch_size | Yes | Yes | Yes | Global | No |
datadir | Yes | Yes | Yes | Global | No |
debug | Yes | Yes | Yes | Both | Yes |
debug_sync | Yes | Session | Yes | ||
default_authentication_plugin | Yes | Yes | Yes | Global | No |
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 |
eq_range_index_dive_limit | Yes | Yes | Yes | Both | Yes |
error_count | Yes | Session | No | ||
event_scheduler | Yes | Yes | Yes | Global | Yes |
expire_logs_days | Yes | Yes | Yes | Global | 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 |
group_concat_max_len | Yes | Yes | Yes | Both | 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_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_commit_quot | Yes | Yes | Yes | Global | Yes |
group_replication_flow_control_member_quota_percent | Yes | Yes | Yes | Global | Yes |
group_replication_flow_control_min_quot | Yes | Yes | Yes | Global | Yes |
group_replication_flow_control_min_recovery_quot | 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_whitelist | 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_poll_spin_loops | Yes | Yes | Yes | Global | Yes |
group_replication_recovery_complete_at | Yes | Yes | Yes | Global | Yes |
group_replication_recovery_compression_algorithm | 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_c | 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_transaction_size_limit | Yes | Yes | Yes | Global | Yes |
group_replication_unreachable_majority_timeout | Yes | Yes | Yes | Global | Yes |
gtid_executed | Yes | Varies | 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 | ||
have_compress | Yes | Global | No | ||
have_dynamic_loading | Yes | Global | No | ||
have_geometry | Yes | Global | No | ||
have_openssl | Yes | Global | No | ||
have_profiling | Yes | Global | No | ||
have_query_cache | Yes | Global | No | ||
have_rtree_keys | Yes | Global | No | ||
have_ssl | Yes | Global | No | ||
have_statement_timeout | Yes | Global | No | ||
have_symlink | Yes | Global | No | ||
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_slave | Yes | Yes | Yes | Global | 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_api_bk_commit_interval | Yes | Yes | Yes | Global | Yes |
innodb_api_disable_rowlock | Yes | Yes | Yes | Global | No |
innodb_api_enable_binlog | Yes | Yes | Yes | Global | No |
innodb_api_enable_mdl | Yes | Yes | Yes | Global | No |
innodb_api_trx_level | 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_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_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_size | Yes | Yes | Yes | Global | Yes |
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_home_dir | Yes | Yes | Yes | Global | No |
innodb_ddl_log_crash_reset_debug | Yes | Yes | Yes | Global | 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 | No |
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_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 | Varies |
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_write_ahead_size | Yes | Yes | Yes | Global | Yes |
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_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 | No |
innodb_optimize_fulltext_only | Yes | Yes | Yes | Global | Yes |
innodb_page_cleaners | Yes | Yes | Yes | Global | No |
innodb_page_size | Yes | Yes | 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_encrypt | Yes | Yes | Yes | Global | Yes |
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_saved_page_number_debug | 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_metadat | 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_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_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_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 | Varies |
innodb_use_native_aio | Yes | Yes | Yes | Global | No |
innodb_version | Yes | Global | No | ||
innodb_write_io_threads | Yes | Yes | Yes | Global | No |
insert_id | Yes | Session | Yes | ||
interactive_timeout | Yes | Yes | Yes | Both | Yes |
internal_tmp_disk_storage_engine | Yes | Yes | Yes | Global | 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_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 |
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_encrypted_file_dat | Yes | Yes | Yes | Global | Yes |
keyring_encrypted_file_password | Yes | Yes | Yes | Global | Yes |
keyring_file_dat | 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_okv_conf_dir | Yes | Yes | Yes | Global | Yes |
keyring_operations | Yes | Global | Yes | ||
language | Yes | Yes | Yes | Global | No |
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 | ||
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 |
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_in_memory | Yes | Global | No | ||
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_bin_use_v1_row_events | Yes | Yes | Yes | Global | No |
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_output | Yes | Yes | Yes | Global | Yes |
log_queries_not_using_indexes | Yes | Yes | Yes | Global | Yes |
log_raw | Yes | Yes | Yes | Global | Yes |
log_slave_updates | Yes | Yes | Yes | Global | No |
log_slow_admin_statements | Yes | Yes | Yes | Global | Yes |
log_slow_extr | 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_syslog | Yes | Yes | Yes | Global | Yes |
log_syslog_facility | Yes | Yes | Yes | Global | Yes |
log_syslog_include_pid | Yes | Yes | Yes | Global | Yes |
log_syslog_tag | Yes | Yes | Yes | Global | 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_info_repository | Yes | Yes | Yes | Global | 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_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_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_dat | 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_user_connections | Yes | Yes | Yes | Both | Yes |
max_write_lock_count | Yes | Yes | Yes | Global | Yes |
mecab_rc_file | Yes | Yes | Yes | Global | No |
metadata_locks_cache_size | Yes | Yes | Yes | Global | No |
metadata_locks_hash_instances | Yes | Yes | Yes | Global | No |
min_examined_row_limit | Yes | Yes | Yes | Both | 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_repair_threads | Yes | Yes | Yes | Both | Yes |
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_mode | Yes | Yes | Yes | Global | Yes |
mysql_firewall_trace | Yes | Yes | Yes | Global | Yes |
mysql_native_password_proxy_users | Yes | Yes | Yes | Global | Yes |
mysqlx_bind_address | Yes | Yes | Yes | Global | No |
mysqlx_compression_algorithms | Yes | Yes | Yes | Global | Yes |
mysqlx_connect_timeout | 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_idle_worker_thread_timeout | Yes | Yes | Yes | Global | Yes |
mysqlx_interactive_timeout | Yes | Yes | Yes | Global | Yes |
mysqlx_max_allowed_packet | Yes | Yes | Yes | Global | Yes |
mysqlx_max_connections | Yes | Yes | Yes | Global | Yes |
mysqlx_min_worker_threads | Yes | Yes | Yes | Global | Yes |
mysqlx_port | Yes | Yes | Yes | Global | No |
mysqlx_port_open_timeout | Yes | Yes | Yes | Global | No |
mysqlx_read_timeout | Yes | Yes | Yes | Session | Yes |
mysqlx_socket | Yes | Yes | Yes | Global | No |
mysqlx_ssl_c | 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 | Yes | Yes | Global | No |
mysqlx_ssl_crl | Yes | Yes | Yes | Global | No |
mysqlx_ssl_crlpath | Yes | Yes | Yes | Global | No |
mysqlx_ssl_key | Yes | Yes | Yes | Global | No |
mysqlx_wait_timeout | Yes | Yes | Yes | Session | Yes |
mysqlx_write_timeout | Yes | Yes | Yes | Session | 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_autoincrement_prefetch_sz | Yes | Yes | Yes | Both | Yes |
ndb_batch_size | Yes | Yes | Yes | Global | No |
ndb_blob_read_batch_bytes | Yes | Yes | Yes | Both | Yes |
ndb_blob_write_batch_bytes | Yes | Yes | Yes | Both | Yes |
ndb_cache_check_time | Yes | Yes | Yes | Global | 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_conflict_last_conflict_epoch | Yes | Global | No | ||
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_eventbuffer_free_percent | Yes | Yes | Yes | Global | Yes |
ndb_eventbuffer_max_alloc | Yes | Yes | Yes | Global | Yes |
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_log_apply_status | Yes | Yes | Yes | Global | No |
ndb_log_apply_status | Yes | Yes | Yes | Global | No |
ndb_log_bin | Yes | Yes | Both | Yes | |
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_orig | Yes | Yes | Yes | Global | No |
ndb_log_orig | 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_sync | Yes | Global | Yes | ||
ndb_optimization_delay | Yes | Yes | Yes | Global | Yes |
ndb_optimized_node_selection | Yes | Yes | 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_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_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_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 |
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 | Yes | Both | Yes | |
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 |
new | Yes | Yes | Yes | Both | Yes |
ngram_token_size | Yes | Yes | Yes | Global | No |
offline_mode | Yes | Yes | Yes | Global | Yes |
old | Yes | Yes | Yes | Global | No |
old_alter_table | Yes | Yes | Yes | Both | Yes |
open_files_limit | Yes | Yes | Yes | Global | 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_schem | Yes | Yes | Yes | Global | No |
performance_schema_accounts_size | Yes | Yes | 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_hosts_size | Yes | Yes | 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_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_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_users_size | Yes | Yes | Yes | Global | No |
persist_only_admin_x509_subject | 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 | Yes | Global | No |
plugin_load_add | Yes | Yes | Yes | Global | No |
port | Yes | Yes | Yes | Global | No |
preload_buffer_size | Yes | Yes | Yes | Both | 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_slave_mode | Yes | Session | Yes | ||
pseudo_thread_id | Yes | Session | Yes | ||
query_alloc_block_size | Yes | Yes | Yes | Both | Yes |
query_prealloc_size | Yes | Yes | Yes | Both | Yes |
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 | Both | 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_info_file | Yes | Yes | Yes | Global | No |
relay_log_info_repository | Yes | Yes | Yes | Global | Yes |
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 |
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 |
resultset_metadat | Yes | Session | Yes | ||
rewriter_enabled | Yes | Global | Yes | ||
rewriter_verbose | Yes | Global | Yes | ||
rpl_read_size | Yes | Yes | Yes | Global | Yes |
rpl_semi_sync_master_enabled | Yes | Yes | Yes | Global | Yes |
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_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_slave_enabled | Yes | Yes | Yes | Global | Yes |
rpl_semi_sync_slave_trace_level | Yes | Yes | Yes | Global | Yes |
rpl_stop_slave_timeout | Yes | Yes | Yes | Global | Yes |
schema_definition_cache | Yes | Yes | Yes | Global | Yes |
secondary_engine_cost_threshold | Yes | Session | Yes | ||
secure_file_priv | Yes | Yes | Yes | Global | 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_schem | 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 |
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_old_temporals | Yes | Yes | Yes | Both | Yes |
skip_external_locking | Yes | Yes | Yes | Global | No |
skip_name_resolve | Yes | Yes | Yes | Global | No |
skip_networking | Yes | Yes | Yes | Global | No |
skip_show_database | Yes | Yes | Yes | Global | No |
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_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_search_algorithms | Yes | Yes | Yes | Global | Yes |
slave_skip_errors | Yes | Yes | Yes | Global | No |
slave_sql_verify_checksum | Yes | Yes | Yes | Global | Yes |
slave_transaction_retries | Yes | Yes | Yes | Global | Yes |
slave_type_conversions | Yes | Yes | Yes | Global | No |
slow_launch_time | Yes | Yes | Yes | Global | Yes |
slow_query_log | Yes | Yes | Yes | Global | Yes |
slow_query_log_file | Yes | Yes | Yes | Global | Yes |
socket | Yes | Yes | Yes | Global | No |
sort_buffer_size | Yes | Yes | Yes | Both | Yes |
sql_auto_is_null | Yes | Both | Yes | ||
sql_big_selects | Yes | Both | Yes | ||
sql_buffer_result | 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_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_c | Yes | Yes | Yes | Global | Varies |
ssl_capath | Yes | Yes | Yes | Global | Varies |
ssl_cert | Yes | Yes | Yes | Global | Varies |
ssl_cipher | Yes | Yes | Yes | Global | Varies |
ssl_crl | Yes | Yes | Yes | Global | Varies |
ssl_crlpath | Yes | Yes | Yes | Global | Varies |
ssl_fips_mode | Yes | Yes | Yes | Global | Yes |
ssl_key | Yes | Yes | Yes | Global | Varies |
stored_program_cache | Yes | Yes | Yes | Global | Yes |
stored_program_definition_cache | Yes | Yes | Yes | Global | Yes |
super_read_only | Yes | Yes | Yes | Global | 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 |
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_open_cache | Yes | Yes | Yes | Global | Yes |
table_open_cache_instances | Yes | Yes | Yes | Global | No |
tablespace_definition_cache | Yes | Yes | Yes | Global | Yes |
temptable_max_ram | Yes | Yes | Yes | Global | Yes |
temptable_use_mmap | Yes | Yes | Yes | Global | 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_high_priority_connection | Yes | Yes | Yes | Both | Yes |
thread_pool_max_active_query_threads | Yes | Yes | Yes | Global | Yes |
thread_pool_max_unused_threads | Yes | Yes | Yes | Global | Yes |
thread_pool_prio_kickup_timer | Yes | Yes | Yes | Both | Yes |
thread_pool_size | Yes | Yes | Yes | Global | No |
thread_pool_stall_limit | Yes | Yes | Yes | Global | Yes |
thread_stack | Yes | Yes | Yes | Global | No |
time_zone | Yes | Both | Yes | ||
timestamp | Yes | Session | Yes | ||
tls_ciphersuites | Yes | Yes | Yes | Global | Yes |
tls_version | Yes | Yes | Yes | Global | Varies |
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 |
transaction_write_set_extraction | Yes | Yes | Yes | Both | Yes |
unique_checks | Yes | Both | Yes | ||
updatable_views_with_limit | Yes | Yes | Yes | Both | Yes |
use_secondary_engine | Yes | Session | Yes | ||
validate_password_check_user_name | Yes | Yes | Yes | Global | Yes |
validate_password_dictionary_file | Yes | Yes | Yes | Global | Yes |
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.check_user_name | Yes | Yes | Yes | Global | Yes |
validate_password.dictionary_file | Yes | Yes | Yes | Global | Yes |
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 | Yes | Global | No |
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 |
注意:此选项是动态的,但只有服务器应设置此信息。您不应手动设置此变量的值。