System Variables
Dolt supports a subset of system variables MySQL supports. System Variables are added upon request, so please file an issue 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
❌
Last updated