Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 296.4Kb
Man Pages (Zip) - 401.7Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

7.1.9.2 Dynamic System Variables

Many server system variables are dynamic and can be set at runtime. See Section 15.7.6.1, “SET Syntax for Variable Assignment”. For a description of the privilege requirements for setting system variables, see Section 7.1.9.1, “System Variable Privileges”

The following table lists all dynamic system variables applicable within mysqld.

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

Variables that have a type of string take a string value. Variables that have a type of numeric take a numeric value. Variables that have a type of boolean can be set to 0, 1, ON or OFF. Variables that are marked as enumeration normally should be set to one of the available values for the variable, but can also be set to the number that corresponds to the desired enumeration value. For enumerated system variables, the first enumeration value corresponds to 0. This differs from the ENUM data type used for table columns, for which the first enumeration value corresponds to 1.

Table 7.5 Dynamic System Variable Summary

Variable Name Variable Type Variable Scope
activate_all_roles_on_login Boolean Global
admin_ssl_ca File name Global
admin_ssl_capath Directory name Global
admin_ssl_cert File name Global
admin_ssl_cipher String Global
admin_ssl_crl File name Global
admin_ssl_crlpath Directory name Global
admin_ssl_key File name Global
admin_tls_ciphersuites String Global
admin_tls_version String Global
audit_log_connection_policy Enumeration Global
audit_log_disable Boolean Global
audit_log_exclude_accounts String Global
audit_log_flush Boolean Global
audit_log_format_unix_timestamp Boolean Global
audit_log_include_accounts String Global
audit_log_max_size Integer Global
audit_log_password_history_keep_days Integer Global
audit_log_prune_seconds Integer Global
audit_log_read_buffer_size Integer Varies
audit_log_rotate_on_size Integer Global
audit_log_statement_policy Enumeration Global
authentication_fido_rp_id String Global
authentication_kerberos_service_principal String Global
authentication_ldap_sasl_auth_method_name String Global
authentication_ldap_sasl_bind_base_dn String Global
authentication_ldap_sasl_bind_root_dn String Global
authentication_ldap_sasl_bind_root_pwd String Global
authentication_ldap_sasl_ca_path String Global
authentication_ldap_sasl_group_search_attr String Global
authentication_ldap_sasl_group_search_filter String Global
authentication_ldap_sasl_init_pool_size Integer Global
authentication_ldap_sasl_log_status Integer Global
authentication_ldap_sasl_max_pool_size Integer Global
authentication_ldap_sasl_referral Boolean Global
authentication_ldap_sasl_server_host String Global
authentication_ldap_sasl_server_port Integer Global
authentication_ldap_sasl_tls Boolean Global
authentication_ldap_sasl_user_search_attr String Global
authentication_ldap_simple_auth_method_name String Global
authentication_ldap_simple_bind_base_dn String Global
authentication_ldap_simple_bind_root_dn String Global
authentication_ldap_simple_bind_root_pwd String Global
authentication_ldap_simple_ca_path String Global
authentication_ldap_simple_group_search_attr String Global
authentication_ldap_simple_group_search_filter String Global
authentication_ldap_simple_init_pool_size Integer Global
authentication_ldap_simple_log_status Integer Global
authentication_ldap_simple_max_pool_size Integer Global
authentication_ldap_simple_referral Boolean Global
authentication_ldap_simple_server_host String Global
authentication_ldap_simple_server_port Integer Global
authentication_ldap_simple_tls Boolean Global
authentication_ldap_simple_user_search_attr String Global
authentication_policy String Global
auto_increment_increment Integer Both
auto_increment_offset Integer Both
autocommit Boolean Both
automatic_sp_privileges Boolean Global
avoid_temporal_upgrade Boolean Global
big_tables Boolean Both
binlog_cache_size Integer Global
binlog_checksum String Global
binlog_direct_non_transactional_updates Boolean Both
binlog_encryption Boolean Global
binlog_error_action Enumeration Global
binlog_expire_logs_auto_purge Boolean Global
binlog_expire_logs_seconds Integer Global
binlog_format Enumeration Both
binlog_group_commit_sync_delay Integer Global
binlog_group_commit_sync_no_delay_count Integer Global
binlog_max_flush_queue_time Integer Global
binlog_order_commits Boolean Global
binlog_row_image Enumeration Both
binlog_row_metadata Enumeration Global
binlog_row_value_options Set Both
binlog_rows_query_log_events Boolean Both
binlog_stmt_cache_size Integer Global
binlog_transaction_compression Boolean Both
binlog_transaction_compression_level_zstd Integer Both
binlog_transaction_dependency_history_size Integer Global
binlog_transaction_dependency_tracking Enumeration Global
block_encryption_mode String Both
bulk_insert_buffer_size Integer Both
character_set_client String Both
character_set_connection String Both
character_set_database String Both
character_set_filesystem String Both
character_set_results String Both
character_set_server String Both
check_proxy_users Boolean Global
clone_autotune_concurrency Boolean Global
clone_block_ddl Boolean Global
clone_buffer_size Integer Global
clone_ddl_timeout Integer Global
clone_delay_after_data_drop Integer Global
clone_donor_timeout_after_network_failure Integer Global
clone_enable_compression Boolean Global
clone_max_concurrency Integer Global
clone_max_data_bandwidth Integer Global
clone_max_network_bandwidth Integer Global
clone_ssl_ca File name Global
clone_ssl_cert File name Global
clone_ssl_key File name Global
clone_valid_donor_list String Global
collation_connection String Both
collation_database String Both
collation_server String Both
completion_type Enumeration Both
component_scheduler.enabled Boolean Global
concurrent_insert Enumeration Global
connect_timeout Integer Global
connection_control_failed_connections_threshold Integer Global
connection_control_max_connection_delay Integer Global
connection_control_min_connection_delay Integer Global
connection_memory_chunk_size Integer Both
connection_memory_limit Integer Both
cte_max_recursion_depth Integer Both
debug String Both
debug_sync String Session
default_collation_for_utf8mb4 Enumeration Both
default_password_lifetime Integer Global
default_storage_engine Enumeration Both
default_table_encryption Boolean Both
default_tmp_storage_engine Enumeration Both
default_week_format Integer Both
delay_key_write Enumeration Global
delayed_insert_limit Integer Global
delayed_insert_timeout Integer Global
delayed_queue_size Integer Global
div_precision_increment Integer Both
dragnet.log_error_filter_rules String Global
end_markers_in_json Boolean Both
enforce_gtid_consistency Enumeration Global
enterprise_encryption.maximum_rsa_key_size Integer Global
enterprise_encryption.rsa_support_legacy_padding Boolean Global
eq_range_index_dive_limit Integer Both
event_scheduler Enumeration Global
expire_logs_days Integer Global
explain_format Enumeration Both
explicit_defaults_for_timestamp Boolean Both
flush Boolean Global
flush_time Integer Global
foreign_key_checks Boolean Both
ft_boolean_syntax String Global
general_log Boolean Global
general_log_file File name Global
generated_random_password_length Integer Both
global_connection_memory_limit Integer Global
global_connection_memory_tracking Boolean Both
group_concat_max_len Integer Both
group_replication_advertise_recovery_endpoints String Global
group_replication_allow_local_lower_version_join Boolean Global
group_replication_auto_increment_increment Integer Global
group_replication_autorejoin_tries Integer Global
group_replication_bootstrap_group Boolean Global
group_replication_clone_threshold Integer Global
group_replication_communication_debug_options String Global
group_replication_communication_max_message_size Integer Global
group_replication_communication_stack String Global
group_replication_components_stop_timeout Integer Global
group_replication_compression_threshold Integer Global
group_replication_consistency Enumeration Both
group_replication_enforce_update_everywhere_checks Boolean Global
group_replication_exit_state_action Enumeration Global
group_replication_flow_control_applier_threshold Integer Global
group_replication_flow_control_certifier_threshold Integer Global
group_replication_flow_control_hold_percent Integer Global
group_replication_flow_control_max_quota Integer Global
group_replication_flow_control_member_quota_percent Integer Global
group_replication_flow_control_min_quota Integer Global
group_replication_flow_control_min_recovery_quota Integer Global
group_replication_flow_control_mode Enumeration Global
group_replication_flow_control_period Integer Global
group_replication_flow_control_release_percent Integer Global
group_replication_force_members String Global
group_replication_group_name String Global
group_replication_group_seeds String Global
group_replication_gtid_assignment_block_size Integer Global
group_replication_ip_allowlist String Global
group_replication_ip_whitelist String Global
group_replication_local_address String Global
group_replication_member_expel_timeout Integer Global
group_replication_member_weight Integer Global
group_replication_message_cache_size Integer Global
group_replication_paxos_single_leader Boolean Global
group_replication_poll_spin_loops Integer Global
group_replication_recovery_complete_at Enumeration Global
group_replication_recovery_compression_algorithms Set Global
group_replication_recovery_get_public_key Boolean Global
group_replication_recovery_public_key_path File name Global
group_replication_recovery_reconnect_interval Integer Global
group_replication_recovery_retry_count Integer Global
group_replication_recovery_ssl_ca String Global
group_replication_recovery_ssl_capath String Global
group_replication_recovery_ssl_cert String Global
group_replication_recovery_ssl_cipher String Global
group_replication_recovery_ssl_crl File name Global
group_replication_recovery_ssl_crlpath Directory name Global
group_replication_recovery_ssl_key String Global
group_replication_recovery_ssl_verify_server_cert Boolean Global
group_replication_recovery_tls_ciphersuites String Global
group_replication_recovery_tls_version String Global
group_replication_recovery_use_ssl Boolean Global
group_replication_recovery_zstd_compression_level Integer Global
group_replication_single_primary_mode Boolean Global
group_replication_ssl_mode Enumeration Global
group_replication_start_on_boot Boolean Global
group_replication_tls_source Enumeration Global
group_replication_transaction_size_limit Integer Global
group_replication_unreachable_majority_timeout Integer Global
group_replication_view_change_uuid String Global
gtid_executed_compression_period Integer Global
gtid_mode Enumeration Global
gtid_next Enumeration Session
gtid_purged String Global
histogram_generation_max_mem_size Integer Both
host_cache_size Integer Global
identity Integer Session
immediate_server_version Integer Session
information_schema_stats_expiry Integer Both
init_connect String Global
init_replica String Global
init_slave String Global
innodb_adaptive_flushing Boolean Global
innodb_adaptive_flushing_lwm Integer Global
innodb_adaptive_hash_index Boolean Global
innodb_adaptive_max_sleep_delay Integer Global
innodb_api_bk_commit_interval Integer Global
innodb_api_trx_level Integer Global
innodb_autoextend_increment Integer Global
innodb_background_drop_list_empty Boolean Global
innodb_buffer_pool_dump_at_shutdown Boolean Global
innodb_buffer_pool_dump_now Boolean Global
innodb_buffer_pool_dump_pct Integer Global
innodb_buffer_pool_filename File name Global
innodb_buffer_pool_in_core_file Boolean Global
innodb_buffer_pool_load_abort Boolean Global
innodb_buffer_pool_load_now Boolean Global
innodb_buffer_pool_size Integer Global
innodb_change_buffer_max_size Integer Global
innodb_change_buffering Enumeration Global
innodb_change_buffering_debug Integer Global
innodb_checkpoint_disabled Boolean Global
innodb_checksum_algorithm Enumeration Global
innodb_cmp_per_index_enabled Boolean Global
innodb_commit_concurrency Integer Global
innodb_compress_debug Enumeration Global
innodb_compression_failure_threshold_pct Integer Global
innodb_compression_level Integer Global
innodb_compression_pad_pct_max Integer Global
innodb_concurrency_tickets Integer Global
innodb_ddl_buffer_size Integer Session
innodb_ddl_log_crash_reset_debug Boolean Global
innodb_ddl_threads Integer Session
innodb_deadlock_detect Boolean Global
innodb_default_row_format Enumeration Global
innodb_disable_sort_file_cache Boolean Global
innodb_doublewrite Enumeration Global
innodb_extend_and_initialize Boolean Global
innodb_fast_shutdown Integer Global
innodb_fil_make_page_dirty_debug Integer Global
innodb_file_per_table Boolean Global
innodb_fill_factor Integer Global
innodb_flush_log_at_timeout Integer Global
innodb_flush_log_at_trx_commit Enumeration Global
innodb_flush_neighbors Enumeration Global
innodb_flush_sync Boolean Global
innodb_flushing_avg_loops Integer Global
innodb_fsync_threshold Integer Global
innodb_ft_aux_table String Global
innodb_ft_enable_diag_print Boolean Global
innodb_ft_enable_stopword Boolean Both
innodb_ft_num_word_optimize Integer Global
innodb_ft_result_cache_limit Integer Global
innodb_ft_server_stopword_table String Global
innodb_ft_user_stopword_table String Both
innodb_idle_flush_pct Integer Global
innodb_io_capacity Integer Global
innodb_io_capacity_max Integer Global
innodb_limit_optimistic_insert_debug Integer Global
innodb_lock_wait_timeout Integer Both
innodb_log_buffer_size Integer Global
innodb_log_checkpoint_fuzzy_now Boolean Global
innodb_log_checkpoint_now Boolean Global
innodb_log_checksums Boolean Global
innodb_log_compressed_pages Boolean Global
innodb_log_spin_cpu_abs_lwm Integer Global
innodb_log_spin_cpu_pct_hwm Integer Global
innodb_log_wait_for_flush_spin_hwm Integer Global
innodb_log_write_ahead_size Integer Global
innodb_log_writer_threads Boolean Global
innodb_lru_scan_depth Integer Global
innodb_max_dirty_pages_pct Numeric Global
innodb_max_dirty_pages_pct_lwm Numeric Global
innodb_max_purge_lag Integer Global
innodb_max_purge_lag_delay Integer Global
innodb_max_undo_log_size Integer Global
innodb_merge_threshold_set_all_debug Integer Global
innodb_monitor_disable String Global
innodb_monitor_enable String Global
innodb_monitor_reset Enumeration Global
innodb_monitor_reset_all Enumeration Global
innodb_old_blocks_pct Integer Global
innodb_old_blocks_time Integer Global
innodb_online_alter_log_max_size Integer Global
innodb_open_files Integer Global
innodb_optimize_fulltext_only Boolean Global
innodb_parallel_read_threads Integer Session
innodb_print_all_deadlocks Boolean Global
innodb_print_ddl_logs Boolean Global
innodb_purge_batch_size Integer Global
innodb_purge_rseg_truncate_frequency Integer Global
innodb_random_read_ahead Boolean Global
innodb_read_ahead_threshold Integer Global
innodb_redo_log_archive_dirs String Global
innodb_redo_log_capacity Integer Global
innodb_redo_log_encrypt Boolean Global
innodb_replication_delay Integer Global
innodb_rollback_segments Integer Global
innodb_saved_page_number_debug Integer Global
innodb_segment_reserve_factor Numeric Global
innodb_spin_wait_delay Integer Global
innodb_spin_wait_pause_multiplier Integer Global
innodb_stats_auto_recalc Boolean Global
innodb_stats_include_delete_marked Boolean Global
innodb_stats_method Enumeration Global
innodb_stats_on_metadata Boolean Global
innodb_stats_persistent Boolean Global
innodb_stats_persistent_sample_pages Integer Global
innodb_stats_transient_sample_pages Integer Global
innodb_status_output Boolean Global
innodb_status_output_locks Boolean Global
innodb_strict_mode Boolean Both
innodb_sync_spin_loops Integer Global
innodb_table_locks Boolean Both
innodb_thread_concurrency Integer Global
innodb_thread_sleep_delay Integer Global
innodb_tmpdir Directory name Both
innodb_trx_purge_view_update_only_debug Boolean Global
innodb_trx_rseg_n_slots_debug Integer Global
innodb_undo_log_encrypt Boolean Global
innodb_undo_log_truncate Boolean Global
innodb_undo_tablespaces Integer Global
innodb_use_fdatasync Boolean Global
insert_id Integer Session
interactive_timeout Integer Both
internal_tmp_disk_storage_engine Enumeration Global
internal_tmp_mem_storage_engine Enumeration Both
join_buffer_size Integer Both
keep_files_on_create Boolean Both
key_buffer_size Integer Global
key_cache_age_threshold Integer Global
key_cache_block_size Integer Global
key_cache_division_limit Integer Global
keyring_aws_cmk_id String Global
keyring_aws_region Enumeration Global
keyring_encrypted_file_data File name Global
keyring_encrypted_file_password String Global
keyring_file_data File name Global
keyring_hashicorp_auth_path String Global
keyring_hashicorp_ca_path File name Global
keyring_hashicorp_caching Boolean Global
keyring_hashicorp_role_id String Global
keyring_hashicorp_secret_id String Global
keyring_hashicorp_server_url String Global
keyring_hashicorp_store_path String Global
keyring_okv_conf_dir Directory name Global
keyring_operations Boolean Global
last_insert_id Integer Session
lc_messages String Both
lc_time_names String Both
local_infile Boolean Global
lock_wait_timeout Integer Both
log_bin_trust_function_creators Boolean Global
log_bin_use_v1_row_events Boolean Global
log_error_services String Global
log_error_suppression_list String Global
log_error_verbosity Integer Global
log_output Set Global
log_queries_not_using_indexes Boolean Global
log_raw Boolean Global
log_slow_admin_statements Boolean Global
log_slow_extra Boolean Global
log_slow_replica_statements Boolean Global
log_slow_slave_statements Boolean Global
log_statements_unsafe_for_binlog Boolean Global
log_syslog Boolean Global
log_syslog_facility String Global
log_syslog_include_pid Boolean Global
log_syslog_tag String Global
log_throttle_queries_not_using_indexes Integer Global
log_timestamps Enumeration Global
long_query_time Numeric Both
low_priority_updates Boolean Both
mandatory_roles String Global
master_info_repository String Global
master_verify_checksum Boolean Global
max_allowed_packet Integer Both
max_binlog_cache_size Integer Global
max_binlog_size Integer Global
max_binlog_stmt_cache_size Integer Global
max_connect_errors Integer Global
max_connections Integer Global
max_delayed_threads Integer Both
max_error_count Integer Both
max_execution_time Integer Both
max_heap_table_size Integer Both
max_insert_delayed_threads Integer Both
max_join_size Integer Both
max_length_for_sort_data Integer Both
max_points_in_geometry Integer Both
max_prepared_stmt_count Integer Global
max_relay_log_size Integer Global
max_seeks_for_key Integer Both
max_sort_length Integer Both
max_sp_recursion_depth Integer Both
max_user_connections Integer Both
max_write_lock_count Integer Global
min_examined_row_limit Integer Both
myisam_data_pointer_size Integer Global
myisam_max_sort_file_size Integer Global
myisam_repair_threads Integer Both
myisam_sort_buffer_size Integer Both
myisam_stats_method Enumeration Both
myisam_use_mmap Boolean Global
mysql_firewall_mode Boolean Global
mysql_firewall_trace Boolean Global
mysql_native_password_proxy_users Boolean Global
mysqlx_compression_algorithms Set Global
mysqlx_connect_timeout Integer Global
mysqlx_deflate_default_compression_level Integer Global
mysqlx_deflate_max_client_compression_level Integer Global
mysqlx_document_id_unique_prefix Integer Global
mysqlx_enable_hello_notice Boolean Global
mysqlx_idle_worker_thread_timeout Integer Global
mysqlx_interactive_timeout Integer Global
mysqlx_lz4_default_compression_level Integer Global
mysqlx_lz4_max_client_compression_level Integer Global
mysqlx_max_allowed_packet Integer Global
mysqlx_max_connections Integer Global
mysqlx_min_worker_threads Integer Global
mysqlx_read_timeout Integer Session
mysqlx_wait_timeout Integer Session
mysqlx_write_timeout Integer Session
mysqlx_zstd_default_compression_level Integer Global
mysqlx_zstd_max_client_compression_level Integer Global
ndb_allow_copying_alter_table Boolean Both
ndb_autoincrement_prefetch_sz Integer Both
ndb_batch_size Integer Both
ndb_blob_read_batch_bytes Integer Both
ndb_blob_write_batch_bytes Integer Both
ndb_clear_apply_status Boolean Global
ndb_conflict_role Enumeration Global
ndb_data_node_neighbour Integer Global
ndb_dbg_check_shares Integer Both
ndb_default_column_format Enumeration Global
ndb_default_column_format Enumeration Global
ndb_deferred_constraints Integer Both
ndb_deferred_constraints Integer Both
ndb_distribution Enumeration Global
ndb_distribution Enumeration Global
ndb_eventbuffer_free_percent Integer Global
ndb_eventbuffer_max_alloc Integer Global
ndb_extra_logging Integer Global
ndb_force_send Boolean Both
ndb_fully_replicated Boolean Both
ndb_index_stat_enable Boolean Both
ndb_index_stat_option String Both
ndb_join_pushdown Boolean Both
ndb_log_binlog_index Boolean Global
ndb_log_cache_size Integer Global
ndb_log_empty_epochs Boolean Global
ndb_log_empty_epochs Boolean Global
ndb_log_empty_update Boolean Global
ndb_log_empty_update Boolean Global
ndb_log_exclusive_reads Boolean Both
ndb_log_exclusive_reads Boolean Both
ndb_log_transaction_compression Boolean Global
ndb_log_transaction_compression_level_zstd Integer Global
ndb_log_update_as_write Boolean Global
ndb_log_update_minimal Boolean Global
ndb_log_updated_only Boolean Global
ndb_metadata_check Boolean Global
ndb_metadata_check_interval Integer Global
ndb_metadata_sync Boolean Global
ndb_optimization_delay Integer Global
ndb_read_backup Boolean Global
ndb_recv_thread_activation_threshold Integer Global
ndb_recv_thread_cpu_mask Bitmap Global
ndb_replica_batch_size Integer Global
ndb_replica_blob_write_batch_bytes Integer Global
ndb_report_thresh_binlog_epoch_slip Integer Global
ndb_report_thresh_binlog_mem_usage Integer Global
ndb_row_checksum Integer Both
ndb_schema_dist_lock_wait_timeout Integer Global
ndb_show_foreign_key_mock_tables Boolean Global
ndb_slave_conflict_role Enumeration Global
ndb_table_no_logging Boolean Session
ndb_table_temporary Boolean Session
ndb_use_exact_count Boolean Both
ndb_use_transactions Boolean Both
ndbinfo_max_bytes Integer Both
ndbinfo_max_rows Integer Both
ndbinfo_offline Boolean Global
ndbinfo_show_hidden Boolean Both
net_buffer_length Integer Both
net_read_timeout Integer Both
net_retry_count Integer Both
net_write_timeout Integer Both
new Boolean Both
offline_mode Boolean Global
old_alter_table Boolean Both
optimizer_prune_level Integer Both
optimizer_search_depth Integer Both
optimizer_switch Set Both
optimizer_trace String Both
optimizer_trace_features String Both
optimizer_trace_limit Integer Both
optimizer_trace_max_mem_size Integer Both
optimizer_trace_offset Integer Both
original_commit_timestamp Numeric Session
original_server_version Integer Session
parser_max_mem_size Integer Both
partial_revokes Boolean Global
password_history Integer Global
password_require_current Boolean Global
password_reuse_interval Integer Global
performance_schema_max_digest_sample_age Integer Global
performance_schema_show_processlist Boolean Global
preload_buffer_size Integer Both
print_identified_with_as_hex Boolean Both
profiling Boolean Both
profiling_history_size Integer Both
protocol_compression_algorithms Set Global
pseudo_replica_mode Boolean Session
pseudo_slave_mode Boolean Session
pseudo_thread_id Integer Session
query_alloc_block_size Integer Both
query_prealloc_size Integer Both
rand_seed1 Integer Session
rand_seed2 Integer Session
range_alloc_block_size Integer Both
range_optimizer_max_mem_size Integer Both
rbr_exec_mode Enumeration Session
read_buffer_size Integer Both
read_only Boolean Global
read_rnd_buffer_size Integer Both
regexp_stack_limit Integer Global
regexp_time_limit Integer Global
relay_log_info_repository String Global
relay_log_purge Boolean Global
replica_allow_batching Boolean Global
replica_checkpoint_group Integer Global
replica_checkpoint_period Integer Global
replica_compressed_protocol Boolean Global
replica_exec_mode Enumeration Global
replica_max_allowed_packet Integer Global
replica_net_timeout Integer Global
replica_parallel_type Enumeration Global
replica_parallel_workers Integer Global
replica_pending_jobs_size_max Integer Global
replica_preserve_commit_order Boolean Global
replica_sql_verify_checksum Boolean Global
replica_transaction_retries Integer Global
replica_type_conversions Set Global
replication_optimize_for_static_plugin_config Boolean Global
replication_sender_observe_commit_only Boolean Global
require_row_format Boolean Session
require_secure_transport Boolean Global
resultset_metadata Enumeration Session
rewriter_enabled Boolean Global
rewriter_enabled_for_threads_without_privilege_checks Boolean Global
rewriter_verbose Integer Global
rpl_read_size Integer Global
rpl_semi_sync_master_enabled Boolean Global
rpl_semi_sync_master_timeout Integer Global
rpl_semi_sync_master_trace_level Integer Global
rpl_semi_sync_master_wait_for_slave_count Integer Global
rpl_semi_sync_master_wait_no_slave Boolean Global
rpl_semi_sync_master_wait_point Enumeration Global
rpl_semi_sync_replica_enabled Boolean Global
rpl_semi_sync_replica_trace_level Integer Global
rpl_semi_sync_slave_enabled Boolean Global
rpl_semi_sync_slave_trace_level Integer Global
rpl_semi_sync_source_enabled Boolean Global
rpl_semi_sync_source_timeout Integer Global
rpl_semi_sync_source_trace_level Integer Global
rpl_semi_sync_source_wait_for_replica_count Integer Global
rpl_semi_sync_source_wait_no_replica Boolean Global
rpl_semi_sync_source_wait_point Enumeration Global
rpl_stop_replica_timeout Integer Global
rpl_stop_slave_timeout Integer Global
schema_definition_cache Integer Global
secondary_engine_cost_threshold Numeric Session
select_into_buffer_size Integer Both
select_into_disk_sync Boolean Both
select_into_disk_sync_delay Integer Both
server_id Integer Global
session_track_gtids Enumeration Both
session_track_schema Boolean Both
session_track_state_change Boolean Both
session_track_system_variables String Both
session_track_transaction_info Enumeration Both
sha256_password_proxy_users Boolean Global
show_create_table_skip_secondary_engine Boolean Session
show_create_table_verbosity Boolean Both
show_gipk_in_create_table_and_information_schema Boolean Both
show_old_temporals Boolean Both
slave_allow_batching Boolean Global
slave_checkpoint_group Integer Global
slave_checkpoint_period Integer Global
slave_compressed_protocol Boolean Global
slave_exec_mode Enumeration Global
slave_max_allowed_packet Integer Global
slave_net_timeout Integer Global
slave_parallel_type Enumeration Global
slave_parallel_workers Integer Global
slave_pending_jobs_size_max Integer Global
slave_preserve_commit_order Boolean Global
slave_rows_search_algorithms Set Global
slave_sql_verify_checksum Boolean Global
slave_transaction_retries Integer Global
slave_type_conversions Set Global
slow_launch_time Integer Global
slow_query_log Boolean Global
slow_query_log_file File name Global
sort_buffer_size Integer Both
source_verify_checksum Boolean Global
sql_auto_is_null Boolean Both
sql_big_selects Boolean Both
sql_buffer_result Boolean Both
sql_generate_invisible_primary_key Boolean Both
sql_log_bin Boolean Session
sql_log_off Boolean Both
sql_mode Set Both
sql_notes Boolean Both
sql_quote_show_create Boolean Both
sql_replica_skip_counter Integer Global
sql_require_primary_key Boolean Both
sql_safe_updates Boolean Both
sql_select_limit Integer Both
sql_slave_skip_counter Integer Global
sql_warnings Boolean Both
ssl_ca File name Global
ssl_capath Directory name Global
ssl_cert File name Global
ssl_cipher String Global
ssl_crl File name Global
ssl_crlpath Directory name Global
ssl_key File name Global
ssl_session_cache_mode Boolean Global
ssl_session_cache_timeout Integer Global
stored_program_cache Integer Global
stored_program_definition_cache Integer Global
super_read_only Boolean Global
sync_binlog Integer Global
sync_master_info Integer Global
sync_relay_log Integer Global
sync_relay_log_info Integer Global
sync_source_info Integer Global
syseventlog.facility String Global
syseventlog.include_pid Boolean Global
syseventlog.tag String Global
table_definition_cache Integer Global
table_encryption_privilege_check Boolean Global
table_open_cache Integer Global
tablespace_definition_cache Integer Global
temptable_max_mmap Integer Global
temptable_max_ram Integer Global
temptable_use_mmap Boolean Global
terminology_use_previous Enumeration Both
thread_cache_size Integer Global
thread_pool_high_priority_connection Integer Both
thread_pool_max_active_query_threads Integer Global
thread_pool_max_transactions_limit Integer Global
thread_pool_max_unused_threads Integer Global
thread_pool_prio_kickup_timer Integer Global
thread_pool_query_threads_per_group Integer Global
thread_pool_stall_limit Integer Global
thread_pool_transaction_delay Integer Global
time_zone String Both
timestamp Numeric Session
tls_ciphersuites String Global
tls_version String Global
tmp_table_size Integer Both
transaction_alloc_block_size Integer Both
transaction_allow_batching Boolean Session
transaction_isolation Enumeration Both
transaction_prealloc_size Integer Both
transaction_read_only Boolean Both
transaction_write_set_extraction Enumeration Both
unique_checks Boolean Both
updatable_views_with_limit Boolean Both
use_secondary_engine Enumeration Session
validate_password_check_user_name Boolean Global
validate_password_dictionary_file File name Global
validate_password_length Integer Global
validate_password_mixed_case_count Integer Global
validate_password_number_count Integer Global
validate_password_policy Enumeration Global
validate_password_special_char_count Integer Global
validate_password.changed_characters_percentage Integer Global
validate_password.check_user_name Boolean Global
validate_password.dictionary_file File name Global
validate_password.length Integer Global
validate_password.mixed_case_count Integer Global
validate_password.number_count Integer Global
validate_password.policy Enumeration Global
validate_password.special_char_count Integer Global
version_tokens_session String Both
wait_timeout Integer Both
windowing_use_high_precision Boolean Both
xa_detach_on_prepare Boolean Both