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.

VariableSupported
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❌