System Variables
Last updated
Was this helpful?
Last updated
Was this helpful?
Dolt supports a subset of system variables MySQL supports. System Variables are added upon request, so please if a variable you need is missing. Some system variables parse but make no change to the operation of Dolt (ie. a no-op). This is generally done to make mysqldump
files import into Dolt with no errors.
Currently supporting 338 of 1029 MySQL System Variables.
activate_all_roles_on_login
β
admin_address
β
admin_port
β
admin_ssl_ca
β
admin_ssl_capath
β
admin_ssl_cert
β
admin_ssl_cipher
β
admin_ssl_crl
β
admin_ssl_crlpath
β
admin_ssl_key
β
admin_tls_ciphersuites
β
admin_tls_version
β
audit_log_buffer_size
β
audit_log_compression
β
audit_log_connection_policy
β
audit_log_current_session
β
audit_log_database
β
audit_log_disable
β
audit_log_encryption
β
audit_log_exclude_accounts
β
audit_log_file
β
audit_log_filter_id
β
audit_log_flush
β
audit_log_flush_interval_seconds
β
audit_log_format
β
audit_log_format_unix_timestamp
β
audit_log_include_accounts
β
audit_log_max_size
β
audit_log_password_history_keep_days
β
audit_log_policy
β
audit_log_prune_seconds
β
audit_log_read_buffer_size
β
audit_log_rotate_on_size
β
audit_log_statement_policy
β
audit_log_strategy
β
authentication_kerberos_service_key_tab
β
authentication_kerberos_service_principal
β
authentication_ldap_sasl_auth_method_name
β
authentication_ldap_sasl_bind_base_dn
β
authentication_ldap_sasl_bind_root_dn
β
authentication_ldap_sasl_bind_root_pwd
β
authentication_ldap_sasl_ca_path
β
authentication_ldap_sasl_connect_timeout
β
authentication_ldap_sasl_group_search_attr
β
authentication_ldap_sasl_group_search_filter
β
authentication_ldap_sasl_init_pool_size
β
authentication_ldap_sasl_log_status
β
authentication_ldap_sasl_max_pool_size
β
authentication_ldap_sasl_referral
β
authentication_ldap_sasl_response_timeout
β
authentication_ldap_sasl_server_host
β
authentication_ldap_sasl_server_port
β
authentication_ldap_sasl_tls
β
authentication_ldap_sasl_user_search_attr
β
authentication_ldap_simple_auth_method_name
β
authentication_ldap_simple_bind_base_dn
β
authentication_ldap_simple_bind_root_dn
β
authentication_ldap_simple_bind_root_pwd
β
authentication_ldap_simple_ca_path
β
authentication_ldap_simple_connect_timeout
β
authentication_ldap_simple_group_search_attr
β
authentication_ldap_simple_group_search_filter
β
authentication_ldap_simple_init_pool_size
β
authentication_ldap_simple_log_status
β
authentication_ldap_simple_max_pool_size
β
authentication_ldap_simple_referral
β
authentication_ldap_simple_response_timeout
β
authentication_ldap_simple_server_host
β
authentication_ldap_simple_server_port
β
authentication_ldap_simple_tls
β
authentication_ldap_simple_user_search_attr
β
authentication_policy
β
authentication_webauthn_rp_id
β
authentication_windows_log_level
β
authentication_windows_use_principal_name
β
auto_generate_certs
β
auto_increment_increment
β
auto_increment_offset
β
autocommit
β
automatic_sp_privileges
β
avoid_temporal_upgrade
β
back_log
β
basedir
β
big_tables
β
bind_address
β
binlog_cache_size
β
binlog_checksum
β
binlog_direct_non_transactional_updates
β
binlog_encryption
β
binlog_error_action
β
binlog_expire_logs_auto_purge
β
binlog_expire_logs_seconds
β
binlog_format
β
binlog_group_commit_sync_delay
β
binlog_group_commit_sync_no_delay_count
β
binlog_gtid_simple_recovery
β
binlog_max_flush_queue_time
β
binlog_order_commits
β
binlog_rotate_encryption_master_key_at_startup
β
binlog_row_event_max_size
β
binlog_row_image
β
binlog_row_metadata
β
binlog_row_value_options
β
binlog_rows_query_log_events
β
binlog_stmt_cache_size
β
binlog_transaction_compression
β
binlog_transaction_compression_level_zstd
β
binlog_transaction_dependency_history_size
β
block_encryption_mode
β
build_id
β
bulk_insert_buffer_size
β
caching_sha2_password_auto_generate_rsa_keys
β
caching_sha2_password_digest_rounds
β
caching_sha2_password_private_key_path
β
caching_sha2_password_public_key_path
β
character_set_client
β
character_set_connection
β
character_set_database
β
character_set_filesystem
β
character_set_results
β
character_set_server
β
character_set_system
β
character_sets_dir
β
check_proxy_users
β
clone_autotune_concurrency
β
clone_block_ddl
β
clone_buffer_size
β
clone_ddl_timeout
β
clone_delay_after_data_drop
β
clone_donor_timeout_after_network_failure
β
clone_enable_compression
β
clone_max_concurrency
β
clone_max_data_bandwidth
β
clone_max_network_bandwidth
β
clone_ssl_ca
β
clone_ssl_cert
β
clone_ssl_key
β
clone_valid_donor_list
β
collation_connection
β
collation_database
β
collation_server
β
completion_type
β
component_masking.dictionaries_flush_interval_seconds
β
component_masking.masking_database
β
component_scheduler.enabled
β
concurrent_insert
β
connect_timeout
β
connection_control_failed_connections_threshold
β
connection_control_max_connection_delay
β
connection_control_min_connection_delay
β
connection_memory_chunk_size
β
connection_memory_limit
β
core_file
β
create_admin_listener_thread
β
cte_max_recursion_depth
β
datadir
β
debug
β
debug_sync
β
default_authentication_plugin
β
default_collation_for_utf8mb4
β
default_password_lifetime
β
default_storage_engine
β
default_table_encryption
β
default_tmp_storage_engine
β
default_week_format
β
delay_key_write
β
delayed_insert_limit
β
delayed_insert_timeout
β
delayed_queue_size
β
disabled_storage_engines
β
disconnect_on_expired_password
β
div_precision_increment
β
dragnet.log_error_filter_rules
β
end_markers_in_json
β
enforce_gtid_consistency
β
enterprise_encryption.maximum_rsa_key_size
β
enterprise_encryption.rsa_support_legacy_padding
β
eq_range_index_dive_limit
β
error_count
β
event_scheduler
β
explain_format
β
explain_json_format_version
β
explicit_defaults_for_timestamp
β
external_user
β
flush
β
flush_time
β
foreign_key_checks
β
ft_boolean_syntax
β
ft_max_word_len
β
ft_min_word_len
β
ft_query_expansion_limit
β
ft_stopword_file
β
general_log
β
general_log_file
β
generated_random_password_length
β
global_connection_memory_limit
β
global_connection_memory_tracking
β
group_concat_max_len
β
group_replication_advertise_recovery_endpoints
β
group_replication_allow_local_lower_version_join
β
group_replication_auto_increment_increment
β
group_replication_autorejoin_tries
β
group_replication_bootstrap_group
β
group_replication_clone_threshold
β
group_replication_communication_debug_options
β
group_replication_communication_max_message_size
β
group_replication_communication_stack
β
group_replication_components_stop_timeout
β
group_replication_compression_threshold
β
group_replication_consistency
β
group_replication_enforce_update_everywhere_checks
β
group_replication_exit_state_action
β
group_replication_flow_control_applier_threshold
β
group_replication_flow_control_certifier_threshold
β
group_replication_flow_control_hold_percent
β
group_replication_flow_control_max_quota
β
group_replication_flow_control_member_quota_percent
β
group_replication_flow_control_min_quota
β
group_replication_flow_control_min_recovery_quota
β
group_replication_flow_control_mode
β
group_replication_flow_control_period
β
group_replication_flow_control_release_percent
β
group_replication_force_members
β
group_replication_group_name
β
group_replication_group_seeds
β
group_replication_gtid_assignment_block_size
β
group_replication_ip_allowlist
β
group_replication_local_address
β
group_replication_member_expel_timeout
β
group_replication_member_weight
β
group_replication_message_cache_size
β
group_replication_paxos_single_leader
β
group_replication_poll_spin_loops
β
group_replication_preemptive_garbage_collection
β
group_replication_preemptive_garbage_collection_rows_threshold
β
group_replication_recovery_compression_algorithms
β
group_replication_recovery_get_public_key
β
group_replication_recovery_public_key_path
β
group_replication_recovery_reconnect_interval
β
group_replication_recovery_retry_count
β
group_replication_recovery_ssl_ca
β
group_replication_recovery_ssl_capath
β
group_replication_recovery_ssl_cert
β
group_replication_recovery_ssl_cipher
β
group_replication_recovery_ssl_crl
β
group_replication_recovery_ssl_crlpath
β
group_replication_recovery_ssl_key
β
group_replication_recovery_ssl_verify_server_cert
β
group_replication_recovery_tls_ciphersuites
β
group_replication_recovery_tls_version
β
group_replication_recovery_use_ssl
β
group_replication_recovery_zstd_compression_level
β
group_replication_single_primary_mode
β
group_replication_ssl_mode
β
group_replication_start_on_boot
β
group_replication_tls_source
β
group_replication_transaction_size_limit
β
group_replication_unreachable_majority_timeout
β
group_replication_view_change_uuid
β
gtid_executed
β
gtid_executed_compression_period
β
gtid_mode
β
gtid_next
β
gtid_owned
β
gtid_purged
β
have_compress
β
have_dynamic_loading
β
have_geometry
β
have_profiling
β
have_query_cache
β
have_rtree_keys
β
have_statement_timeout
β
have_symlink
β
histogram_generation_max_mem_size
β
host_cache_size
β
hostname
β
identity
β
immediate_server_version
β
information_schema_stats_expiry
β
init_connect
β
init_file
β
init_replica
β
init_slave
β
inmemory_joins
β
innodb_adaptive_flushing
β
innodb_adaptive_flushing_lwm
β
innodb_adaptive_hash_index
β
innodb_adaptive_hash_index_parts
β
innodb_adaptive_max_sleep_delay
β
innodb_autoextend_increment
β
innodb_autoinc_lock_mode
β
innodb_background_drop_list_empty
β
innodb_buffer_pool_chunk_size
β
innodb_buffer_pool_debug
β
innodb_buffer_pool_dump_at_shutdown
β
innodb_buffer_pool_dump_now
β
innodb_buffer_pool_dump_pct
β
innodb_buffer_pool_filename
β
innodb_buffer_pool_in_core_file
β
innodb_buffer_pool_instances
β
innodb_buffer_pool_load_abort
β
innodb_buffer_pool_load_at_startup
β
innodb_buffer_pool_load_now
β
innodb_buffer_pool_size
β
innodb_change_buffer_max_size
β
innodb_change_buffering
β
innodb_change_buffering_debug
β
innodb_checkpoint_disabled
β
innodb_checksum_algorithm
β
innodb_cmp_per_index_enabled
β
innodb_commit_concurrency
β
innodb_compress_debug
β
innodb_compression_failure_threshold_pct
β
innodb_compression_level
β
innodb_compression_pad_pct_max
β
innodb_concurrency_tickets
β
innodb_data_file_path
β
innodb_data_home_dir
β
innodb_ddl_buffer_size
β
innodb_ddl_log_crash_reset_debug
β
innodb_ddl_threads
β
innodb_deadlock_detect
β
innodb_dedicated_server
β
innodb_default_row_format
β
innodb_directories
β
innodb_disable_sort_file_cache
β
innodb_doublewrite
β
innodb_doublewrite_batch_size
β
innodb_doublewrite_dir
β
innodb_doublewrite_files
β
innodb_doublewrite_pages
β
innodb_extend_and_initialize
β
innodb_fast_shutdown
β
innodb_fil_make_page_dirty_debug
β
innodb_file_per_table
β
innodb_fill_factor
β
innodb_flush_log_at_timeout
β
innodb_flush_log_at_trx_commit
β
innodb_flush_method
β
innodb_flush_neighbors
β
innodb_flush_sync
β
innodb_flushing_avg_loops
β
innodb_force_load_corrupted
β
innodb_force_recovery
β
innodb_fsync_threshold
β
innodb_ft_aux_table
β
innodb_ft_cache_size
β
innodb_ft_enable_diag_print
β
innodb_ft_enable_stopword
β
innodb_ft_max_token_size
β
innodb_ft_min_token_size
β
innodb_ft_num_word_optimize
β
innodb_ft_result_cache_limit
β
innodb_ft_server_stopword_table
β
innodb_ft_sort_pll_degree
β
innodb_ft_total_cache_size
β
innodb_ft_user_stopword_table
β
innodb_idle_flush_pct
β
innodb_io_capacity
β
innodb_io_capacity_max
β
innodb_limit_optimistic_insert_debug
β
innodb_lock_wait_timeout
β
innodb_log_buffer_size
β
innodb_log_checkpoint_fuzzy_now
β
innodb_log_checkpoint_now
β
innodb_log_checksums
β
innodb_log_compressed_pages
β
innodb_log_file_size
β
innodb_log_files_in_group
β
innodb_log_group_home_dir
β
innodb_log_spin_cpu_abs_lwm
β
innodb_log_spin_cpu_pct_hwm
β
innodb_log_wait_for_flush_spin_hwm
β
innodb_log_write_ahead_size
β
innodb_log_writer_threads
β
innodb_lru_scan_depth
β
innodb_max_dirty_pages_pct
β
innodb_max_dirty_pages_pct_lwm
β
innodb_max_purge_lag
β
innodb_max_purge_lag_delay
β
innodb_max_undo_log_size
β
innodb_merge_threshold_set_all_debug
β
innodb_monitor_disable
β
innodb_monitor_enable
β
innodb_monitor_reset
β
innodb_monitor_reset_all
β
innodb_numa_interleave
β
innodb_old_blocks_pct
β
innodb_old_blocks_time
β
innodb_online_alter_log_max_size
β
innodb_open_files
β
innodb_optimize_fulltext_only
β
innodb_page_cleaners
β
innodb_page_size
β
innodb_parallel_read_threads
β
innodb_print_all_deadlocks
β
innodb_print_ddl_logs
β
innodb_purge_batch_size
β
innodb_purge_rseg_truncate_frequency
β
innodb_purge_threads
β
innodb_random_read_ahead
β
innodb_read_ahead_threshold
β
innodb_read_io_threads
β
innodb_read_only
β
innodb_redo_log_archive_dirs
β
innodb_redo_log_capacity
β
innodb_redo_log_encrypt
β
innodb_replication_delay
β
innodb_rollback_on_timeout
β
innodb_rollback_segments
β
innodb_saved_page_number_debug
β
innodb_segment_reserve_factor
β
innodb_sort_buffer_size
β
innodb_spin_wait_delay
β
innodb_spin_wait_pause_multiplier
β
innodb_stats_auto_recalc
β
innodb_stats_include_delete_marked
β
innodb_stats_method
β
innodb_stats_on_metadata
β
innodb_stats_persistent
β
innodb_stats_persistent_sample_pages
β
innodb_stats_transient_sample_pages
β
innodb_status_output
β
innodb_status_output_locks
β
innodb_strict_mode
β
innodb_sync_array_size
β
innodb_sync_debug
β
innodb_sync_spin_loops
β
innodb_table_locks
β
innodb_temp_data_file_path
β
innodb_temp_tablespaces_dir
β
innodb_thread_concurrency
β
innodb_thread_sleep_delay
β
innodb_tmpdir
β
innodb_trx_purge_view_update_only_debug
β
innodb_trx_rseg_n_slots_debug
β
innodb_undo_directory
β
innodb_undo_log_encrypt
β
innodb_undo_log_truncate
β
innodb_undo_tablespaces
β
innodb_use_fdatasync
β
innodb_use_native_aio
β
innodb_validate_tablespace_paths
β
innodb_version
β
innodb_write_io_threads
β
insert_id
β
interactive_timeout
β
internal_tmp_disk_storage_engine
β
internal_tmp_mem_storage_engine
β
join_buffer_size
β
join_complexity_limit
β
keep_files_on_create
β
key_buffer_size
β
key_cache_age_threshold
β
key_cache_block_size
β
key_cache_division_limit
β
keyring_aws_cmk_id
β
keyring_aws_conf_file
β
keyring_aws_data_file
β
keyring_aws_region
β
keyring_hashicorp_auth_path
β
keyring_hashicorp_ca_path
β
keyring_hashicorp_caching
β
keyring_hashicorp_commit_auth_path
β
keyring_hashicorp_commit_ca_path
β
keyring_hashicorp_commit_caching
β
keyring_hashicorp_commit_role_id
β
keyring_hashicorp_commit_server_url
β
keyring_hashicorp_commit_store_path
β
keyring_hashicorp_role_id
β
keyring_hashicorp_secret_id
β
keyring_hashicorp_server_url
β
keyring_hashicorp_store_path
β
keyring_okv_conf_dir
β
keyring_operations
β
large_files_support
β
large_page_size
β
large_pages
β
last_insert_id
β
lc_messages
β
lc_messages_dir
β
lc_time_names
β
license
β
local_infile
β
lock_order
β
lock_order_debug_loop
β
lock_order_debug_missing_arc
β
lock_order_debug_missing_key
β
lock_order_debug_missing_unlock
β
lock_order_dependencies
β
lock_order_extra_dependencies
β
lock_order_output_directory
β
lock_order_print_txt
β
lock_order_trace_loop
β
lock_order_trace_missing_arc
β
lock_order_trace_missing_key
β
lock_order_trace_missing_unlock
β
lock_wait_timeout
β
locked_in_memory
β
log_bin
β
log_bin_basename
β
log_bin_index
β
log_bin_trust_function_creators
β
log_error
β
log_error_services
β
log_error_suppression_list
β
log_error_verbosity
β
log_output
β
log_queries_not_using_indexes
β
log_raw
β
log_replica_updates
β
log_slave_updates
β
log_slow_admin_statements
β
log_slow_extra
β
log_slow_replica_statements
β
log_slow_slave_statements
β
log_statements_unsafe_for_binlog
β
log_syslog
β
log_syslog_facility
β
log_syslog_include_pid
β
log_syslog_tag
β
log_throttle_queries_not_using_indexes
β
log_timestamps
β
long_query_time
β
low_priority_updates
β
lower_case_file_system
β
lower_case_table_names
β
mandatory_roles
β
master_verify_checksum
β
max_allowed_packet
β
max_binlog_cache_size
β
max_binlog_size
β
max_binlog_stmt_cache_size
β
max_connect_errors
β
max_connections
β
max_delayed_threads
β
max_digest_length
β
max_error_count
β
max_execution_time
β
max_heap_table_size
β
max_insert_delayed_threads
β
max_join_size
β
max_length_for_sort_data
β
max_points_in_geometry
β
max_prepared_stmt_count
β
max_relay_log_size
β
max_seeks_for_key
β
max_sort_length
β
max_sp_recursion_depth
β
max_user_connections
β
max_write_lock_count
β
mecab_rc_file
β
metadata_locks_cache_size
β
metadata_locks_hash_instances
β
min_examined_row_limit
β
myisam_data_pointer_size
β
myisam_max_sort_file_size
β
myisam_mmap_size
β
myisam_recover_options
β
myisam_repair_threads
β
myisam_sort_buffer_size
β
myisam_stats_method
β
myisam_use_mmap
β
mysql_firewall_database
β
mysql_firewall_mode
β
mysql_firewall_reload_interval_seconds
β
mysql_firewall_trace
β
mysql_native_password_proxy_users
β
mysqlx_bind_address
β
mysqlx_compression_algorithms
β
mysqlx_connect_timeout
β
mysqlx_deflate_default_compression_level
β
mysqlx_deflate_max_client_compression_level
β
mysqlx_document_id_unique_prefix
β
mysqlx_enable_hello_notice
β
mysqlx_idle_worker_thread_timeout
β
mysqlx_interactive_timeout
β
mysqlx_lz4_default_compression_level
β
mysqlx_lz4_max_client_compression_level
β
mysqlx_max_allowed_packet
β
mysqlx_max_connections
β
mysqlx_min_worker_threads
β
mysqlx_port
β
mysqlx_port_open_timeout
β
mysqlx_read_timeout
β
mysqlx_socket
β
mysqlx_ssl_ca
β
mysqlx_ssl_capath
β
mysqlx_ssl_cert
β
mysqlx_ssl_cipher
β
mysqlx_ssl_crl
β
mysqlx_ssl_crlpath
β
mysqlx_ssl_key
β
mysqlx_wait_timeout
β
mysqlx_write_timeout
β
mysqlx_zstd_default_compression_level
β
mysqlx_zstd_max_client_compression_level
β
named_pipe
β
named_pipe_full_access_group
β
ndb_allow_copying_alter_table
β
ndb_applier_allow_skip_epoch
β
ndb_autoincrement_prefetch_sz
β
ndb_batch_size
β
ndb_blob_read_batch_bytes
β
ndb_blob_write_batch_bytes
β
ndb_clear_apply_status
β
ndb_cluster_connection_pool
β
ndb_cluster_connection_pool_nodeids
β
ndb_conflict_role
β
ndb_data_node_neighbour
β
ndb_dbg_check_shares
β
ndb_default_column_format
β
ndb_deferred_constraints
β
ndb_distribution
β
ndb_eventbuffer_free_percent
β
ndb_eventbuffer_max_alloc
β
ndb_extra_logging
β
ndb_force_send
β
ndb_fully_replicated
β
ndb_index_stat_enable
β
ndb_index_stat_option
β
ndb_join_pushdown
β
ndb_log_apply_status
β
ndb_log_bin
β
ndb_log_binlog_index
β
ndb_log_cache_size
β
ndb_log_empty_epochs
β
ndb_log_empty_update
β
ndb_log_exclusive_reads
β
ndb_log_fail_terminate
β
ndb_log_orig
β
ndb_log_transaction_compression
β
ndb_log_transaction_compression_level_zstd
β
ndb_log_transaction_dependency
β
ndb_log_transaction_id
β
ndb_log_update_as_write
β
ndb_log_update_minimal
β
ndb_log_updated_only
β
ndb_metadata_check
β
ndb_metadata_check_interval
β
ndb_metadata_sync
β
ndb_mgm_tls
β
ndb_optimization_delay
β
ndb_optimized_node_selection
β
ndb_read_backup
β
ndb_recv_thread_activation_threshold
β
ndb_recv_thread_cpu_mask
β
ndb_replica_batch_size
β
ndb_replica_blob_write_batch_bytes
β
ndb_report_thresh_binlog_epoch_slip
β
ndb_report_thresh_binlog_mem_usage
β
ndb_row_checksum
β
ndb_schema_dist_lock_wait_timeout
β
ndb_schema_dist_timeout
β
ndb_schema_dist_upgrade_allowed
β
ndb_show_foreign_key_mock_tables
β
ndb_slave_conflict_role
β
ndb_table_no_logging
β
ndb_table_temporary
β
ndb_tls_search_path
β
ndb_use_copying_alter_table
β
ndb_use_exact_count
β
ndb_use_transactions
β
ndb_version
β
ndb_version_string
β
ndb_wait_connected
β
ndb_wait_setup
β
ndbinfo_database
β
ndbinfo_max_bytes
β
ndbinfo_max_rows
β
ndbinfo_offline
β
ndbinfo_show_hidden
β
ndbinfo_table_prefix
β
ndbinfo_version
β
Ndb_replica_max_replicated_epoch
β
Ndb_system_name
β
net_buffer_length
β
net_read_timeout
β
net_retry_count
β
net_write_timeout
β
new
β
ngram_token_size
β
offline_mode
β
old
β
old_alter_table
β
open_files_limit
β
optimizer_prune_level
β
optimizer_search_depth
β
optimizer_switch
β
optimizer_trace
β
optimizer_trace_features
β
optimizer_trace_limit
β
optimizer_trace_max_mem_size
β
optimizer_trace_offset
β
original_commit_timestamp
β
original_server_version
β
parser_max_mem_size
β
partial_revokes
β
password_history
β
password_require_current
β
password_reuse_interval
β
performance_schema
β
performance_schema_accounts_size
β
performance_schema_digests_size
β
performance_schema_error_size
β
performance_schema_events_stages_history_long_size
β
performance_schema_events_stages_history_size
β
performance_schema_events_statements_history_long_size
β
performance_schema_events_statements_history_size
β
performance_schema_events_transactions_history_long_size
β
performance_schema_events_transactions_history_size
β
performance_schema_events_waits_history_long_size
β
performance_schema_events_waits_history_size
β
performance_schema_hosts_size
β
performance_schema_max_cond_classes
β
performance_schema_max_cond_instances
β
performance_schema_max_digest_length
β
performance_schema_max_digest_sample_age
β
performance_schema_max_file_classes
β
performance_schema_max_file_handles
β
performance_schema_max_file_instances
β
performance_schema_max_index_stat
β
performance_schema_max_memory_classes
β
performance_schema_max_metadata_locks
β
performance_schema_max_meter_classes
β
performance_schema_max_metric_classes
β
performance_schema_max_mutex_classes
β
performance_schema_max_mutex_instances
β
performance_schema_max_prepared_statements_instances
β
performance_schema_max_program_instances
β
performance_schema_max_rwlock_classes
β
performance_schema_max_rwlock_instances
β
performance_schema_max_socket_classes
β
performance_schema_max_socket_instances
β
performance_schema_max_sql_text_length
β
performance_schema_max_stage_classes
β
performance_schema_max_statement_classes
β
performance_schema_max_statement_stack
β
performance_schema_max_table_handles
β
performance_schema_max_table_instances
β
performance_schema_max_table_lock_stat
β
performance_schema_max_thread_classes
β
performance_schema_max_thread_instances
β
performance_schema_session_connect_attrs_size
β
performance_schema_setup_actors_size
β
performance_schema_setup_objects_size
β
performance_schema_show_processlist
β
performance_schema_users_size
β
persist_only_admin_x509_subject
β
persist_sensitive_variables_in_plaintext
β
persisted_globals_load
β
pid_file
β
plugin_dir
β
port
β
preload_buffer_size
β
print_identified_with_as_hex
β
profiling
β
profiling_history_size
β
protocol_compression_algorithms
β
protocol_version
β
proxy_user
β
pseudo_replica_mode
β
pseudo_slave_mode
β
pseudo_thread_id
β
query_alloc_block_size
β
query_cache_size
β
query_cache_type
β
query_prealloc_size
β
rand_seed1
β
rand_seed2
β
range_alloc_block_size
β
range_optimizer_max_mem_size
β
rbr_exec_mode
β
read_buffer_size
β
read_only
β
read_rnd_buffer_size
β
regexp_buffer_size
β
regexp_stack_limit
β
regexp_time_limit
β
relay_log
β
relay_log_basename
β
relay_log_index
β
relay_log_purge
β
relay_log_recovery
β
relay_log_space_limit
β
replica_allow_batching
β
replica_checkpoint_group
β
replica_checkpoint_period
β
replica_compressed_protocol
β
replica_exec_mode
β
replica_load_tmpdir
β
replica_max_allowed_packet
β
replica_net_timeout
β
replica_parallel_type
β
replica_parallel_workers
β
replica_pending_jobs_size_max
β
replica_preserve_commit_order
β
replica_skip_errors
β
replica_sql_verify_checksum
β
replica_transaction_retries
β
replica_type_conversions
β
replication_optimize_for_static_plugin_config
β
replication_sender_observe_commit_only
β
report_host
β
report_password
β
report_port
β
report_user
β
require_row_format
β
require_secure_transport
β
restrict_fk_on_non_standard_key
β
resultset_metadata
β
rewriter_enabled
β
rewriter_enabled_for_threads_without_privilege_checks
β
rewriter_verbose
β
rpl_read_size
β
rpl_semi_sync_master_enabled
β
rpl_semi_sync_master_timeout
β
rpl_semi_sync_master_trace_level
β
rpl_semi_sync_master_wait_for_slave_count
β
rpl_semi_sync_master_wait_no_slave
β
rpl_semi_sync_master_wait_point
β
rpl_semi_sync_replica_enabled
β
rpl_semi_sync_replica_trace_level
β
rpl_semi_sync_slave_enabled
β
rpl_semi_sync_slave_trace_level
β
rpl_semi_sync_source_enabled
β
rpl_semi_sync_source_timeout
β
rpl_semi_sync_source_trace_level
β
rpl_semi_sync_source_wait_for_replica_count
β
rpl_semi_sync_source_wait_no_replica
β
rpl_semi_sync_source_wait_point
β
rpl_stop_replica_timeout
β
rpl_stop_slave_timeout
β
schema_definition_cache
β
secondary_engine_cost_threshold
β
secure_file_priv
β
select_into_buffer_size
β
select_into_disk_sync
β
select_into_disk_sync_delay
β
server_id
β
server_id_bits
β
server_uuid
β
session_track_gtids
β
session_track_schema
β
session_track_state_change
β
session_track_system_variables
β
session_track_transaction_info
β
set_operations_buffer_size
β
sha256_password_auto_generate_rsa_keys
β
sha256_password_private_key_path
β
sha256_password_proxy_users
β
sha256_password_public_key_path
β
shared_memory
β
shared_memory_base_name
β
show_create_table_skip_secondary_engine
β
show_create_table_verbosity
β
show_external_procedures
β
show_gipk_in_create_table_and_information_schema
β
show_old_temporals
β
skip_external_locking
β
skip_name_resolve
β
skip_networking
β
skip_replica_start
β
skip_show_database
β
skip_slave_start
β
slave_allow_batching
β
slave_checkpoint_group
β
slave_checkpoint_period
β
slave_compressed_protocol
β
slave_exec_mode
β
slave_load_tmpdir
β
slave_max_allowed_packet
β
slave_net_timeout
β
slave_parallel_type
β
slave_parallel_workers
β
slave_pending_jobs_size_max
β
slave_preserve_commit_order
β
slave_skip_errors
β
slave_sql_verify_checksum
β
slave_transaction_retries
β
slave_type_conversions
β
slow_launch_time
β
slow_query_log
β
slow_query_log_file
β
socket
β
sort_buffer_size
β
source_verify_checksum
β
sql_auto_is_null
β
sql_big_selects
β
sql_buffer_result
β
sql_generate_invisible_primary_key
β
sql_log_bin
β
sql_log_off
β
sql_mode
β
sql_notes
β
sql_quote_show_create
β
sql_replica_skip_counter
β
sql_require_primary_key
β
sql_safe_updates
β
sql_select_limit
β
sql_slave_skip_counter
β
sql_warnings
β
ssl_ca
β
ssl_capath
β
ssl_cert
β
ssl_cipher
β
ssl_crl
β
ssl_crlpath
β
ssl_fips_mode
β
ssl_key
β
ssl_session_cache_mode
β
ssl_session_cache_timeout
β
statement_id
β
stored_program_cache
β
stored_program_definition_cache
β
strict_mysql_compatibility
β
super_read_only
β
sync_binlog
β
sync_master_info
β
sync_relay_log
β
sync_relay_log_info
β
sync_source_info
β
syseventlog.facility
β
syseventlog.include_pid
β
syseventlog.tag
β
system_time_zone
β
table_definition_cache
β
table_encryption_privilege_check
β
table_open_cache
β
table_open_cache_instances
β
tablespace_definition_cache
β
telemetry.metrics_reader_frequency_1
β
telemetry.metrics_reader_frequency_2
β
telemetry.metrics_reader_frequency_3
β
telemetry.otel_bsp_max_export_batch_size
β
telemetry.otel_bsp_max_queue_size
β
telemetry.otel_bsp_schedule_delay
β
telemetry.otel_exporter_otlp_metrics_certificates
β
telemetry.otel_exporter_otlp_metrics_cipher
β
telemetry.otel_exporter_otlp_metrics_cipher_suite
β
telemetry.otel_exporter_otlp_metrics_client_certificates
β
telemetry.otel_exporter_otlp_metrics_client_key
β
telemetry.otel_exporter_otlp_metrics_compression
β
telemetry.otel_exporter_otlp_metrics_endpoint
β
telemetry.otel_exporter_otlp_metrics_headers
β
telemetry.otel_exporter_otlp_metrics_max_tls
β
telemetry.otel_exporter_otlp_metrics_min_tls
β
telemetry.otel_exporter_otlp_metrics_protocol
β
telemetry.otel_exporter_otlp_metrics_timeout
β
telemetry.otel_exporter_otlp_traces_certificates
β
telemetry.otel_exporter_otlp_traces_cipher
β
telemetry.otel_exporter_otlp_traces_cipher_suite
β
telemetry.otel_exporter_otlp_traces_client_certificates
β
telemetry.otel_exporter_otlp_traces_client_key
β
telemetry.otel_exporter_otlp_traces_compression
β
telemetry.otel_exporter_otlp_traces_endpoint
β
telemetry.otel_exporter_otlp_traces_headers
β
telemetry.otel_exporter_otlp_traces_max_tls
β
telemetry.otel_exporter_otlp_traces_min_tls
β
telemetry.otel_exporter_otlp_traces_protocol
β
telemetry.otel_exporter_otlp_traces_timeout
β
telemetry.otel_log_level
β
telemetry.otel_resource_attributes
β
telemetry.query_text_enabled
β
telemetry.trace_enabled
β
temptable_max_mmap
β
temptable_max_ram
β
temptable_use_mmap
β
terminology_use_previous
β
thread_cache_size
β
thread_handling
β
thread_pool_algorithm
β
thread_pool_dedicated_listeners
β
thread_pool_high_priority_connection
β
thread_pool_longrun_trx_limit
β
thread_pool_max_active_query_threads
β
thread_pool_max_transactions_limit
β
thread_pool_max_unused_threads
β
thread_pool_prio_kickup_timer
β
thread_pool_query_threads_per_group
β
thread_pool_size
β
thread_pool_stall_limit
β
thread_pool_transaction_delay
β
thread_stack
β
time_zone
β
timestamp
β
tls_certificates_enforced_validation
β
tls_ciphersuites
β
tls_version
β
tmp_table_size
β
tmpdir
β
transaction_alloc_block_size
β
transaction_allow_batching
β
transaction_isolation
β
transaction_prealloc_size
β
transaction_read_only
β
tx_isolation
β
tx_read_only
β
unique_checks
β
updatable_views_with_limit
β
uptime
β
use_secondary_engine
β
validate_password.changed_characters_percentage
β
validate_password.check_user_name
β
validate_password.dictionary_file
β
validate_password.length
β
validate_password.mixed_case_count
β
validate_password.number_count
β
validate_password.policy
β
validate_password.special_char_count
β
validate_password_check_user_name
β
validate_password_dictionary_file
β
validate_password_length
β
validate_password_mixed_case_count
β
validate_password_number_count
β
validate_password_policy
β
validate_password_special_char_count
β
validate_user_plugins
β
version
β
version_comment
β
version_compile_machine
β
version_compile_os
β
version_compile_zlib
β
version_tokens_session
β
version_tokens_session_number
β
wait_timeout
β
warning_count
β
windowing_use_high_precision
β
xa_detach_on_prepare
β