MySQL Server Version Reference  /  mysqld Option/Variable Reference

Chapter 1 mysqld Option/Variable Reference

Table of Contents

1.1 Option/Variable Changes for mysqld 5.6
1.2 Option/Variable Changes for mysqld 5.7
1.3 Option/Variable Changes for mysqld 8.0

The following table shows all the options and variables available across MySQL Server 5.6 through 8.0. The table contains these columns:

  • Name: The name of the option or variable.

  • Intr: The version or versions in which the option or variable was introduced.

  • Depr: The version or versions in which the option or variable was deprecated.

  • Rem: The version or versions in which the option or variable was removed.

  • Cmd: Whether the option or variable is valid on the command line.

  • Cnf: Whether the option is valid within a configuration file.

  • Srvr: Whether the variable is a server system variable.

  • Stat: Whether the variable is a status variable.

  • Scp: The scope of the variable (session-specific, global, or both). A value of Varies indicates that the scope varies across versions.

  • Dyn: Whether the variable is dynamically settable while the server is running. A value of Varies indicates that this attribute varies across versions.

  • 5.6, 5.7, and so forth: Whether the option or variable is available in each MySQL Server series. If more information is available in the main reference manual, the indication is a link to the correct part of the manual.

Table 1.1 Option/Variable Reference

Name Intr Depr Rem Cmd Cnf Srvr Stat Scope Dyn 5.6 5.7 8.0
abort-slave-event-count Yes Yes Yes Yes Yes
Aborted_clients Yes Global No Yes Yes Yes
Aborted_connects Yes Global No Yes Yes Yes
Acl_cache_items_count Yes Global No Yes
activate_all_roles_on_login 8.0.2 Yes Yes Yes Global Yes Yes
admin_address 8.0.14 Yes Yes Yes Global No Yes
admin_port 8.0.14 Yes Yes Yes Global No Yes
allow-suspicious-udfs Yes Yes Yes Yes Yes
ansi Yes Yes Yes Yes Yes
audit-log 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Yes Yes
audit_log_buffer_size 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Global No Yes Yes Yes
audit_log_compression 5.7.21, 8.0.11 Yes Yes Yes Global No Yes Yes
audit_log_connection_policy 5.6.20, 5.7.9, 8.0.11 Yes Yes Yes Global Yes Yes Yes Yes
audit_log_current_session 5.6.20, 5.7.9, 8.0.11 Yes Both No Yes Yes Yes
Audit_log_current_size 5.6.20, 5.7.9, 8.0.11 Yes Global No Yes Yes Yes
audit_log_encryption 5.7.21, 8.0.11 Yes Yes Yes Global No Yes Yes
Audit_log_event_max_drop_size 5.6.20, 5.7.9, 8.0.11 Yes Global No Yes Yes Yes
Audit_log_events 5.6.20, 5.7.9, 8.0.11 Yes Global No Yes Yes Yes
Audit_log_events_filtered 5.6.20, 5.7.9, 8.0.11 Yes Global No Yes Yes Yes
Audit_log_events_lost 5.6.20, 5.7.9, 8.0.11 Yes Global No Yes Yes Yes
Audit_log_events_written 5.6.20, 5.7.9, 8.0.11 Yes Global No Yes Yes Yes
audit_log_exclude_accounts 5.6.20, 5.7.9, 8.0.11 Yes Yes Yes Global Yes Yes Yes Yes
audit_log_file 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Global No Yes Yes Yes
audit_log_filter_id 5.7.13, 8.0.11 Yes Both No Yes Yes
audit_log_flush 5.6.10, 5.7.9, 8.0.11 Yes Global Yes Yes Yes Yes
audit_log_format 5.6.14, 5.7.9, 8.0.11 Yes Yes Yes Global No Yes Yes Yes
audit_log_include_accounts 5.6.20, 5.7.9, 8.0.11 Yes Yes Yes Global Yes Yes Yes Yes
audit_log_password_history_keep_days 8.0.17 Yes Yes Yes Global Yes Yes
audit_log_policy 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Global Varies Yes Yes Yes
audit_log_read_buffer_size 5.7.21, 8.0.11 Yes Yes Yes Varies Varies Yes Yes
audit_log_rotate_on_size 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Global Yes Yes Yes Yes
audit_log_statement_policy 5.6.20, 5.7.9, 8.0.11 Yes Yes Yes Global Yes Yes Yes Yes
audit_log_strategy 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Global No Yes Yes Yes
Audit_log_total_size 5.6.20, 5.7.9, 8.0.11 Yes Global No Yes Yes Yes
Audit_log_write_waits 5.6.20, 5.7.9, 8.0.11 Yes Global No Yes Yes Yes
authentication_ldap_sasl_auth_method_name 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_sasl_bind_base_dn 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_sasl_bind_root_dn 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_sasl_bind_root_pwd 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_sasl_ca_path 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_sasl_group_search_attr 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_sasl_group_search_filter 5.7.21, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_sasl_init_pool_size 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_sasl_log_status 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_sasl_max_pool_size 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_sasl_referral 8.0.20 Yes Yes Yes Global Yes Yes
authentication_ldap_sasl_server_host 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_sasl_server_port 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
Authentication_ldap_sasl_supported_methods 8.0.21 Yes Global No Yes
authentication_ldap_sasl_tls 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_sasl_user_search_attr 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_auth_method_name 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_bind_base_dn 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_bind_root_dn 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_bind_root_pwd 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_ca_path 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_group_search_attr 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_group_search_filter 5.7.21, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_init_pool_size 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_log_status 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_max_pool_size 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_referral 8.0.20 Yes Yes Yes Global Yes Yes
authentication_ldap_simple_server_host 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_server_port 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_tls 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_ldap_simple_user_search_attr 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
authentication_windows_log_level 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Global No Yes Yes Yes
authentication_windows_use_principal_name 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Global No Yes Yes Yes
auto_generate_certs 5.7.5 Yes Yes Yes Global No Yes Yes
auto_increment_increment Yes Yes Yes Both Yes Yes Yes Yes
auto_increment_offset Yes Yes Yes Both Yes Yes Yes Yes
autocommit Yes Yes Yes Both Yes Yes Yes Yes
automatic_sp_privileges Yes Yes Yes Global Yes Yes Yes Yes
avoid_temporal_upgrade 5.6.24, 5.7.6 5.6.24, 5.7.6 Yes Yes Yes Global Yes Yes Yes Yes
back_log Yes Yes Yes Global No Yes Yes Yes
basedir Yes Yes Yes Global No Yes Yes Yes
big_tables Yes Yes Yes Both Yes Yes Yes Yes
bind-address 5.6.1 Yes Yes Yes
bind_address 5.6.1 Yes Yes Yes Global No Yes Yes Yes
Binlog_cache_disk_use Yes Global No Yes Yes Yes
binlog_cache_size Yes Yes Yes Global Yes Yes Yes Yes
Binlog_cache_use Yes Global No Yes Yes Yes
binlog-checksum 5.6.2 Yes Yes Yes Yes Yes
binlog_checksum 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
binlog_direct_non_transactional_updates Yes Yes Yes Both Yes Yes Yes Yes
binlog-do-db Yes Yes Yes Yes Yes
binlog_encryption 8.0.14 Yes Yes Yes Global Yes Yes
binlog_error_action 5.6.22, 5.7.6 Yes Yes Yes Global Yes Yes Yes Yes
binlog_expire_logs_seconds 8.0.1 Yes Yes Yes Global Yes Yes
binlog_format Yes Yes Yes Both Yes Yes Yes Yes
binlog_group_commit_sync_delay 5.7.5 Yes Yes Yes Global Yes Yes Yes
binlog_group_commit_sync_no_delay_count 5.7.5 Yes Yes Yes Global Yes Yes Yes
binlog_gtid_simple_recovery 5.6.23, 5.7.6 Yes Yes Yes Global No Yes Yes Yes
binlog-ignore-db Yes Yes Yes Yes Yes
binlog_max_flush_queue_time 5.6.6 5.7.9 Yes Yes Yes Global Yes Yes Yes Yes
binlog_order_commits 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
binlog_rotate_encryption_master_key_at_startup 8.0.14 Yes Yes Yes Global No Yes
binlog-row-event-max-size Yes Yes Yes Global No Yes Yes Yes
binlog_row_image 5.6.2 Yes Yes Yes Both Yes Yes Yes Yes
binlog_row_metadata 8.0.1 Yes Yes Yes Global Yes Yes
binlog_row_value_options 8.0.3 Yes Yes Yes Both Yes Yes
binlog_rows_query_log_events 5.6.2 Yes Yes Yes Both Yes Yes Yes Yes
Binlog_stmt_cache_disk_use 5.6.1 Yes Global No Yes Yes Yes
binlog_stmt_cache_size 5.6.1 Yes Yes Yes Global Yes Yes Yes Yes
Binlog_stmt_cache_use 5.6.1 Yes Global No Yes Yes Yes
binlog_transaction_compression 8.0.20 Yes Yes Yes Global Yes Yes
binlog_transaction_compression_level_zstd 8.0.20 Yes Yes Yes Global Yes Yes
binlog_transaction_dependency_history_size 5.7.22, 8.0.1 Yes Yes Yes Global Yes Yes Yes
binlog_transaction_dependency_tracking 5.7.22, 8.0.1 Yes Yes Yes Global Yes Yes Yes
binlogging_impossible_mode 5.6.20, 5.7.5 5.6.22 5.7.6 Yes Yes Yes Both Yes Yes Yes
block_encryption_mode 5.6.17, 5.7.4 Yes Yes Yes Both Yes Yes Yes Yes
bootstrap 5.7.6 Yes Yes Yes Yes
bulk_insert_buffer_size Yes Yes Yes Both Yes Yes Yes Yes
Bytes_received Yes Both No Yes Yes Yes
Bytes_sent Yes Both No Yes Yes Yes
caching_sha2_password_auto_generate_rsa_keys 8.0.4 Yes Yes Yes Global No Yes
caching_sha2_password_private_key_path 8.0.3 Yes Yes Yes Global No Yes
caching_sha2_password_public_key_path 8.0.3 Yes Yes Yes Global No Yes
Caching_sha2_password_rsa_public_key 8.0.4 Yes Global No Yes
character_set_client Yes Both Yes Yes Yes Yes
character-set-client-handshake Yes Yes Yes Yes Yes
character_set_connection Yes Both Yes Yes Yes Yes
character_set_database Yes Both Yes Yes Yes Yes
character_set_filesystem Yes Yes Yes Both Yes Yes Yes Yes
character_set_results Yes Both Yes Yes Yes Yes
character_set_server Yes Yes Yes Both Yes Yes Yes Yes
character_set_system Yes Global No Yes Yes Yes
character_sets_dir Yes Yes Yes Global No Yes Yes Yes
check_proxy_users 5.7.7 Yes Yes Yes Global Yes Yes Yes
chroot Yes Yes Yes Yes Yes
clone_autotune_concurrency 8.0.17 Yes Yes Yes Global Yes Yes
clone_buffer_size 8.0.17 Yes Yes Yes Global Yes Yes
clone_ddl_timeout 8.0.17 Yes Yes Yes Global Yes Yes
clone_enable_compression 8.0.17 Yes Yes Yes Global Yes Yes
clone_max_concurrency 8.0.17 Yes Yes Yes Global Yes Yes
clone_max_data_bandwidth 8.0.17 Yes Yes Yes Global Yes Yes
clone_max_network_bandwidth 8.0.17 Yes Yes Yes Global Yes Yes
clone_ssl_ca 8.0.14 Yes Yes Yes Global Yes Yes
clone_ssl_cert 8.0.14 Yes Yes Yes Global Yes Yes
clone_ssl_key 8.0.14 Yes Yes Yes Global Yes Yes
clone_valid_donor_list 8.0.17 Yes Yes Yes Global Yes Yes
collation_connection Yes Both Yes Yes Yes Yes
collation_database Yes Both Yes Yes Yes Yes
collation_server Yes Yes Yes Both Yes Yes Yes Yes
Com_admin_commands Yes Both No Yes Yes Yes
Com_alter_db Yes Both No Yes Yes Yes
Com_alter_db_upgrade Yes Both No Yes Yes
Com_alter_event Yes Both No Yes Yes Yes
Com_alter_function Yes Both No Yes Yes Yes
Com_alter_procedure Yes Both No Yes Yes Yes
Com_alter_resource_group 8.0.3 Yes Global No Yes
Com_alter_server Yes Both No Yes Yes Yes
Com_alter_table Yes Both No Yes Yes Yes
Com_alter_tablespace Yes Both No Yes Yes Yes
Com_alter_user 5.6.6 Yes Both No Yes Yes Yes
Com_alter_user_default_role Yes Global No Yes
Com_analyze Yes Both No Yes Yes Yes
Com_assign_to_keycache Yes Both No Yes Yes Yes
Com_begin Yes Both No Yes Yes Yes
Com_binlog Yes Both No Yes Yes Yes
Com_call_procedure Yes Both No Yes Yes Yes
Com_change_db Yes Both No Yes Yes Yes
Com_change_master Yes Both No Yes Yes Yes
Com_change_repl_filter 5.7.3 Yes Both No Yes Yes
Com_check Yes Both No Yes Yes Yes
Com_checksum Yes Both No Yes Yes Yes
Com_clone 8.0.2 Yes Global No Yes
Com_commit Yes Both No Yes Yes Yes
Com_create_db Yes Both No Yes Yes Yes
Com_create_event Yes Both No Yes Yes Yes
Com_create_function Yes Both No Yes Yes Yes
Com_create_index Yes Both No Yes Yes Yes
Com_create_procedure Yes Both No Yes Yes Yes
Com_create_resource_group 8.0.3 Yes Global No Yes
Com_create_role Yes Global No Yes
Com_create_server Yes Both No Yes Yes Yes
Com_create_table Yes Both No Yes Yes Yes
Com_create_trigger Yes Both No Yes Yes Yes
Com_create_udf Yes Both No Yes Yes Yes
Com_create_user Yes Both No Yes Yes Yes
Com_create_view Yes Both No Yes Yes Yes
Com_dealloc_sql Yes Both No Yes Yes Yes
Com_delete Yes Both No Yes Yes Yes
Com_delete_multi Yes Both No Yes Yes Yes
Com_do Yes Both No Yes Yes Yes
Com_drop_db Yes Both No Yes Yes Yes
Com_drop_event Yes Both No Yes Yes Yes
Com_drop_function Yes Both No Yes Yes Yes
Com_drop_index Yes Both No Yes Yes Yes
Com_drop_procedure Yes Both No Yes Yes Yes
Com_drop_resource_group 8.0.3 Yes Global No Yes
Com_drop_role Yes Global No Yes
Com_drop_server Yes Both No Yes Yes Yes
Com_drop_table Yes Both No Yes Yes Yes
Com_drop_trigger Yes Both No Yes Yes Yes
Com_drop_user Yes Both No Yes Yes Yes
Com_drop_view Yes Both No Yes Yes Yes
Com_empty_query Yes Both No Yes Yes Yes
Com_execute_sql Yes Both No Yes Yes Yes
Com_explain_other 5.7.2 Yes Both No Yes Yes
Com_flush Yes Both No Yes Yes Yes
Com_get_diagnostics 5.6.4 Yes Both No Yes Yes Yes
Com_grant Yes Both No Yes Yes Yes
Com_grant_roles Yes Global No Yes
Com_group_replication_start 5.7.6 Yes Global No Yes Yes
Com_group_replication_stop 5.7.6 Yes Global No Yes Yes
Com_ha_close Yes Both No Yes Yes Yes
Com_ha_open Yes Both No Yes Yes Yes
Com_ha_read Yes Both No Yes Yes Yes
Com_help Yes Both No Yes Yes Yes
Com_insert Yes Both No Yes Yes Yes
Com_insert_select Yes Both No Yes Yes Yes
Com_install_component Yes Global No Yes
Com_install_plugin Yes Both No Yes Yes Yes
Com_kill Yes Both No Yes Yes Yes
Com_load Yes Both No Yes Yes Yes
Com_lock_tables Yes Both No Yes Yes Yes
Com_optimize Yes Both No Yes Yes Yes
Com_preload_keys Yes Both No Yes Yes Yes
Com_prepare_sql Yes Both No Yes Yes Yes
Com_purge Yes Both No Yes Yes Yes
Com_purge_before_date Yes Both No Yes Yes Yes
Com_release_savepoint Yes Both No Yes Yes Yes
Com_rename_table Yes Both No Yes Yes Yes
Com_rename_user Yes Both No Yes Yes Yes
Com_repair Yes Both No Yes Yes Yes
Com_replace Yes Both No Yes Yes Yes
Com_replace_select Yes Both No Yes Yes Yes
Com_reset Yes Both No Yes Yes Yes
Com_resignal Yes Both No Yes Yes Yes
Com_restart 8.0.4 Yes Both No Yes
Com_revoke Yes Both No Yes Yes Yes
Com_revoke_all Yes Both No Yes Yes Yes
Com_revoke_roles Yes Global No Yes
Com_rollback Yes Both No Yes Yes Yes
Com_rollback_to_savepoint Yes Both No Yes Yes Yes
Com_savepoint Yes Both No Yes Yes Yes
Com_select Yes Both No Yes Yes Yes
Com_set_option Yes Both No Yes Yes Yes
Com_set_resource_group 8.0.3 Yes Global No Yes
Com_set_role Yes Global No Yes
Com_show_authors Yes Both No Yes Yes Yes
Com_show_binlog_events Yes Both No Yes Yes Yes
Com_show_binlogs Yes Both No Yes Yes Yes
Com_show_charsets Yes Both No Yes Yes Yes
Com_show_collations Yes Both No Yes Yes Yes
Com_show_contributors Yes Both No Yes Yes Yes
Com_show_create_db Yes Both No Yes Yes Yes
Com_show_create_event Yes Both No Yes Yes Yes
Com_show_create_func Yes Both No Yes Yes Yes
Com_show_create_proc Yes Both No Yes Yes Yes
Com_show_create_table Yes Both No Yes Yes Yes
Com_show_create_trigger Yes Both No Yes Yes Yes
Com_show_create_user 5.7.6 Yes Both No Yes Yes
Com_show_databases Yes Both No Yes Yes Yes
Com_show_engine_logs Yes Both No Yes Yes Yes
Com_show_engine_mutex Yes Both No Yes Yes Yes
Com_show_engine_status Yes Both No Yes Yes Yes
Com_show_errors Yes Both No Yes Yes Yes
Com_show_events Yes Both No Yes Yes Yes
Com_show_fields Yes Both No Yes Yes Yes
Com_show_function_code Yes Both No Yes Yes Yes
Com_show_function_status Yes Both No Yes Yes Yes
Com_show_grants Yes Both No Yes Yes Yes
Com_show_keys Yes Both No Yes Yes Yes
Com_show_master_status Yes Both No Yes Yes Yes
Com_show_ndb_status Yes Both No Yes Yes Yes
Com_show_new_master 5.6.2 Yes Both No Yes
Com_show_open_tables Yes Both No Yes Yes Yes
Com_show_plugins Yes Both No Yes Yes Yes
Com_show_privileges Yes Both No Yes Yes Yes
Com_show_procedure_code Yes Both No Yes Yes Yes
Com_show_procedure_status Yes Both No Yes Yes Yes
Com_show_processlist Yes Both No Yes Yes Yes
Com_show_profile Yes Both No Yes Yes Yes
Com_show_profiles Yes Both No Yes Yes Yes
Com_show_relaylog_events Yes Both No Yes Yes Yes
Com_show_slave_hosts Yes Both No Yes Yes Yes
Com_show_slave_status Yes Both No Yes Yes Yes
Com_show_slave_status_nonblocking 5.7.6 Yes Both No Yes
Com_show_status Yes Both No Yes Yes Yes
Com_show_storage_engines Yes Both No Yes Yes Yes
Com_show_table_status Yes Both No Yes Yes Yes
Com_show_tables Yes Both No Yes Yes Yes
Com_show_triggers Yes Both No Yes Yes Yes
Com_show_variables Yes Both No Yes Yes Yes
Com_show_warnings Yes Both No Yes Yes Yes
Com_shutdown 5.7.9 Yes Both No Yes Yes
Com_signal Yes Both No Yes Yes Yes
Com_slave_start Yes Both No Yes Yes Yes
Com_slave_stop Yes Both No Yes Yes Yes
Com_stmt_close Yes Both No Yes Yes Yes
Com_stmt_execute Yes Both No Yes Yes Yes
Com_stmt_fetch Yes Both No Yes Yes Yes
Com_stmt_prepare Yes Both No Yes Yes Yes
Com_stmt_reprepare Yes Both No Yes Yes Yes
Com_stmt_reset Yes Both No Yes Yes Yes
Com_stmt_send_long_data Yes Both No Yes Yes Yes
Com_truncate Yes Both No Yes Yes Yes
Com_uninstall_component Yes Global No Yes
Com_uninstall_plugin Yes Both No Yes Yes Yes
Com_unlock_tables Yes Both No Yes Yes Yes
Com_update Yes Both No Yes Yes Yes
Com_update_multi Yes Both No Yes Yes Yes
Com_xa_commit Yes Both No Yes Yes Yes
Com_xa_end Yes Both No Yes Yes Yes
Com_xa_prepare Yes Both No Yes Yes Yes
Com_xa_recover Yes Both No Yes Yes Yes
Com_xa_rollback Yes Both No Yes Yes Yes
Com_xa_start Yes Both No Yes Yes Yes
completion_type Yes Yes Yes Both Yes Yes Yes Yes
Compression 8.0.18 Yes Session No Yes Yes Yes
Compression_algorithm 8.0.18 Yes Global No Yes
Compression_level 8.0.18 Yes Global No Yes
concurrent_insert Yes Yes Yes Global Yes Yes Yes Yes
connect_timeout Yes Yes Yes Global Yes Yes Yes Yes
Connection_control_delay_generated 5.6.35, 5.7.17, 8.0.1 Yes Global No Yes Yes Yes
connection_control_failed_connections_threshold 5.6.35, 5.7.17, 8.0.1 Yes Yes Yes Global Yes Yes Yes Yes
connection_control_max_connection_delay 5.6.35, 5.7.17, 8.0.1 Yes Yes Yes Global Yes Yes Yes Yes
connection_control_min_connection_delay 5.6.35, 5.7.17, 8.0.1 Yes Yes Yes Global Yes Yes Yes Yes
Connection_errors_accept 5.6.5 Yes Global No Yes Yes Yes
Connection_errors_internal 5.6.5 Yes Global No Yes Yes Yes
Connection_errors_max_connections 5.6.5 Yes Global No Yes Yes Yes
Connection_errors_peer_address 5.6.5 Yes Global No Yes Yes Yes
Connection_errors_select 5.6.5 Yes Global No Yes Yes Yes
Connection_errors_tcpwrap 5.6.5 Yes Global No Yes Yes Yes
Connections Yes Global No Yes Yes Yes
console Yes Yes Yes Yes Yes
core-file Yes Yes Yes Yes Yes
core_file 5.6.2 Yes Global No Yes Yes Yes
create_admin_listener_thread 8.0.14 Yes Yes Yes Global No Yes
create_old_temporals 5.6.25-ndb-7.4.7 5.6.25-ndb-7.4.7 Yes Yes Yes Global No Yes
Created_tmp_disk_tables Yes Both No Yes Yes Yes
Created_tmp_files Yes Global No Yes Yes Yes
Created_tmp_tables Yes Both No Yes Yes Yes
cte_max_recursion_depth 8.0.3 Yes Yes Yes Both Yes Yes
Current_tls_ca 8.0.16 Yes Global No Yes
Current_tls_capath 8.0.16 Yes Global No Yes
Current_tls_cert 8.0.16 Yes Global No Yes
Current_tls_cipher 8.0.16 Yes Global No Yes
Current_tls_ciphersuites 8.0.16 Yes Global No Yes
Current_tls_crl 8.0.16 Yes Global No Yes
Current_tls_crlpath 8.0.16 Yes Global No Yes
Current_tls_key 8.0.16 Yes Global No Yes
Current_tls_version 8.0.16 Yes Global No Yes
daemon_memcached_enable_binlog 5.6.6 Yes Yes Yes Global No Yes Yes Yes
daemon_memcached_engine_lib_name 5.6.6 Yes Yes Yes Global No Yes Yes Yes
daemon_memcached_engine_lib_path 5.6.6 Yes Yes Yes Global No Yes Yes Yes
daemon_memcached_option 5.6.6 Yes Yes Yes Global No Yes Yes Yes
daemon_memcached_r_batch_size 5.6.6 Yes Yes Yes Global No Yes Yes Yes
daemon_memcached_w_batch_size 5.6.6 Yes Yes Yes Global No Yes Yes Yes
daemonize 5.7.6 Yes Yes Yes Yes
datadir Yes Yes Yes Global No Yes Yes Yes
date_format 8.0.3 Yes Global No Yes Yes Yes
datetime_format 8.0.3 Yes Global No Yes Yes Yes
ddl-rewriter 8.0.16 Yes Yes Yes
debug Yes Yes Yes Both Yes Yes Yes Yes
debug_sync Yes Session Yes Yes Yes Yes
debug-sync-timeout Yes Yes Yes Yes Yes
default-authentication-plugin 5.6.6 5.7.2 Yes Yes Yes Yes
default_authentication_plugin 5.7.2 Yes Yes Yes Global No Yes Yes
default_collation_for_utf8mb4 8.0.11 Yes Both Yes Yes
default_password_lifetime 5.7.4 Yes Yes Yes Global Yes Yes Yes
default_storage_engine Yes Yes Yes Both Yes Yes Yes Yes
default_table_encryption 8.0.16 Yes Yes Yes Both Yes Yes
default-time-zone Yes Yes Yes Yes Yes
default_tmp_storage_engine 5.6.3 Yes Yes Yes Both Yes Yes Yes Yes
default_week_format Yes Yes Yes Both Yes Yes Yes Yes
defaults-extra-file Yes Yes Yes Yes
defaults-file Yes Yes Yes Yes
defaults-group-suffix Yes Yes Yes Yes
delay_key_write Yes Yes Yes Global Yes Yes Yes Yes
Delayed_errors 5.6.7 Yes Global No Yes Yes Yes
delayed_insert_limit 5.6.7 Yes Yes Yes Global Yes Yes Yes Yes
Delayed_insert_threads 5.6.7 Yes Global No Yes Yes Yes
delayed_insert_timeout 5.6.7 Yes Yes Yes Global Yes Yes Yes Yes
delayed_queue_size 5.6.7 Yes Yes Yes Global Yes Yes Yes Yes
Delayed_writes 5.6.7 Yes Global No Yes Yes Yes
des-key-file 5.7.6 8.0.3 Yes Yes Yes Yes Yes
disable-gtid-unsafe-statements 5.6.5 5.6.9 Yes Yes Yes Global No Yes
disable_gtid_unsafe_statements 5.6.5 5.6.9 Yes Yes Yes Global No Yes
disable-partition-engine-check 5.7.17 5.7.17 Yes Yes Yes
disabled_storage_engines 5.7.8 Yes Yes Yes Global No Yes Yes
disconnect_on_expired_password 5.6.10, 5.7.1 Yes Yes Yes Global No Yes Yes Yes
disconnect-slave-event-count Yes Yes Yes Yes Yes
div_precision_increment Yes Yes Yes Both Yes Yes Yes Yes
dragnet.log_error_filter_rules 8.0.4 Yes Yes Yes Global Yes Yes
dragnet.Status 8.0.12 Yes Global No Yes
early-plugin-load 5.7.11 Yes Yes Yes Yes
end_markers_in_json 5.6.5 Yes Yes Yes Both Yes Yes Yes Yes
enforce_gtid_consistency 5.6.9 Yes Yes Yes Global Varies Yes Yes Yes
engine_condition_pushdown 5.5.3 5.6.1 Yes Yes Yes Both Yes Yes
eq_range_index_dive_limit 5.6.5 Yes Yes Yes Both Yes Yes Yes Yes
error_count Yes Session No Yes Yes Yes
event_scheduler Yes Yes Yes Global Yes Yes Yes Yes
executed_gtids_compression_period 5.7.5 5.7.6 Yes Yes Yes Global Yes Yes
exit-info Yes Yes Yes Yes Yes
expire_logs_days 8.0.3 Yes Yes Yes Global Yes Yes Yes Yes
explicit_defaults_for_timestamp 5.6.6 5.6.6 Yes Yes Yes Both Yes Yes Yes Yes
external-locking Yes Yes Yes Yes Yes
external_user Yes Session No Yes Yes Yes
federated Yes Yes Yes Yes Yes
Firewall_access_denied 5.6.24, 5.7.9, 8.0.11 Yes Global No Yes Yes Yes
Firewall_access_granted 5.6.24, 5.7.9, 8.0.11 Yes Global No Yes Yes Yes
Firewall_cached_entries 5.6.24, 5.7.9, 8.0.11 Yes Global No Yes Yes Yes
flush Yes Yes Yes Global Yes Yes Yes Yes
Flush_commands Yes Global No Yes Yes Yes
flush_time Yes Yes Yes Global Yes Yes Yes Yes
foreign_key_checks Yes Both Yes Yes Yes Yes
ft_boolean_syntax Yes Yes Yes Global Yes Yes Yes Yes
ft_max_word_len Yes Yes Yes Global No Yes Yes Yes
ft_min_word_len Yes Yes Yes Global No Yes Yes Yes
ft_query_expansion_limit Yes Yes Yes Global No Yes Yes Yes
ft_stopword_file Yes Yes Yes Global No Yes Yes Yes
gdb Yes Yes Yes Yes Yes
general_log Yes Yes Yes Global Yes Yes Yes Yes
general_log_file Yes Yes Yes Global Yes Yes Yes Yes
generated_random_password_length 8.0.18 Yes Yes Yes Both Yes Yes
group_concat_max_len Yes Yes Yes Both Yes Yes Yes Yes
group_replication_allow_local_disjoint_gtids_join 5.7.17 5.7.21 8.0.4 Yes Yes Yes Global Yes Yes Yes
group_replication_allow_local_lower_version_join 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_auto_increment_increment 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_autorejoin_tries 8.0.16 Yes Yes Yes Global Yes Yes
group_replication_bootstrap_group 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_clone_threshold 8.0.17 Yes Yes Yes Global Yes Yes
group_replication_communication_debug_options 8.0.3 Yes Yes Yes Global Yes Yes
group_replication_communication_max_message_size 8.0.16 Yes Yes Yes Global Yes Yes
group_replication_components_stop_timeout 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_compression_threshold 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_consistency 8.0.14 Yes Yes Yes Both Yes Yes
group_replication_enforce_update_everywhere_checks 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_exit_state_action 5.7.24, 8.0.12 Yes Yes Yes Global Yes Yes Yes
group_replication_flow_control_applier_threshold 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_flow_control_certifier_threshold 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_flow_control_hold_percent 8.0.2 Yes Yes Yes Global Yes Yes
group_replication_flow_control_max_commit_quota 8.0.2 Yes Yes Yes Global Yes Yes
group_replication_flow_control_member_quota_percent 8.0.2 Yes Yes Yes Global Yes Yes
group_replication_flow_control_min_quota 8.0.2 Yes Yes Yes Global Yes Yes
group_replication_flow_control_min_recovery_quota 8.0.2 Yes Yes Yes Global Yes Yes
group_replication_flow_control_mode 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_flow_control_period 8.0.2 Yes Yes Yes Global Yes Yes
group_replication_flow_control_release_percent 8.0.2 Yes Yes Yes Global Yes Yes
group_replication_force_members 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_group_name 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_group_seeds 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_gtid_assignment_block_size 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_ip_whitelist 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_local_address 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_member_expel_timeout 8.0.13 Yes Yes Yes Global Yes Yes
group_replication_member_weight 5.7.20, 8.0.2 Yes Yes Yes Global Yes Yes Yes
group_replication_message_cache_size 8.0.16 Yes Yes Yes Global Yes Yes
group_replication_poll_spin_loops 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_primary_member Yes Global No Yes Yes
group_replication_recovery_complete_at 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_recovery_compression_algorithm 8.0.18 Yes Yes Yes Global Yes Yes
group_replication_recovery_get_public_key 8.0.4 Yes Yes Yes Global Yes Yes
group_replication_recovery_public_key_path 8.0.4 Yes Yes Yes Global Yes Yes
group_replication_recovery_reconnect_interval 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_recovery_retry_count 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_recovery_ssl_ca 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_recovery_ssl_capath 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_recovery_ssl_cert 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_recovery_ssl_cipher 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_recovery_ssl_crl 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_recovery_ssl_crlpath 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_recovery_ssl_key 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_recovery_ssl_verify_server_cert 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_recovery_tls_ciphersuites 8.0.19 Yes Yes Yes Global Yes Yes
group_replication_recovery_tls_version 8.0.19 Yes Yes Yes Global Yes Yes
group_replication_recovery_use_ssl 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_recovery_zstd_compression_level 8.0.18 Yes Yes Yes Global Yes Yes
group_replication_single_primary_mode 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_ssl_mode 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_start_on_boot 5.7.17 Yes Yes Yes Global Yes Yes Yes
group_replication_transaction_size_limit 5.7.19 Yes Yes Yes Global Yes Yes Yes
group_replication_unreachable_majority_timeout 5.7.19, 8.0.2 Yes Yes Yes Global Yes Yes Yes
gtid_done 5.6.5 5.6.9 Yes Both No Yes
gtid_executed 5.6.9 Yes Varies No Yes Yes Yes
gtid_executed_compression_period 5.7.6 Yes Yes Yes Global Yes Yes Yes
gtid_lost 5.6.5 5.6.9 Yes Global No Yes
gtid_mode 5.6.5 Yes Yes Yes Global Varies Yes Yes Yes
gtid_next 5.6.5 Yes Session Yes Yes Yes Yes
gtid_owned 5.6.5 Yes Both No Yes Yes Yes
gtid_purged 5.6.9 Yes Global Yes Yes Yes Yes
Handler_commit Yes Both No Yes Yes Yes
Handler_delete Yes Both No Yes Yes Yes
Handler_discover Yes Both No Yes Yes Yes
Handler_external_lock 5.6.2 Yes Both No Yes Yes Yes
Handler_mrr_init 5.6.1 Yes Both No Yes Yes Yes
Handler_prepare Yes Both No Yes Yes Yes
Handler_read_first Yes Both No Yes Yes Yes
Handler_read_key Yes Both No Yes Yes Yes
Handler_read_last 5.6.1 Yes Both No Yes Yes Yes
Handler_read_next Yes Both No Yes Yes Yes
Handler_read_prev Yes Both No Yes Yes Yes
Handler_read_rnd Yes Both No Yes Yes Yes
Handler_read_rnd_next Yes Both No Yes Yes Yes
Handler_rollback Yes Both No Yes Yes Yes
Handler_savepoint Yes Both No Yes Yes Yes
Handler_savepoint_rollback Yes Both No Yes Yes Yes
Handler_update Yes Both No Yes Yes Yes
Handler_write Yes Both No Yes Yes Yes
have_compress Yes Global No Yes Yes Yes
have_crypt 5.7.6 8.0.3 Yes Global No Yes Yes Yes
have_csv 5.6.1 Yes Global No Yes
have_dynamic_loading Yes Global No Yes Yes Yes
have_geometry Yes Global No Yes Yes Yes
have_innodb 5.6.1 Yes Global No Yes
have_ndbcluster 5.6.1 Yes Global No Yes
have_openssl Yes Global No Yes Yes Yes
have_partitioning 5.6.1 Yes Global No Yes
have_profiling 5.6.8 Yes Global No Yes Yes Yes
have_query_cache 5.7.20 Yes Global No Yes Yes Yes
have_rtree_keys Yes Global No Yes Yes Yes
have_ssl Yes Global No Yes Yes Yes
have_statement_timeout 5.7.4 Yes Global No Yes Yes
have_symlink Yes Global No Yes Yes Yes
help Yes Yes Yes Yes Yes
histogram_generation_max_mem_size 8.0.2 Yes Yes Yes Both Yes Yes
host_cache_size 5.6.5 Yes Yes Yes Global Yes Yes Yes Yes
hostname Yes Global No Yes Yes Yes
identity Yes Session Yes Yes Yes Yes
ignore_builtin_innodb 5.5.22 8.0.3 Yes Yes Yes Global No Yes Yes Yes
ignore-db-dir 5.6.3 5.7.16 Yes Yes Yes Yes
ignore_db_dirs 5.6.3 5.7.16 Yes Global No Yes Yes
immediate_server_version 8.0.14 Yes Session Yes Yes
information_schema_stats_expiry 8.0.3 Yes Yes Yes Both Yes Yes
init_connect Yes Yes Yes Global Yes Yes Yes Yes
init_file Yes Yes Yes Global No Yes Yes Yes
init_slave Yes Yes Yes Global Yes Yes Yes Yes
initialize 5.7.6 Yes Yes Yes Yes
initialize-insecure 5.7.6 Yes Yes Yes Yes
innodb 5.6.21, 5.7.5 Yes Yes Yes Yes Yes
innodb_adaptive_flushing Yes Yes Yes Global Yes Yes Yes Yes
innodb_adaptive_flushing_lwm 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
innodb_adaptive_hash_index Yes Yes Yes Global Yes Yes Yes Yes
innodb_adaptive_hash_index_parts 5.7.8 Yes Yes Yes Global No Yes Yes
innodb_adaptive_max_sleep_delay 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
innodb_additional_mem_pool_size 5.6.3 5.7.4 Yes Yes Yes Global No Yes Yes
innodb_api_bk_commit_interval 5.6.7 Yes Yes Yes Global Yes Yes Yes Yes
innodb_api_disable_rowlock 5.6.6 Yes Yes Yes Global No Yes Yes Yes
innodb_api_enable_binlog 5.6.6 Yes Yes Yes Global No Yes Yes Yes
innodb_api_enable_mdl 5.6.6 Yes Yes Yes Global No Yes Yes Yes
innodb_api_trx_level 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
innodb_autoextend_increment Yes Yes Yes Global Yes Yes Yes Yes
innodb_autoinc_lock_mode Yes Yes Yes Global No Yes Yes Yes
Innodb_available_undo_logs 5.6.5 5.7.19 8.0.2 Yes Global No Yes Yes Yes
innodb_background_drop_list_empty 5.7.10 Yes Yes Yes Global Yes Yes Yes
Innodb_buffer_pool_bytes_data 5.6.10 Yes Global No Yes Yes Yes
Innodb_buffer_pool_bytes_dirty 5.6.10 Yes Global No Yes Yes Yes
innodb_buffer_pool_chunk_size 5.7.5 Yes Yes Yes Global No Yes Yes
innodb_buffer_pool_debug Yes Yes Yes Global No Yes
innodb_buffer_pool_dump_at_shutdown 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
innodb_buffer_pool_dump_now 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
innodb_buffer_pool_dump_pct 5.7.2 Yes Yes Yes Global Yes Yes Yes
Innodb_buffer_pool_dump_status 5.6.3 Yes Global No Yes Yes Yes
innodb_buffer_pool_filename 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
innodb_buffer_pool_in_core_file 8.0.14 Yes Yes Yes Global Yes Yes
innodb_buffer_pool_instances Yes Yes Yes Global No Yes Yes Yes
innodb_buffer_pool_load_abort 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
innodb_buffer_pool_load_at_startup 5.6.3 Yes Yes Yes Global No Yes Yes Yes
innodb_buffer_pool_load_now 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
Innodb_buffer_pool_load_status 5.6.3 Yes Global No Yes Yes Yes
Innodb_buffer_pool_pages_data Yes Global No Yes Yes Yes
Innodb_buffer_pool_pages_dirty Yes Global No Yes Yes Yes
Innodb_buffer_pool_pages_flushed Yes Global No Yes Yes Yes
Innodb_buffer_pool_pages_free Yes Global No Yes Yes Yes
Innodb_buffer_pool_pages_latched Yes Global No Yes Yes Yes
Innodb_buffer_pool_pages_misc Yes Global No Yes Yes Yes
Innodb_buffer_pool_pages_total Yes Global No Yes Yes Yes
Innodb_buffer_pool_read_ahead Yes Global No Yes Yes Yes
Innodb_buffer_pool_read_ahead_evicted Yes Global No Yes Yes Yes
Innodb_buffer_pool_read_ahead_rnd Yes Global No Yes Yes Yes
Innodb_buffer_pool_read_requests Yes Global No Yes Yes Yes
Innodb_buffer_pool_reads Yes Global No Yes Yes Yes
Innodb_buffer_pool_resize_status 5.7.5 Yes Global No Yes Yes
innodb_buffer_pool_size Yes Yes Yes Global Varies Yes Yes Yes
Innodb_buffer_pool_wait_free Yes Global No Yes Yes Yes
Innodb_buffer_pool_write_requests Yes Global No Yes Yes Yes
innodb_change_buffer_max_size 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
innodb_change_buffering Yes Yes Yes Global Yes Yes Yes Yes
innodb_change_buffering_debug Yes Yes Yes Global Yes Yes Yes Yes
innodb_checkpoint_disabled 8.0.2 Yes Yes Yes Global Yes Yes
innodb_checksum_algorithm 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
innodb_checksums 5.6.3 Yes Yes Yes Global No Yes Yes
innodb_cmp_per_index_enabled 5.6.7 Yes Yes Yes Global Yes Yes Yes Yes
innodb_commit_concurrency Yes Yes Yes Global Yes Yes Yes Yes
innodb_compress_debug 5.7.8 Yes Yes Yes Global Yes Yes Yes
innodb_compression_failure_threshold_pct 5.6.7 Yes Yes Yes Global Yes Yes Yes Yes
innodb_compression_level 5.6.7 Yes Yes Yes Global Yes Yes Yes Yes
innodb_compression_pad_pct_max 5.6.7 Yes Yes Yes Global Yes Yes Yes Yes
innodb_concurrency_tickets Yes Yes Yes Global Yes Yes Yes Yes
innodb_data_file_path Yes Yes Yes Global No Yes Yes Yes
Innodb_data_fsyncs Yes Global No Yes Yes Yes
innodb_data_home_dir Yes Yes Yes Global No Yes Yes Yes
Innodb_data_pending_fsyncs Yes Global No Yes Yes Yes
Innodb_data_pending_reads Yes Global No Yes Yes Yes
Innodb_data_pending_writes Yes Global No Yes Yes Yes
Innodb_data_read Yes Global No Yes Yes Yes
Innodb_data_reads Yes Global No Yes Yes Yes
Innodb_data_writes Yes Global No Yes Yes Yes
Innodb_data_written Yes Global No Yes Yes Yes
Innodb_dblwr_pages_written Yes Global No Yes Yes Yes
Innodb_dblwr_writes Yes Global No Yes Yes Yes
innodb_ddl_log_crash_reset_debug 8.0.3 Yes Yes Yes Global Yes Yes
innodb_deadlock_detect 5.7.15 Yes Yes Yes Global Yes Yes Yes
innodb_dedicated_server 8.0.3 Yes Yes Yes Global No Yes
innodb_default_row_format 5.7.9 Yes Yes Yes Global Yes Yes Yes
innodb_directories 8.0.4 Yes Yes Yes Global No Yes
innodb_disable_resize_buffer_pool_debug 5.7.6 Yes Yes Yes Global Yes Yes
innodb_disable_sort_file_cache 5.6.4 Yes Yes Yes Global Yes Yes Yes Yes
innodb_doublewrite Yes Yes Yes Global No Yes Yes Yes
innodb_doublewrite_batch_size 8.0.20 Yes Yes Yes Global Yes Yes
innodb_doublewrite_dir 8.0.20 Yes Yes Yes Global No Yes
innodb_doublewrite_files 8.0.20 Yes Yes Yes Global No Yes
innodb_doublewrite_pages 8.0.20 Yes Yes Yes Global No Yes
innodb_fast_shutdown Yes Yes Yes Global Yes Yes Yes Yes
innodb_fil_make_page_dirty_debug 5.6.17 Yes Yes Yes Global Yes Yes Yes Yes
innodb_file_format 5.7.7 Yes Yes Yes Global Yes Yes Yes
innodb_file_format_check 5.7.7 Yes Yes Yes Global No Yes Yes
innodb_file_format_max 5.7.7 Yes Yes Yes Global Yes Yes Yes
innodb_file_per_table Yes Yes Yes Global Yes Yes Yes Yes
innodb_fill_factor 5.7.5 Yes Yes Yes Global Yes Yes Yes
innodb_flush_log_at_timeout 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
innodb_flush_log_at_trx_commit Yes Yes Yes Global Yes Yes Yes Yes
innodb_flush_method Yes Yes Yes Global No Yes Yes Yes
innodb_flush_neighbors 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
innodb_flush_sync 5.7.8 Yes Yes Yes Global Yes Yes Yes
innodb_flushing_avg_loops 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
innodb_force_load_corrupted 5.6.3 Yes Yes Yes Global No Yes Yes Yes
innodb_force_recovery Yes Yes Yes Global No Yes Yes Yes
innodb_fsync_threshold 8.0.13 Yes Yes Yes Global Yes Yes
innodb_ft_aux_table 5.6.4 Yes Global Yes Yes Yes Yes
innodb_ft_cache_size 5.6.4 Yes Yes Yes Global No Yes Yes Yes
innodb_ft_enable_diag_print 5.6.4 Yes Yes Yes Global Yes Yes Yes Yes
innodb_ft_enable_stopword 5.6.4 Yes Yes Yes Both Yes Yes Yes Yes
innodb_ft_max_token_size 5.6.4 Yes Yes Yes Global No Yes Yes Yes
innodb_ft_min_token_size 5.6.4 Yes Yes Yes Global No Yes Yes Yes
innodb_ft_num_word_optimize 5.6.4 Yes Yes Yes Global Yes Yes Yes Yes
innodb_ft_result_cache_limit 5.6.13, 5.7.2 Yes Yes Yes Global Yes Yes Yes Yes
innodb_ft_server_stopword_table 5.6.4 Yes Yes Yes Global Yes Yes Yes Yes
innodb_ft_sort_pll_degree 5.6.4 Yes Yes Yes Global No Yes Yes Yes
innodb_ft_total_cache_size 5.6.13, 5.7.2 Yes Yes Yes Global No Yes Yes Yes
innodb_ft_user_stopword_table 5.6.4 Yes Yes Yes Both Yes Yes Yes Yes
Innodb_have_atomic_builtins Yes Global No Yes Yes Yes
innodb_idle_flush_pct 8.0.18 Yes Yes Yes Global Yes Yes
innodb_io_capacity Yes Yes Yes Global Yes Yes Yes Yes
innodb_io_capacity_max 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
innodb_large_prefix 5.6.3 5.7.7 Yes Yes Yes Global Yes Yes Yes
innodb_limit_optimistic_insert_debug Yes Yes Yes Global Yes Yes Yes Yes
innodb_lock_wait_timeout Yes Yes Yes Both Yes Yes Yes Yes
innodb_locks_unsafe_for_binlog 5.6.3 Yes Yes Yes Global No Yes Yes
innodb_log_buffer_size Yes Yes Yes Global Varies Yes Yes Yes
innodb_log_checkpoint_fuzzy_now 8.0.13 Yes Yes Yes Global Yes Yes
innodb_log_checkpoint_now 5.6.12, 5.7.2 Yes Yes Yes Global Yes Yes Yes Yes
innodb_log_checksum_algorithm 5.7.8 5.7.9 Yes Yes Yes Global Yes Yes
innodb_log_checksums 5.7.9 Yes Yes Yes Global Yes Yes Yes
innodb_log_compressed_pages 5.6.11 Yes Yes Yes Global Yes Yes Yes Yes
innodb_log_file_size Yes Yes Yes Global No Yes Yes Yes
innodb_log_files_in_group Yes Yes Yes Global No Yes Yes Yes
innodb_log_group_home_dir Yes Yes Yes Global No Yes Yes Yes
innodb_log_spin_cpu_abs_lwm 8.0.11 Yes Yes Yes Global Yes Yes
innodb_log_spin_cpu_pct_hwm 8.0.11 Yes Yes Yes Global Yes Yes
innodb_log_wait_for_flush_spin_hwm 8.0.11 Yes Yes Yes Global Yes Yes
Innodb_log_waits Yes Global No Yes Yes Yes
innodb_log_write_ahead_size 5.7.4 Yes Yes Yes Global Yes Yes Yes
Innodb_log_write_requests Yes Global No Yes Yes Yes
Innodb_log_writes Yes Global No Yes Yes Yes
innodb_lru_scan_depth 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
innodb_max_dirty_pages_pct Yes Yes Yes Global Yes Yes Yes Yes
innodb_max_dirty_pages_pct_lwm 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
innodb_max_purge_lag Yes Yes Yes Global Yes Yes Yes Yes
innodb_max_purge_lag_delay 5.6.5 Yes Yes Yes Global Yes Yes Yes Yes
innodb_max_undo_log_size 5.7.5 Yes Yes Yes Global Yes Yes Yes
innodb_merge_threshold_set_all_debug 5.7.6 Yes Yes Yes Global Yes Yes Yes
innodb_mirrored_log_groups Yes Yes Yes Global No Yes
innodb_monitor_disable 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
innodb_monitor_enable 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
innodb_monitor_reset 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
innodb_monitor_reset_all 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
Innodb_num_open_files 5.6.2 Yes Global No Yes Yes Yes
innodb_numa_interleave 5.6.27, 5.7.9 Yes Yes Yes Global No Yes Yes Yes
innodb_old_blocks_pct Yes Yes Yes Global Yes Yes Yes Yes
innodb_old_blocks_time Yes Yes Yes Global Yes Yes Yes Yes
innodb_online_alter_log_max_size 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
innodb_open_files Yes Yes Yes Global No Yes Yes Yes
innodb_optimize_fulltext_only 5.6.4 Yes Yes Yes Global Yes Yes Yes Yes
innodb_optimize_point_storage 5.7.5 5.7.6 Yes Yes Yes Session Yes Yes
Innodb_os_log_fsyncs Yes Global No Yes Yes Yes
Innodb_os_log_pending_fsyncs Yes Global No Yes Yes Yes
Innodb_os_log_pending_writes Yes Global No Yes Yes Yes
Innodb_os_log_written Yes Global No Yes Yes Yes
innodb_page_cleaners 5.7.4 Yes Yes Yes Global No Yes Yes
Innodb_page_size Yes Global No Yes Yes Yes
innodb_page_size 5.6.4 Yes Yes Yes Global No Yes Yes Yes
Innodb_pages_created Yes Global No Yes Yes Yes
Innodb_pages_read Yes Global No Yes Yes Yes
Innodb_pages_written Yes Global No Yes Yes Yes
innodb_parallel_read_threads 8.0.14 Yes Yes Yes Session Yes Yes
innodb_print_all_deadlocks 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
innodb_print_ddl_logs 8.0.3 Yes Yes Yes Global Yes Yes
innodb_purge_batch_size Yes Yes Yes Global Yes Yes Yes Yes
innodb_purge_rseg_truncate_frequency 5.7.5 Yes Yes Yes Global Yes Yes Yes
innodb_purge_threads Yes Yes Yes Global No Yes Yes Yes
innodb_random_read_ahead 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
innodb_read_ahead_threshold Yes Yes Yes Global Yes Yes Yes Yes
innodb_read_io_threads Yes Yes Yes Global No Yes Yes Yes
innodb_read_only 5.6.7 Yes Yes Yes Global No Yes Yes Yes
innodb_redo_log_archive_dirs 8.0.17 Yes Yes Yes Global Yes Yes
innodb_redo_log_encrypt 8.0.1 Yes Yes Yes Global Yes Yes
innodb_replication_delay Yes Yes Yes Global Yes Yes Yes Yes
innodb_rollback_on_timeout Yes Yes Yes Global No Yes Yes Yes
innodb_rollback_segments 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
Innodb_row_lock_current_waits Yes Global No Yes Yes Yes
Innodb_row_lock_time Yes Global No Yes Yes Yes
Innodb_row_lock_time_avg Yes Global No Yes Yes Yes
Innodb_row_lock_time_max Yes Global No Yes Yes Yes
Innodb_row_lock_waits Yes Global No Yes Yes Yes
Innodb_rows_deleted Yes Global No Yes Yes Yes
Innodb_rows_inserted Yes Global No Yes Yes Yes
Innodb_rows_read Yes Global No Yes Yes Yes
Innodb_rows_updated Yes Global No Yes Yes Yes
innodb_saved_page_number_debug 5.6.17 Yes Yes Yes Global Yes Yes Yes Yes
innodb_scan_directories 8.0.2 8.0.4 Yes Yes Yes Global No Yes
innodb_sort_buffer_size 5.6.4 Yes Yes Yes Global No Yes Yes Yes
innodb_spin_wait_delay Yes Yes Yes Global Yes Yes Yes Yes
innodb_spin_wait_pause_multiplier 8.0.16 Yes Yes Yes Global Yes Yes
innodb_stats_auto_recalc 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
innodb_stats_include_delete_marked 5.6.35, 5.7.17, 8.0.1 Yes Yes Yes Global Yes Yes Yes Yes
innodb_stats_method 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
innodb_stats_on_metadata Yes Yes Yes Global Yes Yes Yes Yes
innodb_stats_persistent 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
innodb_stats_persistent_sample_pages 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
innodb_stats_sample_pages 5.6.3 Yes Yes Yes Global Yes Yes Yes
innodb_stats_transient_sample_pages 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
innodb-status-file Yes Yes Yes Yes Yes
innodb_status_output 5.6.16, 5.7.4 Yes Yes Yes Global Yes Yes Yes Yes
innodb_status_output_locks 5.6.16, 5.7.4 Yes Yes Yes Global Yes Yes Yes Yes
innodb_strict_mode Yes Yes Yes Both Yes Yes Yes Yes
innodb_support_xa 5.7.10 Yes Yes Yes Both Yes Yes Yes
innodb_sync_array_size 5.6.3 Yes Yes Yes Global No Yes Yes Yes
innodb_sync_debug 5.7.8 Yes Yes Yes Global No Yes Yes
innodb_sync_spin_loops Yes Yes Yes Global Yes Yes Yes Yes
Innodb_system_rows_deleted 8.0.19 Yes Global No Yes
Innodb_system_rows_inserted 8.0.19 Yes Global No Yes
Innodb_system_rows_read 8.0.19 Yes Global No Yes
innodb_table_locks Yes Yes Yes Both Yes Yes Yes Yes
innodb_temp_data_file_path 5.7.1 Yes Yes Yes Global No Yes Yes
innodb_temp_tablespaces_dir 8.0.13 Yes Yes Yes Global No Yes
innodb_thread_concurrency Yes Yes Yes Global Yes Yes Yes Yes
innodb_thread_sleep_delay Yes Yes Yes Global Yes Yes Yes Yes
innodb_tmpdir 5.6.29, 5.7.11 Yes Yes Yes Both Yes Yes Yes Yes
Innodb_truncated_status_writes Yes Global No Yes Yes Yes
innodb_trx_purge_view_update_only_debug Yes Yes Yes Global Yes Yes Yes Yes
innodb_trx_rseg_n_slots_debug Yes Yes Yes Global Yes Yes Yes Yes
innodb_undo_directory 5.6.3 Yes Yes Yes Global No Yes Yes Yes
innodb_undo_log_encrypt 8.0.1 Yes Yes Yes Global Yes Yes
innodb_undo_log_truncate 5.7.5 Yes Yes Yes Global Yes Yes Yes
innodb_undo_logs 5.6.3 5.7.19 8.0.2 Yes Yes Yes Global Yes Yes Yes Yes
innodb_undo_tablespaces 5.6.3 5.7.21, 8.0.4 Yes Yes Yes Global Varies Yes Yes Yes
Innodb_undo_tablespaces_active 8.0.14 Yes Global No Yes
Innodb_undo_tablespaces_explicit 8.0.14 Yes Global No Yes
Innodb_undo_tablespaces_implicit 8.0.14 Yes Global No Yes
Innodb_undo_tablespaces_total 8.0.14 Yes Global No Yes
innodb_use_native_aio Yes Yes Yes Global No Yes Yes Yes
innodb_use_sys_malloc 5.6.3 5.7.4 Yes Yes Yes Global No Yes Yes
innodb_version Yes Global No Yes Yes Yes
innodb_write_io_threads Yes Yes Yes Global No Yes Yes Yes
insert_id Yes Session Yes Yes Yes Yes
install Yes Yes Yes Yes
install-manual Yes Yes Yes Yes
interactive_timeout Yes Yes Yes Both Yes Yes Yes Yes
internal_tmp_disk_storage_engine 5.7.5 8.0.16 Yes Yes Yes Global Yes Yes Yes
internal_tmp_mem_storage_engine 8.0.2 Yes Yes Yes Both Yes Yes
join_buffer_size Yes Yes Yes Both Yes Yes Yes Yes
keep_files_on_create Yes Yes Yes Both Yes Yes Yes Yes
Key_blocks_not_flushed Yes Global No Yes Yes Yes
Key_blocks_unused Yes Global No Yes Yes Yes
Key_blocks_used Yes Global No Yes Yes Yes
key_buffer_size Yes Yes Yes Global Yes Yes Yes Yes
key_cache_age_threshold Yes Yes Yes Global Yes Yes Yes Yes
key_cache_block_size Yes Yes Yes Global Yes Yes Yes Yes
key_cache_division_limit Yes Yes Yes Global Yes Yes Yes Yes
Key_read_requests Yes Global No Yes Yes Yes
Key_reads Yes Global No Yes Yes Yes
Key_write_requests Yes Global No Yes Yes Yes
Key_writes Yes Global No Yes Yes Yes
keyring_aws_cmk_id 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
keyring_aws_conf_file 5.7.19, 8.0.11 Yes Yes Yes Global No Yes Yes
keyring_aws_data_file 5.7.19, 8.0.11 Yes Yes Yes Global No Yes Yes
keyring_aws_region 5.7.19, 8.0.11 Yes Yes Yes Global Yes Yes Yes
keyring_encrypted_file_data 5.7.21, 8.0.11 Yes Yes Yes Global Yes Yes Yes
keyring_encrypted_file_password 5.7.21, 8.0.11 Yes Yes Yes Global Yes Yes Yes
keyring_file_data 5.7.11 Yes Yes Yes Global Yes Yes Yes
keyring_hashicorp_auth_path 8.0.18 Yes Yes Yes Global Yes Yes
keyring_hashicorp_ca_path 8.0.18 Yes Yes Yes Global Yes Yes
keyring_hashicorp_caching 8.0.18 Yes Yes Yes Global Yes Yes
keyring_hashicorp_commit_auth_path 8.0.18 Yes Global No Yes
keyring_hashicorp_commit_ca_path 8.0.18 Yes Global No Yes
keyring_hashicorp_commit_caching 8.0.18 Yes Global No Yes
keyring_hashicorp_commit_role_id 8.0.18 Yes Global No Yes
keyring_hashicorp_commit_server_url 8.0.18 Yes Global No Yes
keyring_hashicorp_commit_store_path 8.0.18 Yes Global No Yes
keyring_hashicorp_role_id 8.0.18 Yes Yes Yes Global Yes Yes
keyring_hashicorp_secret_id 8.0.18 Yes Yes Yes Global Yes Yes
keyring_hashicorp_server_url 8.0.18 Yes Yes Yes Global Yes Yes
keyring_hashicorp_store_path 8.0.18 Yes Yes Yes Global Yes Yes
keyring-migration-destination 5.7.21, 8.0.4 Yes Yes Yes Yes
keyring-migration-host 5.7.21, 8.0.4 Yes Yes Yes Yes
keyring-migration-password 5.7.21, 8.0.4 Yes Yes Yes Yes
keyring-migration-port 5.7.21, 8.0.4 Yes Yes Yes Yes
keyring-migration-socket 5.7.21, 8.0.4 Yes Yes Yes Yes
keyring-migration-source 5.7.21, 8.0.4 Yes Yes Yes Yes
keyring-migration-user 5.7.21, 8.0.4 Yes Yes Yes Yes
keyring_okv_conf_dir 5.7.12, 8.0.11 Yes Yes Yes Global Yes Yes Yes
keyring_operations 5.7.21, 8.0.4 Yes Global Yes Yes Yes
language 5.5.0, 5.6.1 Yes Yes Yes Global No Yes Yes Yes
large_files_support Yes Global No Yes Yes Yes
large_page_size Yes Global No Yes Yes Yes
large-pages Yes Yes Yes Global No Yes Yes Yes
last_insert_id Yes Session Yes Yes Yes Yes
Last_query_cost Yes Session No Yes Yes Yes
Last_query_partial_plans 5.6.5 Yes Session No Yes Yes Yes
lc-messages Yes Yes Yes Both Yes Yes Yes Yes
lc-messages-dir Yes Yes Yes Global No Yes Yes Yes
lc_time_names Yes Yes Yes Both Yes Yes Yes Yes
license Yes Global No Yes Yes Yes
local_infile Yes Yes Yes Global Yes Yes Yes Yes
local-service Yes Yes Yes Yes
lock_order 8.0.17 Yes Yes Yes Global No Yes
lock_order_debug_loop 8.0.17 Yes Yes Yes Global No Yes
lock_order_debug_missing_arc 8.0.17 Yes Yes Yes Global No Yes
lock_order_debug_missing_key 8.0.17 Yes Yes Yes Global No Yes
lock_order_debug_missing_unlock 8.0.17 Yes Yes Yes Global No Yes
lock_order_dependencies 8.0.17 Yes Yes Yes Global No Yes
lock_order_extra_dependencies 8.0.17 Yes Yes Yes Global No Yes
lock_order_output_directory 8.0.17 Yes Yes Yes Global No Yes
lock_order_print_txt 8.0.17 Yes Yes Yes Global No Yes
lock_order_trace_loop 8.0.17 Yes Yes Yes Global No Yes
lock_order_trace_missing_arc 8.0.17 Yes Yes Yes Global No Yes
lock_order_trace_missing_key 8.0.17 Yes Yes Yes Global No Yes
lock_order_trace_missing_unlock 8.0.17 Yes Yes Yes Global No Yes
lock_wait_timeout Yes Yes Yes Both Yes Yes Yes Yes
Locked_connects 5.7.6 Yes Global No Yes Yes
locked_in_memory Yes Global No Yes Yes Yes
log 5.1.29 5.6.1 Yes Yes Yes Global Yes Yes
log_backward_compatible_user_definitions 5.7.6 5.7.9 Yes Yes Yes Global Yes Yes
log-bin Yes Yes Yes Yes Yes
log_bin Yes Global No Yes Yes Yes
log_bin_basename 5.6.2 Yes Global No Yes Yes Yes
log-bin-index Yes Yes Yes Global No Yes Yes Yes
log_bin_trust_function_creators Yes Yes Yes Global Yes Yes Yes Yes
log_bin_use_v1_row_events 5.6.6 8.0.18 Yes Yes Yes Global No Yes Yes Yes
log_builtin_as_identified_by_password 5.7.9 8.0.11 Yes Yes Yes Global Yes Yes Yes
log-error Yes Yes Yes Global No Yes Yes Yes
log_error_filter_rules 8.0.2 8.0.4 Yes Yes Yes Global Yes Yes
log_error_services 8.0.2 Yes Yes Yes Global Yes Yes
log_error_suppression_list 8.0.13 Yes Yes Yes Global Yes Yes
log_error_verbosity 5.7.2 Yes Yes Yes Global Yes Yes Yes
log-isam Yes Yes Yes Yes Yes
log_output Yes Yes Yes Global Yes Yes Yes Yes
log_queries_not_using_indexes Yes Yes Yes Global Yes Yes Yes Yes
log-raw 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
log-short-format Yes Yes Yes Yes Yes
log_slave_updates Yes Yes Yes Global No Yes Yes Yes
log-slow-admin-statements 5.6.11, 5.7.1 Yes Yes Yes Yes
log_slow_admin_statements 5.6.11, 5.7.1 Yes Yes Yes Global Yes Yes Yes Yes
log_slow_extra 8.0.14 Yes Yes Yes Global Yes Yes
log_slow_queries 5.1.29 5.6.1 Yes Yes Yes Global Yes Yes
log-slow-slave-statements 5.6.11, 5.7.1 Yes Yes Yes Yes
log_slow_slave_statements 5.6.11, 5.7.1 Yes Yes Yes Global Yes Yes Yes Yes
log_statements_unsafe_for_binlog 5.7.11 Yes Yes Yes Global Yes Yes Yes
log_syslog 5.7.5 8.0.2 8.0.13 Yes Yes Yes Global Yes Yes Yes
log_syslog_facility 5.7.5 8.0.13 Yes Yes Yes Global Yes Yes Yes
log_syslog_include_pid 5.7.5 8.0.13 Yes Yes Yes Global Yes Yes Yes
log_syslog_tag 5.7.5 8.0.13 Yes Yes Yes Global Yes Yes Yes
log-tc Yes Yes Yes Yes Yes
log-tc-size Yes Yes Yes Yes Yes
log_throttle_queries_not_using_indexes 5.6.5 Yes Yes Yes Global Yes Yes Yes Yes
log_timestamps 5.7.2 Yes Yes Yes Global Yes Yes Yes
log-warnings 5.7.2 8.0.3 Yes Yes Yes Varies Yes Yes Yes Yes
long_query_time Yes Yes Yes Both Yes Yes Yes Yes
low_priority_updates Yes Yes Yes Both Yes Yes Yes Yes
lower_case_file_system Yes Global No Yes Yes Yes
lower_case_table_names Yes Yes Yes Global No Yes Yes Yes
mandatory_roles 8.0.2 Yes Yes Yes Global Yes Yes
master-info-file 8.0.18 Yes Yes Yes Yes Yes
master_info_repository 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
master-retry-count 5.6.1 Yes Yes Yes Yes Yes
master_verify_checksum 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
max_allowed_packet Yes Yes Yes Both Yes Yes Yes Yes
max_binlog_cache_size Yes Yes Yes Global Yes Yes Yes Yes
max-binlog-dump-events Yes Yes Yes Yes Yes
max_binlog_size Yes Yes Yes Global Yes Yes Yes Yes
max_binlog_stmt_cache_size 5.6.1 Yes Yes Yes Global Yes Yes Yes Yes
max_connect_errors Yes Yes Yes Global Yes Yes Yes Yes
max_connections Yes Yes Yes Global Yes Yes Yes Yes
max_delayed_threads 5.6.7 Yes Yes Yes Both Yes Yes Yes Yes
max_digest_length 5.6.24, 5.7.6 Yes Yes Yes Global No Yes Yes Yes
max_error_count Yes Yes Yes Both Yes Yes Yes Yes
max_execution_time 5.7.8 Yes Yes Yes Both Yes Yes Yes
Max_execution_time_exceeded 5.7.8 Yes Both No Yes Yes
Max_execution_time_set 5.7.8 Yes Both No Yes Yes
Max_execution_time_set_failed 5.7.8 Yes Both No Yes Yes
max_heap_table_size Yes Yes Yes Both Yes Yes Yes Yes
max_insert_delayed_threads 5.6.7 Yes Both Yes Yes Yes Yes
max_join_size Yes Yes Yes Both Yes Yes Yes Yes
max_length_for_sort_data 8.0.20 Yes Yes Yes Both Yes Yes Yes Yes
max_points_in_geometry 5.7.8 Yes Yes Yes Both Yes Yes Yes
max_prepared_stmt_count Yes Yes Yes Global Yes Yes Yes Yes
max_relay_log_size Yes Yes Yes Global Yes Yes Yes Yes
max_seeks_for_key Yes Yes Yes Both Yes Yes Yes Yes
max_sort_length Yes Yes Yes Both Yes Yes Yes Yes
max_sp_recursion_depth Yes Yes Yes Both Yes Yes Yes Yes
max_statement_time 5.7.4 5.7.8 Yes Both Yes Yes
Max_statement_time_exceeded 5.7.4 5.7.8 Yes Both No Yes
Max_statement_time_set 5.7.4 5.7.8 Yes Both No Yes
Max_statement_time_set_failed 5.7.4 5.7.8 Yes Both No Yes
max_tmp_tables 5.6.7 8.0.3 Yes Both Yes Yes Yes Yes
Max_used_connections Yes Global No Yes Yes Yes
Max_used_connections_time 5.7.5 Yes Global No Yes Yes
max_user_connections Yes Yes Yes Both Yes Yes Yes Yes
max_write_lock_count Yes Yes Yes Global Yes Yes Yes Yes
mecab_charset 5.7.6 Yes Global No Yes Yes
mecab_rc_file 5.7.6 Yes Yes Yes Global No Yes Yes
memlock Yes Yes Yes Yes Yes
metadata_locks_cache_size 5.6.4 5.7.4 8.0.13 Yes Yes Yes Global No Yes Yes Yes
metadata_locks_hash_instances 5.6.8 5.7.4 8.0.13 Yes Yes Yes Global No Yes Yes Yes
min_examined_row_limit Yes Yes Yes Both Yes Yes Yes Yes
multi_range_count 5.6.7 8.0.3 Yes Yes Yes Both Yes Yes Yes Yes
myisam-block-size Yes Yes Yes Yes Yes
myisam_data_pointer_size Yes Yes Yes Global Yes Yes Yes Yes
myisam_max_sort_file_size Yes Yes Yes Global Yes Yes Yes Yes
myisam_mmap_size Yes Yes Yes Global No Yes Yes Yes
myisam_recover_options Yes Yes Yes Global No Yes Yes Yes
myisam_repair_threads Yes Yes Yes Both Yes Yes Yes Yes
myisam_sort_buffer_size Yes Yes Yes Both Yes Yes Yes Yes
myisam_stats_method Yes Yes Yes Both Yes Yes Yes Yes
myisam_use_mmap Yes Yes Yes Global Yes Yes Yes Yes
mysql_firewall_max_query_size 5.6.24 5.6.26 Yes Yes Yes Global No Yes
mysql_firewall_mode 5.6.24, 5.7.9, 8.0.11 Yes Yes Yes Global Yes Yes Yes Yes
mysql_firewall_trace 5.6.24, 5.7.9, 8.0.11 Yes Yes Yes Global Yes Yes Yes Yes
mysql_native_password_proxy_users 5.7.7 Yes Yes Yes Global Yes Yes Yes
mysqlx 5.7.12, 8.0.11 Yes Yes Yes Yes
Mysqlx_aborted_clients Yes Global No Yes
Mysqlx_address Yes Global No Yes Yes
mysqlx_bind_address 5.7.17 Yes Yes Yes Global No Yes Yes
Mysqlx_bytes_received Yes Both No Yes Yes
Mysqlx_bytes_received_compressed_payload 8.0.19 Yes Both No Yes
Mysqlx_bytes_received_uncompressed_frame 8.0.19 Yes Both No Yes
Mysqlx_bytes_sent Yes Both No Yes Yes
Mysqlx_bytes_sent_compressed_payload 8.0.19 Yes Both No Yes
Mysqlx_bytes_sent_uncompressed_frame 8.0.19 Yes Both No Yes
Mysqlx_compression_algorithm 8.0.20 Yes Session No Yes
mysqlx_compression_algorithms 8.0.19 Yes Yes Yes Global Yes Yes
Mysqlx_compression_level 8.0.20 Yes Session No Yes
mysqlx_connect_timeout 5.7.12 Yes Yes Yes Global Yes Yes Yes
Mysqlx_connection_accept_errors Yes Both No Yes Yes
Mysqlx_connection_errors Yes Both No Yes Yes
Mysqlx_connections_accepted Yes Global No Yes Yes
Mysqlx_connections_closed Yes Global No Yes Yes
Mysqlx_connections_rejected Yes Global No Yes Yes
Mysqlx_crud_create_view Yes Both No Yes Yes
Mysqlx_crud_delete Yes Both No Yes Yes
Mysqlx_crud_drop_view Yes Both No Yes Yes
Mysqlx_crud_find Yes Both No Yes Yes
Mysqlx_crud_insert Yes Both No Yes Yes
Mysqlx_crud_modify_view Yes Both No Yes Yes
Mysqlx_crud_update Yes Both No Yes Yes
Mysqlx_cursor_close Yes Both No Yes
Mysqlx_cursor_fetch Yes Both No Yes
Mysqlx_cursor_open Yes Both No Yes
mysqlx_deflate_default_compression_level 8.0.20 Yes Yes Yes Global Yes Yes
mysqlx_deflate_max_client_compression_level 8.0.20 Yes Yes Yes Global Yes Yes
mysqlx_document_id_unique_prefix Yes Yes Yes Global Yes Yes
mysqlx_enable_hello_notice Yes Yes Yes Global Yes Yes
Mysqlx_errors_sent Yes Both No Yes Yes
Mysqlx_errors_unknown_message_type Yes Both No Yes Yes
Mysqlx_expect_close Yes Both No Yes Yes
Mysqlx_expect_open Yes Both No Yes Yes
mysqlx_idle_worker_thread_timeout 5.7.12 Yes Yes Yes Global Yes Yes Yes
Mysqlx_init_error Yes Both No Yes Yes
mysqlx_interactive_timeout 8.0.4 Yes Yes Yes Global Yes Yes
mysqlx_lz4_default_compression_level 8.0.20 Yes Yes Yes Global Yes Yes
mysqlx_lz4_max_client_compression_level 8.0.20 Yes Yes Yes Global Yes Yes
mysqlx_max_allowed_packet 5.7.12 Yes Yes Yes Global Yes Yes Yes
mysqlx_max_connections 5.7.12 Yes Yes Yes Global Yes Yes Yes
mysqlx_min_worker_threads 5.7.12 Yes Yes Yes Global Yes Yes Yes
Mysqlx_notice_global_sent Yes Both No Yes
Mysqlx_notice_other_sent Yes Both No Yes Yes
Mysqlx_notice_warning_sent Yes Both No Yes Yes
Mysqlx_notified_by_group_replication Yes Both No Yes
Mysqlx_port Yes Global No Yes Yes
mysqlx_port 5.7.12 Yes Yes Yes Global No Yes Yes
mysqlx_port_open_timeout 5.7.17 Yes Yes Yes Global No Yes Yes
Mysqlx_prep_deallocate Yes Both No Yes
Mysqlx_prep_execute Yes Both No Yes
Mysqlx_prep_prepare Yes Both No Yes
mysqlx_read_timeout 8.0.4 Yes Yes Yes Session Yes Yes
Mysqlx_rows_sent Yes Both No Yes Yes
Mysqlx_sessions Yes Global No Yes Yes
Mysqlx_sessions_accepted Yes Global No Yes Yes
Mysqlx_sessions_closed Yes Global No Yes Yes
Mysqlx_sessions_fatal_error Yes Global No Yes Yes
Mysqlx_sessions_killed Yes Global No Yes Yes
Mysqlx_sessions_rejected Yes Global No Yes Yes
Mysqlx_socket Yes Global No Yes Yes
mysqlx_socket 5.7.15 Yes Yes Yes Global No Yes Yes
Mysqlx_ssl_accept_renegotiates Yes Global No Yes Yes
Mysqlx_ssl_accepts Yes Global No Yes Yes
Mysqlx_ssl_active Yes Both No Yes Yes
mysqlx_ssl_ca 5.7.12 Yes Yes Yes Global No Yes Yes
mysqlx_ssl_capath 5.7.12 Yes Yes Yes Global No Yes Yes
mysqlx_ssl_cert 5.7.12 Yes Yes Yes Global No Yes Yes
Mysqlx_ssl_cipher Yes Both No Yes Yes
mysqlx_ssl_cipher 5.7.12 Yes Yes Yes Global No Yes Yes
Mysqlx_ssl_cipher_list Yes Both No Yes Yes
mysqlx_ssl_crl 5.7.12 Yes Yes Yes Global No Yes Yes
mysqlx_ssl_crlpath 5.7.12 Yes Yes Yes Global No Yes Yes
Mysqlx_ssl_ctx_verify_depth Yes Both No Yes Yes
Mysqlx_ssl_ctx_verify_mode Yes Both No Yes Yes
Mysqlx_ssl_finished_accepts Yes Global No Yes Yes
mysqlx_ssl_key 5.7.12 Yes Yes Yes Global No Yes Yes
Mysqlx_ssl_server_not_after Yes Global No Yes Yes
Mysqlx_ssl_server_not_before Yes Global No Yes Yes
Mysqlx_ssl_verify_depth Yes Global No Yes Yes
Mysqlx_ssl_verify_mode Yes Global No Yes Yes
Mysqlx_ssl_version Yes Both No Yes Yes
Mysqlx_stmt_create_collection Yes Both No Yes Yes
Mysqlx_stmt_create_collection_index Yes Both No Yes Yes
Mysqlx_stmt_disable_notices Yes Both No Yes Yes
Mysqlx_stmt_drop_collection Yes Both No Yes Yes
Mysqlx_stmt_drop_collection_index Yes Both No Yes Yes
Mysqlx_stmt_enable_notices Yes Both No Yes Yes
Mysqlx_stmt_ensure_collection Yes Both No Yes Yes
Mysqlx_stmt_execute_mysqlx Yes Both No Yes Yes
Mysqlx_stmt_execute_sql Yes Both No Yes Yes
Mysqlx_stmt_execute_xplugin Yes Both No Yes Yes
Mysqlx_stmt_get_collection_options Yes Both No Yes
Mysqlx_stmt_kill_client Yes Both No Yes Yes
Mysqlx_stmt_list_clients Yes Both No Yes Yes
Mysqlx_stmt_list_notices Yes Both No Yes Yes
Mysqlx_stmt_list_objects Yes Both No Yes Yes
Mysqlx_stmt_modify_collection_options Yes Both No Yes
Mysqlx_stmt_ping Yes Both No Yes Yes
mysqlx_wait_timeout 8.0.4 Yes Yes Yes Session Yes Yes
Mysqlx_worker_threads Yes Global No Yes Yes
Mysqlx_worker_threads_active Yes Global No Yes Yes
mysqlx_write_timeout 8.0.4 Yes Yes Yes Session Yes Yes
mysqlx_zstd_default_compression_level 8.0.20 Yes Yes Yes Global Yes Yes
mysqlx_zstd_max_client_compression_level 8.0.20 Yes Yes Yes Global Yes Yes
named_pipe Yes Yes Yes Global No Yes Yes Yes
named_pipe_full_access_group 5.6.43, 5.7.25, 8.0.14 Yes Yes Yes Global No Yes Yes Yes
ndb-allow-copying-alter-table 5.7.10-ndb-7.5.0 Yes Yes Yes Both Yes Yes Yes
Ndb_api_bytes_received_count Yes Global No Yes Yes Yes
Ndb_api_bytes_received_count_session Yes Session No Yes Yes Yes
Ndb_api_bytes_received_count_slave Yes Global No Yes Yes Yes
Ndb_api_bytes_sent_count Yes Global No Yes Yes Yes
Ndb_api_bytes_sent_count_session Yes Session No Yes Yes Yes
Ndb_api_bytes_sent_count_slave Yes Global No Yes Yes Yes
Ndb_api_event_bytes_count Yes Global No Yes Yes Yes
Ndb_api_event_bytes_count_injector Yes Global No Yes Yes Yes
Ndb_api_event_data_count Yes Global No Yes Yes Yes
Ndb_api_event_data_count_injector Yes Global No Yes Yes Yes
Ndb_api_event_nondata_count Yes Global No Yes Yes Yes
Ndb_api_event_nondata_count_injector Yes Global No Yes Yes Yes
Ndb_api_pk_op_count Yes Global No Yes Yes Yes
Ndb_api_pk_op_count_session Yes Session No Yes Yes Yes
Ndb_api_pk_op_count_slave Yes Global No Yes Yes Yes
Ndb_api_pruned_scan_count Yes Global No Yes Yes Yes
Ndb_api_pruned_scan_count_session Yes Session No Yes Yes Yes
Ndb_api_pruned_scan_count_slave Yes Global No Yes Yes Yes
Ndb_api_range_scan_count Yes Global No Yes Yes Yes
Ndb_api_range_scan_count_session Yes Session No Yes Yes Yes
Ndb_api_range_scan_count_slave Yes Global No Yes Yes Yes
Ndb_api_read_row_count Yes Global No Yes Yes Yes
Ndb_api_read_row_count_session Yes Session No Yes Yes Yes
Ndb_api_read_row_count_slave Yes Global No Yes Yes Yes
Ndb_api_scan_batch_count Yes Global No Yes Yes Yes
Ndb_api_scan_batch_count_session Yes Session No Yes Yes Yes
Ndb_api_scan_batch_count_slave Yes Global No Yes Yes Yes
Ndb_api_table_scan_count Yes Global No Yes Yes Yes
Ndb_api_table_scan_count_session Yes Session No Yes Yes Yes
Ndb_api_table_scan_count_slave Yes Global No Yes Yes Yes
Ndb_api_trans_abort_count Yes Global No Yes Yes Yes
Ndb_api_trans_abort_count_session Yes Session No Yes Yes Yes
Ndb_api_trans_abort_count_slave Yes Global No Yes Yes Yes
Ndb_api_trans_close_count Yes Global No Yes Yes Yes
Ndb_api_trans_close_count_session Yes Session No Yes Yes Yes
Ndb_api_trans_close_count_slave Yes Global No Yes Yes Yes
Ndb_api_trans_commit_count Yes Global No Yes Yes Yes
Ndb_api_trans_commit_count_session Yes Session No Yes Yes Yes
Ndb_api_trans_commit_count_slave Yes Global No Yes Yes Yes
Ndb_api_trans_local_read_row_count Yes Global No Yes Yes Yes
Ndb_api_trans_local_read_row_count_session Yes Session No Yes Yes Yes
Ndb_api_trans_local_read_row_count_slave Yes Global No Yes Yes Yes
Ndb_api_trans_start_count Yes Global No Yes Yes Yes
Ndb_api_trans_start_count_session Yes Session No Yes Yes Yes
Ndb_api_trans_start_count_slave Yes Global No Yes Yes Yes
Ndb_api_uk_op_count Yes Global No Yes Yes Yes
Ndb_api_uk_op_count_session Yes Session No Yes Yes Yes
Ndb_api_uk_op_count_slave Yes Global No Yes Yes Yes
Ndb_api_wait_exec_complete_count Yes Global No Yes Yes Yes
Ndb_api_wait_exec_complete_count_session Yes Session No Yes Yes Yes
Ndb_api_wait_exec_complete_count_slave Yes Global No Yes Yes Yes
Ndb_api_wait_meta_request_count Yes Global No Yes Yes Yes
Ndb_api_wait_meta_request_count_session Yes Session No Yes Yes Yes
Ndb_api_wait_meta_request_count_slave Yes Global No Yes Yes Yes
Ndb_api_wait_nanos_count Yes Global No Yes Yes Yes
Ndb_api_wait_nanos_count_session Yes Session No Yes Yes Yes
Ndb_api_wait_nanos_count_slave Yes Global No Yes Yes Yes
Ndb_api_wait_scan_result_count Yes Global No Yes Yes Yes
Ndb_api_wait_scan_result_count_session Yes Session No Yes Yes Yes
Ndb_api_wait_scan_result_count_slave Yes Global No Yes Yes Yes
ndb_autoincrement_prefetch_sz Yes Yes Yes Both Yes Yes Yes Yes
ndb-batch-size Yes Yes Yes Global No Yes Yes Yes
ndb-blob-read-batch-bytes Yes Yes Yes Both Yes Yes Yes Yes
ndb-blob-write-batch-bytes Yes Yes Yes Both Yes Yes Yes Yes
ndb_cache_check_time 5.7.20 Yes Yes Yes Global Yes Yes Yes Yes
ndb_clear_apply_status 5.6.28-ndb-7.4.9 Yes Yes Global Yes Yes Yes Yes
ndb-cluster-connection-pool Yes Yes Yes Global No Yes Yes Yes
ndb-cluster-connection-pool-nodeids 5.7.10-ndb-7.5.0 Yes Yes Yes Global No Yes Yes
Ndb_cluster_node_id Yes Global No Yes Yes Yes
Ndb_config_from_host Yes Both No Yes Yes Yes
Ndb_config_from_port Yes Both No Yes Yes Yes
Ndb_conflict_fn_epoch Yes Global No Yes Yes Yes
Ndb_conflict_fn_epoch_trans Yes Global No Yes Yes Yes
Ndb_conflict_fn_epoch2 5.6.21-ndb-7.4.2 Yes Global No Yes Yes Yes
Ndb_conflict_fn_epoch2_trans 5.6.21-ndb-7.4.2 Yes Global No Yes Yes Yes
Ndb_conflict_fn_max Yes Global No Yes Yes Yes
Ndb_conflict_fn_max_del_win 5.6.21-ndb-7.4.1 Yes Global No Yes
Ndb_conflict_fn_old Yes Global No Yes Yes Yes
Ndb_conflict_last_conflict_epoch 5.6.21-ndb-7.4.2 Yes Global No Yes Yes Yes
Ndb_conflict_last_stable_epoch 5.6.21-ndb-7.4.2 Yes Global No Yes Yes Yes
Ndb_conflict_reflected_op_discard_count 5.6.21-ndb-7.4.2 Yes Global No Yes Yes Yes
Ndb_conflict_reflected_op_prepare_count 5.6.21-ndb-7.4.2 Yes Global No Yes Yes Yes
Ndb_conflict_refresh_op_count 5.6.21-ndb-7.4.2 Yes Global No Yes Yes Yes
Ndb_conflict_trans_conflict_commit_count Yes Global No Yes Yes Yes
Ndb_conflict_trans_detect_iter_count Yes Global No Yes Yes Yes
Ndb_conflict_trans_reject_count Yes Global No Yes Yes Yes
Ndb_conflict_trans_row_conflict_count 5.6.21-ndb-7.4.2 Yes Global No Yes Yes Yes
Ndb_conflict_trans_row_reject_count Yes Global No Yes Yes Yes
ndb-connectstring Yes Yes Yes Yes Yes
ndb_data_node_neighbour 5.7.12-ndb-7.5.2 Yes Yes Yes Global Yes Yes Yes
ndb_dbg_check_shares 8.0.13-ndb-8.0.13 Yes Yes Yes Both Yes Yes
ndb-default-column-format 5.7.11-ndb-7.5.1 Yes Yes Yes Global Yes Yes Yes
ndb_default_column_format 5.7.11-ndb-7.5.1 Yes Yes Yes Global Yes Yes Yes
ndb-deferred-constraints Yes Yes Yes Both Yes Yes Yes Yes
ndb_deferred_constraints Yes Yes Yes Both Yes Yes Yes Yes
ndb-distribution Yes Yes Yes Global Yes Yes Yes Yes
ndb_distribution Yes Yes Yes Global Yes Yes Yes Yes
Ndb_epoch_delete_delete_count 5.6.22-ndb-7.4.2 Yes Global No Yes Yes Yes
ndb_eventbuffer_free_percent 5.6.22-ndb-7.4.3 Yes Yes Yes Global Yes Yes Yes Yes
ndb_eventbuffer_max_alloc 5.6.14-ndb-7.3.3 Yes Yes Yes Global Yes Yes Yes Yes
Ndb_execute_count Yes Global No Yes Yes Yes
ndb_extra_logging Yes Yes Yes Global Yes Yes Yes Yes
ndb_force_send Yes Yes Yes Both Yes Yes Yes Yes
ndb_fully_replicated 5.7.12-ndb-7-5-2 Yes Yes Yes Both Yes Yes Yes
ndb_index_stat_cache_entries 5.1.19 5.6.16-ndb-7.3.5 Yes Yes Yes Both Yes Yes
ndb_index_stat_enable Yes Yes Yes Both Yes Yes Yes Yes
ndb_index_stat_option Yes Yes Yes Both Yes Yes Yes Yes
ndb_index_stat_update_freq 5.1.19 5.6.16-ndb-7.3.5 Yes Yes Yes Both Yes Yes
ndb_join_pushdown Yes Both Yes Yes Yes Yes
Ndb_last_commit_epoch_server 5.6.20-ndb-7.4.1 Yes Global No Yes Yes Yes
Ndb_last_commit_epoch_session 5.6.20-ndb-7.4.1 Yes Session No Yes Yes Yes
ndb-log-apply-status Yes Yes Yes Global No Yes Yes Yes
ndb_log_apply_status Yes Yes Yes Global No Yes Yes Yes
ndb_log_bin Yes Yes Both Yes Yes Yes Yes
ndb_log_binlog_index Yes Yes Global Yes Yes Yes Yes
ndb-log-empty-epochs Yes Yes Yes Global Yes Yes Yes Yes
ndb_log_empty_epochs Yes Yes Yes Global Yes Yes Yes Yes
ndb-log-empty-update Yes Yes Yes Global Yes Yes Yes Yes
ndb_log_empty_update Yes Yes Yes Global Yes Yes Yes Yes
ndb-log-exclusive-reads 5.6.20-ndb-7.4.1 Yes Yes Yes Both Yes Yes Yes Yes
ndb_log_exclusive_reads 5.6.20-ndb-7.4.1 Yes Yes Yes Both Yes Yes Yes Yes
ndb-log-fail-terminate 5.6.47-ndb-7.4.28, 5.7.29-ndb-7.6.14 Yes Yes Yes Global No Yes Yes
ndb-log-orig Yes Yes Yes Global No Yes Yes Yes
ndb_log_orig Yes Yes Yes Global No Yes Yes Yes
ndb-log-transaction-id Yes Yes Yes Global No Yes Yes Yes
ndb_log_transaction_id Yes Global No Yes Yes Yes
ndb-log-update-as-write Yes Yes Yes Global Yes Yes Yes Yes
ndb-log-update-minimal 5.6.36-ndb-7.4.16, 5.7.18-ndb-7.6.3 Yes Yes Yes Global Yes Yes Yes Yes
ndb-log-updated-only Yes Yes Yes Global Yes Yes Yes Yes
Ndb_metadata_blacklist_size 8.0.18-ndb-8.0.18 Yes Global No Yes
ndb_metadata_check 8.0.16-ndb-8.0.16 Yes Yes Yes Global Yes Yes
ndb_metadata_check_interval 8.0.16-ndb-8.0.16 Yes Yes Yes Global Yes Yes
Ndb_metadata_detected_count 8.0.16-ndb-8.0.16 Yes Global No Yes
ndb_metadata_sync 8.0.19-ndb-8.0.19 Yes Global Yes Yes
Ndb_metadata_synced_count 8.0.18-ndb-8.0.18 Yes Global No Yes
ndb-mgmd-host Yes Yes Yes Yes Yes
ndb-nodeid Yes Yes Yes Global No Yes Yes Yes
Ndb_number_of_data_nodes Yes Global No Yes Yes Yes
ndb-optimization-delay Yes Yes Yes Global Yes Yes Yes Yes
ndb_optimized_node_selection Yes Yes Yes Global No Yes Yes Yes
Ndb_pruned_scan_count Yes Global No Yes Yes Yes
Ndb_pushed_queries_defined Yes Global No Yes Yes Yes
Ndb_pushed_queries_dropped Yes Global No Yes Yes Yes
Ndb_pushed_queries_executed Yes Global No Yes Yes Yes
Ndb_pushed_reads Yes Global No Yes Yes Yes
ndb_read_backup 5.7.12-ndb-7.5.2 Yes Yes Yes Global Yes Yes Yes
ndb_recv_thread_activation_threshold 5.6.10-ndb-7.3.1 Yes Yes Yes Global Yes Yes Yes Yes
ndb_recv_thread_cpu_mask 5.6.10-ndb-7.3.1 Yes Yes Yes Global Yes Yes Yes Yes
ndb_report_thresh_binlog_epoch_slip Yes Yes Yes Global Yes Yes Yes Yes
ndb_report_thresh_binlog_mem_usage Yes Yes Yes Global Yes Yes Yes Yes
ndb_row_checksum 5.7.23-ndb-7.6.8 Yes Both Yes Yes Yes
Ndb_scan_count Yes Global No Yes Yes Yes
ndb_schema_dist_lock_wait_timeout 8.0.18-ndb-8.0.18 Yes Yes Yes Global Yes Yes
ndb-schema-dist-timeout 8.0.17-ndb-8.0.17 Yes Yes Yes Global No Yes
ndb_schema_dist_timeout 8.0.16-ndb-8.0.16 Yes Yes Yes Global No Yes
ndb_schema_dist_upgrade_allowed 8.0.17-ndb-8.0.17 Yes Yes Yes Global No Yes
ndb_show_foreign_key_mock_tables 5.6.11-ndb-7.3.2 Yes Yes Yes Global Yes Yes Yes Yes
ndb_slave_conflict_role 5.6.20-ndb-7.4.1 Yes Yes Yes Global Yes Yes Yes Yes
Ndb_slave_max_replicated_epoch 5.6.20-ndb-7.4.1 Yes Global No Yes Yes Yes
Ndb_system_name 5.7.18-ndb-7.6.2 Yes Global No Yes Yes
ndb_table_no_logging Yes Session Yes Yes Yes Yes
ndb_table_temporary Yes Session Yes Yes Yes Yes
Ndb_trans_hint_count_session 8.0.17-ndb-8.0.17 Yes Both No Yes
ndb-transid-mysql-connection-map Yes Yes Yes Yes
ndb_use_copying_alter_table Yes Both No Yes Yes Yes
ndb_use_exact_count Yes Both Yes Yes Yes Yes
ndb_use_transactions Yes Yes Yes Both Yes Yes Yes Yes
ndb_version Yes Global No Yes Yes Yes
ndb_version_string Yes Global No Yes Yes Yes
ndb-wait-connected Yes Yes Yes Global No Yes Yes Yes
ndb-wait-setup Yes Yes Yes Global No Yes Yes Yes
ndbcluster Yes Yes Yes Yes Yes
ndbinfo 8.0.13-ndb-8.0.13 Yes Yes
ndbinfo_database Yes Global No Yes Yes Yes
ndbinfo_max_bytes Yes Yes Both Yes Yes Yes Yes
ndbinfo_max_rows Yes Yes Both Yes Yes Yes Yes
ndbinfo_offline Yes Global Yes Yes Yes Yes
ndbinfo_show_hidden Yes Yes Both Yes Yes Yes Yes
ndbinfo_table_prefix Yes Yes Both Yes Yes Yes Yes
ndbinfo_version Yes Global No Yes Yes Yes
net_buffer_length Yes Yes Yes Both Yes Yes Yes Yes
net_read_timeout Yes Yes Yes Both Yes Yes Yes Yes
net_retry_count Yes Yes Yes Both Yes Yes Yes Yes
net_write_timeout Yes Yes Yes Both Yes Yes Yes Yes
new Yes Yes Yes Both Yes Yes Yes Yes
ngram_token_size 5.7.6 Yes Yes Yes Global No Yes Yes
no-dd-upgrade 8.0.4 8.0.16 Yes Yes Yes
no-defaults Yes Yes Yes Yes
no-monitor 8.0.12 Yes Yes Yes
Not_flushed_delayed_rows 5.6.7 Yes Global No Yes Yes Yes
offline_mode 5.7.5 Yes Yes Yes Global Yes Yes Yes
old Yes Yes Yes Global No Yes Yes Yes
old_alter_table Yes Yes Yes Both Yes Yes Yes Yes
old_passwords 5.7.6 8.0.11 Yes Yes Yes Both Yes Yes Yes Yes
old-style-user-limits Yes Yes Yes Yes Yes
one-thread 5.6.1 Yes Yes Yes
Ongoing_anonymous_gtid_violating_transaction_count Yes Global No Yes Yes
Ongoing_anonymous_transaction_count Yes Global No Yes Yes
Ongoing_automatic_gtid_violating_transaction_count Yes Global No Yes Yes
Open_files Yes Global No Yes Yes Yes
open_files_limit Yes Yes Yes Global No Yes Yes Yes
Open_streams Yes Global No Yes Yes Yes
Open_table_definitions Yes Global No Yes Yes Yes
Open_tables Yes Both No Yes Yes Yes
Opened_files Yes Global No Yes Yes Yes
Opened_table_definitions Yes Both No Yes Yes Yes
Opened_tables Yes Both No Yes Yes Yes
optimizer_join_cache_level 5.6.1 5.6.3 Yes Yes Yes Both Yes Yes
optimizer_prune_level Yes Yes Yes Both Yes Yes Yes Yes
optimizer_search_depth Yes Yes Yes Both Yes Yes Yes Yes
optimizer_switch Yes Yes Yes Both Yes Yes Yes Yes
optimizer_trace 5.6.3 Yes Yes Yes Both Yes Yes Yes Yes
optimizer_trace_features 5.6.3 Yes Yes Yes Both Yes Yes Yes Yes
optimizer_trace_limit 5.6.3 Yes Yes Yes Both Yes Yes Yes Yes
optimizer_trace_max_mem_size 5.6.3 Yes Yes Yes Both Yes Yes Yes Yes
optimizer_trace_offset 5.6.3 Yes Yes Yes Both Yes Yes Yes Yes
original_commit_timestamp 8.0.1 Yes Session Yes Yes
original_server_version 8.0.14 Yes Session Yes Yes
parser_max_mem_size 5.7.12 Yes Yes Yes Both Yes Yes Yes
partial_revokes 8.0.16 Yes Yes Yes Global Yes Yes
partition 5.7.16 Yes Yes Yes Yes
password_history 8.0.3 Yes Yes Yes Global Yes Yes
password_require_current 8.0.13 Yes Yes Yes Global Yes Yes
password_reuse_interval 8.0.3 Yes Yes Yes Global Yes Yes
performance_schema Yes Yes Yes Global No Yes Yes Yes
Performance_schema_accounts_lost 5.6.3 Yes Global No Yes Yes Yes
performance_schema_accounts_size 5.6.3 Yes Yes Yes Global No Yes Yes Yes
Performance_schema_cond_classes_lost Yes Global No Yes Yes Yes
Performance_schema_cond_instances_lost Yes Global No Yes Yes Yes
performance-schema-consumer-events-stages-current 5.6.4 Yes Yes Yes Yes Yes
performance-schema-consumer-events-stages-history 5.6.4 Yes Yes Yes Yes Yes
performance-schema-consumer-events-stages-history-long 5.6.4 Yes Yes Yes Yes Yes
performance-schema-consumer-events-statements-current 5.6.4 Yes Yes Yes Yes Yes
performance-schema-consumer-events-statements-history 5.6.4 Yes Yes Yes Yes Yes
performance-schema-consumer-events-statements-history-long 5.6.4 Yes Yes Yes Yes Yes
performance-schema-consumer-events-transactions-current 5.7.3 Yes Yes Yes Yes
performance-schema-consumer-events-transactions-history 5.7.3 Yes Yes Yes Yes
performance-schema-consumer-events-transactions-history-long 5.7.3 Yes Yes Yes Yes
performance-schema-consumer-events-waits-current 5.6.4 Yes Yes Yes Yes Yes
performance-schema-consumer-events-waits-history 5.6.4 Yes Yes Yes Yes Yes
performance-schema-consumer-events-waits-history-long 5.6.4 Yes Yes Yes Yes Yes
performance-schema-consumer-global-instrumentation 5.6.4 Yes Yes Yes Yes Yes
performance-schema-consumer-statements-digest 5.6.5 Yes Yes Yes Yes Yes
performance-schema-consumer-thread-instrumentation 5.6.4 Yes Yes Yes Yes Yes
Performance_schema_digest_lost 5.6.5 Yes Global No Yes Yes Yes
performance_schema_digests_size 5.6.5 Yes Yes Yes Global No Yes Yes Yes
performance_schema_error_size Yes Yes Yes Global No Yes
performance_schema_events_stages_history_long_size 5.6.3 Yes Yes Yes Global No Yes Yes Yes
performance_schema_events_stages_history_size 5.6.3 Yes Yes Yes Global No Yes Yes Yes
performance_schema_events_statements_history_long_size 5.6.3 Yes Yes Yes Global No Yes Yes Yes
performance_schema_events_statements_history_size 5.6.3 Yes Yes Yes Global No Yes Yes Yes
performance_schema_events_transactions_history_long_size 5.7.3 Yes Yes Yes Global No Yes Yes
performance_schema_events_transactions_history_size 5.7.3 Yes Yes Yes Global No Yes Yes
performance_schema_events_waits_history_long_size Yes Yes Yes Global No Yes Yes Yes
performance_schema_events_waits_history_size Yes Yes Yes Global No Yes Yes Yes
Performance_schema_file_classes_lost Yes Global No Yes Yes Yes
Performance_schema_file_handles_lost Yes Global No Yes Yes Yes
Performance_schema_file_instances_lost Yes Global No Yes Yes Yes
Performance_schema_hosts_lost 5.6.3 Yes Global No Yes Yes Yes
performance_schema_hosts_size 5.6.3 Yes Yes Yes Global No Yes Yes Yes
Performance_schema_index_stat_lost 5.7.6 Yes Global No Yes Yes
performance-schema-instrument 5.6.4 Yes Yes Yes Yes Yes
Performance_schema_locker_lost Yes Global No Yes Yes Yes
performance_schema_max_cond_classes Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_cond_instances Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_digest_length 5.6.26, 5.7.8 Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_digest_sample_age 8.0.3 Yes Yes Yes Global Yes Yes
performance_schema_max_file_classes Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_file_handles Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_file_instances Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_index_stat 5.7.6 Yes Yes Yes Global No Yes Yes
performance_schema_max_memory_classes 5.7.2 Yes Yes Yes Global No Yes Yes
performance_schema_max_metadata_locks 5.7.3 Yes Yes Yes Global No Yes Yes
performance_schema_max_mutex_classes Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_mutex_instances Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_prepared_statements_instances 5.7.4 Yes Yes Yes Global No Yes Yes
performance_schema_max_program_instances 5.7.2 Yes Yes Yes Global No Yes Yes
performance_schema_max_rwlock_classes Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_rwlock_instances Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_socket_classes 5.6.3 Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_socket_instances 5.6.3 Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_sql_text_length 5.7.6 Yes Yes Yes Global No Yes Yes
performance_schema_max_stage_classes 5.6.3 Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_statement_classes 5.6.3 Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_statement_stack 5.7.2 Yes Yes Yes Global No Yes Yes
performance_schema_max_table_handles Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_table_instances Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_table_lock_stat 5.7.6 Yes Yes Yes Global No Yes Yes
performance_schema_max_thread_classes Yes Yes Yes Global No Yes Yes Yes
performance_schema_max_thread_instances Yes Yes Yes Global No Yes Yes Yes
Performance_schema_memory_classes_lost 5.7.2 Yes Global No Yes Yes
Performance_schema_metadata_lock_lost 5.7.3 Yes Global No Yes Yes
Performance_schema_mutex_classes_lost Yes Global No Yes Yes Yes
Performance_schema_mutex_instances_lost Yes Global No Yes Yes Yes
Performance_schema_nested_statement_lost 5.7.2 Yes Global No Yes Yes
Performance_schema_prepared_statements_lost 5.7.4 Yes Global No Yes Yes
Performance_schema_program_lost 5.7.2 Yes Global No Yes Yes
Performance_schema_rwlock_classes_lost Yes Global No Yes Yes Yes
Performance_schema_rwlock_instances_lost Yes Global No Yes Yes Yes
Performance_schema_session_connect_attrs_longest_seen Yes Global No Yes
Performance_schema_session_connect_attrs_lost 5.6.6 Yes Global No Yes Yes Yes
performance_schema_session_connect_attrs_size 5.6.6 Yes Yes Yes Global No Yes Yes Yes
performance_schema_setup_actors_size 5.6.1 Yes Yes Yes Global No Yes Yes Yes
performance_schema_setup_objects_size 5.6.1 Yes Yes Yes Global No Yes Yes Yes
Performance_schema_socket_classes_lost 5.6.3 Yes Global No Yes Yes Yes
Performance_schema_socket_instances_lost 5.6.3 Yes Global No Yes Yes Yes
Performance_schema_stage_classes_lost 5.6.3 Yes Global No Yes Yes Yes
Performance_schema_statement_classes_lost 5.6.3 Yes Global No Yes Yes Yes
Performance_schema_table_handles_lost Yes Global No Yes Yes Yes
Performance_schema_table_instances_lost Yes Global No Yes Yes Yes
Performance_schema_table_lock_stat_lost 5.7.6 Yes Global No Yes Yes
Performance_schema_thread_classes_lost Yes Global No Yes Yes Yes
Performance_schema_thread_instances_lost Yes Global No Yes Yes Yes
Performance_schema_users_lost 5.6.3 Yes Global No Yes Yes Yes
performance_schema_users_size 5.6.3 Yes Yes Yes Global No Yes Yes Yes
persist_only_admin_x509_subject 8.0.14 Yes Yes Yes Global No Yes
persisted_globals_load Yes Yes Yes Global No Yes
pid_file Yes Yes Yes Global No Yes Yes Yes
plugin_dir Yes Yes Yes Global No Yes Yes Yes
plugin-load Yes Yes Yes Global No Yes Yes Yes
plugin-load-add 5.6.3 Yes Yes Yes Global No Yes Yes Yes
plugin-xxx Yes Yes Yes Yes Yes
port Yes Yes Yes Global No Yes Yes Yes
port-open-timeout Yes Yes Yes Yes Yes
preload_buffer_size Yes Yes Yes Both Yes Yes Yes Yes
Prepared_stmt_count Yes Global No Yes Yes Yes
print-defaults Yes Yes Yes Yes
print_identified_with_as_hex 8.0.17 Yes Yes Yes Both Yes Yes
profiling 5.6.8 Yes Both Yes Yes Yes Yes
profiling_history_size 5.6.8 Yes Yes Yes Both Yes Yes Yes Yes
protocol_compression_algorithms 8.0.18 Yes Yes Yes Global Yes Yes
protocol_version Yes Global No Yes Yes Yes
proxy_user Yes Session No Yes Yes Yes
pseudo_slave_mode 5.6.10 Yes Session Yes Yes Yes Yes
pseudo_thread_id Yes Session Yes Yes Yes Yes
Qcache_free_blocks 5.7.20 8.0.3 Yes Global No Yes Yes Yes
Qcache_free_memory 5.7.20 8.0.3 Yes Global No Yes Yes Yes
Qcache_hits 5.7.20 8.0.3 Yes Global No Yes Yes Yes
Qcache_inserts 5.7.20 8.0.3 Yes Global No Yes Yes Yes
Qcache_lowmem_prunes 5.7.20 8.0.3 Yes Global No Yes Yes Yes
Qcache_not_cached 5.7.20 8.0.3 Yes Global No Yes Yes Yes
Qcache_queries_in_cache 5.7.20 8.0.3 Yes Global No Yes Yes Yes
Qcache_total_blocks 5.7.20 8.0.3 Yes Global No Yes Yes Yes
Queries Yes Both No Yes Yes Yes
query_alloc_block_size Yes Yes Yes Both Yes Yes Yes Yes
query_cache_limit 5.7.20 8.0.3 Yes Yes Yes Global Yes Yes Yes Yes
query_cache_min_res_unit 5.7.20 8.0.3 Yes Yes Yes Global Yes Yes Yes Yes
query_cache_size 5.7.20 8.0.3 Yes Yes Yes Global Yes Yes Yes Yes
query_cache_type 5.7.20 8.0.3 Yes Yes Yes Both Yes Yes Yes Yes
query_cache_wlock_invalidate 5.7.20 8.0.3 Yes Yes Yes Both Yes Yes Yes Yes
query_prealloc_size Yes Yes Yes Both Yes Yes Yes Yes
Questions Yes Both No Yes Yes Yes
rand_seed1 Yes Session Yes Yes Yes Yes
rand_seed2 Yes Session Yes Yes Yes Yes
range_alloc_block_size Yes Yes Yes Both Yes Yes Yes Yes
range_optimizer_max_mem_size 5.7.9 Yes Yes Yes Both Yes Yes Yes
rbr_exec_mode 5.7.1 Yes Both Yes Yes Yes
read_buffer_size Yes Yes Yes Both Yes Yes Yes Yes
read_only Yes Yes Yes Global Yes Yes Yes Yes
read_rnd_buffer_size Yes Yes Yes Both Yes Yes Yes Yes
regexp_stack_limit 8.0.4 Yes Yes Yes Global Yes Yes
regexp_time_limit 8.0.4 Yes Yes Yes Global Yes Yes
relay_log Yes Yes Yes Global No Yes Yes Yes
relay_log_basename 5.6.2 Yes Global No Yes Yes Yes
relay_log_index Yes Yes Yes Global No Yes Yes Yes
relay_log_info_file 8.0.18 Yes Yes Yes Global No Yes Yes Yes
relay_log_info_repository 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
relay_log_purge Yes Yes Yes Global Yes Yes Yes Yes
relay_log_recovery Yes Yes Yes Global Varies Yes Yes Yes
relay_log_space_limit Yes Yes Yes Global No Yes Yes Yes
remove Yes Yes Yes Yes
replicate-do-db Yes Yes Yes Yes Yes
replicate-do-table Yes Yes Yes Yes Yes
replicate-ignore-db Yes Yes Yes Yes Yes
replicate-ignore-table Yes Yes Yes Yes Yes
replicate-rewrite-db Yes Yes Yes Yes Yes
replicate-same-server-id Yes Yes Yes Yes Yes
replicate-wild-do-table Yes Yes Yes Yes Yes
replicate-wild-ignore-table Yes Yes Yes Yes Yes
report_host Yes Yes Yes Global No Yes Yes Yes
report_password Yes Yes Yes Global No Yes Yes Yes
report_port Yes Yes Yes Global No Yes Yes Yes
report_user Yes Yes Yes Global No Yes Yes Yes
require_row_format 8.0.19 Yes Session Yes Yes
require_secure_transport 5.7.8 Yes Yes Yes Global Yes Yes Yes
resultset_metadata 8.0.3 Yes Session Yes Yes
rewriter_enabled 5.7.6 Yes Global Yes Yes Yes
Rewriter_number_loaded_rules 5.7.6 Yes Global No Yes Yes
Rewriter_number_reloads 5.7.6 Yes Global No Yes Yes
Rewriter_number_rewritten_queries 5.7.6 Yes Global No Yes Yes
Rewriter_reload_error 5.7.6 Yes Global No Yes Yes
rewriter_verbose 5.7.6 Yes Global Yes Yes Yes
rpl_read_size 8.0.11 Yes Yes Yes Global Yes Yes
Rpl_semi_sync_master_clients Yes Global No Yes Yes Yes
rpl_semi_sync_master_enabled Yes Yes Yes Global Yes Yes Yes Yes
Rpl_semi_sync_master_net_avg_wait_time Yes Global No Yes Yes Yes
Rpl_semi_sync_master_net_wait_time Yes Global No Yes Yes Yes
Rpl_semi_sync_master_net_waits Yes Global No Yes Yes Yes
Rpl_semi_sync_master_no_times Yes Global No Yes Yes Yes
Rpl_semi_sync_master_no_tx Yes Global No Yes Yes Yes
Rpl_semi_sync_master_status Yes Global No Yes Yes Yes
Rpl_semi_sync_master_timefunc_failures Yes Global No Yes Yes Yes
rpl_semi_sync_master_timeout Yes Yes Yes Global Yes Yes Yes Yes
rpl_semi_sync_master_trace_level Yes Yes Yes Global Yes Yes Yes Yes
Rpl_semi_sync_master_tx_avg_wait_time Yes Global No Yes Yes Yes
Rpl_semi_sync_master_tx_wait_time Yes Global No Yes Yes Yes
Rpl_semi_sync_master_tx_waits Yes Global No Yes Yes Yes
rpl_semi_sync_master_wait_for_slave_count 5.7.3 Yes Yes Yes Global Yes Yes Yes
rpl_semi_sync_master_wait_no_slave Yes Yes Yes Global Yes Yes Yes Yes
rpl_semi_sync_master_wait_point 5.7.2 Yes Yes Yes Global Yes Yes Yes
Rpl_semi_sync_master_wait_pos_backtraverse Yes Global No Yes Yes Yes
Rpl_semi_sync_master_wait_sessions Yes Global No Yes Yes Yes
Rpl_semi_sync_master_yes_tx Yes Global No Yes Yes Yes
rpl_semi_sync_slave_enabled Yes Yes Yes Global Yes Yes Yes Yes
Rpl_semi_sync_slave_status Yes Global No Yes Yes Yes
rpl_semi_sync_slave_trace_level Yes Yes Yes Global Yes Yes Yes Yes
rpl_stop_slave_timeout 5.6.13, 5.7.2 Yes Yes Yes Global Yes Yes Yes Yes
Rsa_public_key 5.6.6 Yes Global No Yes Yes Yes
safe-mode 5.5.26 5.6.6 Yes Yes Yes
safe-user-create Yes Yes Yes Yes Yes
schema_definition_cache Yes Yes Yes Global Yes Yes
secondary_engine_cost_threshold 8.0.16 Yes Session Yes Yes
Secondary_engine_execution_count 8.0.13 Yes Both No Yes
secure_auth 5.7.5 8.0.3 Yes Yes Yes Global Yes Yes Yes Yes
secure_file_priv Yes Yes Yes Global No Yes Yes Yes
Select_full_join Yes Both No Yes Yes Yes
Select_full_range_join Yes Both No Yes Yes Yes
Select_range Yes Both No Yes Yes Yes
Select_range_check Yes Both No Yes Yes Yes
Select_scan Yes Both No Yes Yes Yes
server_id Yes Yes Yes Global Yes Yes Yes Yes
server_id_bits Yes Yes Yes Global No Yes Yes Yes
server_uuid Yes Global No Yes Yes Yes
session_track_gtids 5.7.6 Yes Yes Yes Both Yes Yes Yes
session_track_schema 5.7.4 Yes Yes Yes Both Yes Yes Yes
session_track_state_change 5.7.4 Yes Yes Yes Both Yes Yes Yes
session_track_system_variables 5.7.4 Yes Yes Yes Both Yes Yes Yes
session_track_transaction_info 5.7.8 Yes Yes Yes Both Yes Yes Yes
sha256_password_auto_generate_rsa_keys 5.7.5 Yes Yes Yes Global No Yes Yes
sha256_password_private_key_path 5.6.6 Yes Yes Yes Global No Yes Yes Yes
sha256_password_proxy_users 5.7.7 Yes Yes Yes Global Yes Yes Yes
sha256_password_public_key_path 5.6.6 Yes Yes Yes Global No Yes Yes Yes
shared_memory Yes Yes Yes Global No Yes Yes Yes
shared_memory_base_name Yes Yes Yes Global No Yes Yes Yes
show_compatibility_56 5.7.6 5.7.6 8.0.1 Yes Yes Yes Global Yes Yes Yes
show_create_table_skip_secondary_engine 8.0.18 Yes Yes Yes Session Yes Yes
show_create_table_verbosity 5.7.22, 8.0.11 Yes Yes Yes Both Yes Yes Yes
show_old_temporals 5.6.24, 5.7.6 5.6.24, 5.7.6 Yes Yes Yes Both Yes Yes Yes Yes
show-slave-auth-info Yes Yes Yes Yes Yes
simplified_binlog_gtid_recovery 5.6.21, 5.7.5 5.6.23 5.7.6 Yes Yes Yes Global No Yes Yes
skip-character-set-client-handshake Yes Yes Yes Yes Yes
skip_external_locking Yes Yes Yes Global No Yes Yes Yes
skip-grant-tables Yes Yes Yes Yes Yes
skip-host-cache Yes Yes Yes Yes Yes
skip_name_resolve Yes Yes Yes Global No Yes Yes Yes
skip-ndbcluster Yes Yes Yes Yes Yes
skip_networking Yes Yes Yes Global No Yes Yes Yes
skip-new Yes Yes Yes Yes Yes
skip-partition 5.7.16 Yes Yes Yes Yes
skip-show-database Yes Yes Yes Global No Yes Yes Yes
skip-slave-start Yes Yes Yes Yes Yes
skip-ssl Yes Yes Yes Yes Yes
skip-stack-trace Yes Yes Yes Yes Yes
skip-thread-priority 5.1.29 5.6.1 Yes Yes Yes
slave_allow_batching Yes Yes Yes Global Yes Yes Yes Yes
slave_checkpoint_group 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
slave_checkpoint_period 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
slave_compressed_protocol 8.0.18 Yes Yes Yes Global Yes Yes Yes Yes
slave_exec_mode Yes Yes Yes Global Yes Yes Yes Yes
Slave_heartbeat_period 5.7.6 8.0.1 Yes Global No Yes Yes Yes
Slave_last_heartbeat 5.6.1 5.7.6 8.0.1 Yes Global No Yes Yes Yes
slave_load_tmpdir Yes Yes Yes Global No Yes Yes Yes
slave_max_allowed_packet 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
slave_net_timeout Yes Yes Yes Global Yes Yes Yes Yes
Slave_open_temp_tables Yes Global No Yes Yes Yes
slave_parallel_type 5.7.2 Yes Yes Yes Global Yes Yes Yes
slave_parallel_workers 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
slave_pending_jobs_size_max 5.6.3 Yes Yes Yes Global Yes Yes Yes Yes
slave_preserve_commit_order 5.7.5 Yes Yes Yes Global Yes Yes Yes
Slave_received_heartbeats 5.7.6 8.0.1 Yes Global No Yes Yes Yes
Slave_retried_transactions 5.7.6 8.0.1 Yes Global No Yes Yes Yes
Slave_rows_last_search_algorithm_used 5.6.6 Yes Global No Yes Yes Yes
slave_rows_search_algorithms 5.6.6 8.0.18 Yes Yes Yes Global Yes Yes Yes Yes
Slave_running 5.7.6 8.0.1 Yes Global No Yes Yes Yes
slave-skip-errors Yes Yes Yes Global No Yes Yes Yes
slave-sql-verify-checksum 5.6.2 Yes Yes Yes Yes Yes
slave_sql_verify_checksum 5.6.2 Yes Yes Yes Global Yes Yes Yes Yes
slave_transaction_retries Yes Yes Yes Global Yes Yes Yes Yes
slave_type_conversions Yes Yes Yes Global No Yes Yes Yes
Slow_launch_threads Yes Both No Yes Yes Yes
slow_launch_time Yes Yes Yes Global Yes Yes Yes Yes
Slow_queries Yes Both No Yes Yes Yes
slow_query_log Yes Yes Yes Global Yes Yes Yes Yes
slow_query_log_file Yes Yes Yes Global Yes Yes Yes Yes
slow-start-timeout 5.6.5 Yes Yes Yes Yes Yes
socket Yes Yes Yes Global No Yes Yes Yes
sort_buffer_size Yes Yes Yes Both Yes Yes Yes Yes
Sort_merge_passes Yes Both No Yes Yes Yes
Sort_range Yes Both No Yes Yes Yes
Sort_rows Yes Both No Yes Yes Yes
Sort_scan Yes Both No Yes Yes Yes
sporadic-binlog-dump-fail Yes Yes Yes Yes Yes
sql_auto_is_null Yes Both Yes Yes Yes Yes
sql_big_selects Yes Both Yes Yes Yes Yes
sql_big_tables 5.6.1 Yes Both Yes Yes
sql_buffer_result Yes Both Yes Yes Yes Yes
sql_log_bin Yes Session Yes Yes Yes Yes
sql_log_off Yes Both Yes Yes Yes Yes
sql_low_priority_updates 4.1.0 5.6.1 Yes Both Yes Yes
sql_max_join_size 4.1.0 5.6.1 Yes Both Yes Yes
sql-mode Yes Yes Yes Both Yes Yes Yes Yes
sql_notes Yes Both Yes Yes Yes Yes
sql_quote_show_create Yes Both Yes Yes Yes Yes
sql_require_primary_key 8.0.13 Yes Yes Yes Both Yes Yes
sql_safe_updates Yes Both Yes Yes Yes Yes
sql_select_limit Yes Both Yes Yes Yes Yes
sql_slave_skip_counter Yes Global Yes Yes Yes Yes
sql_warnings Yes Both Yes Yes Yes Yes
ssl Yes Yes Yes Yes Yes
Ssl_accept_renegotiates Yes Global No Yes Yes Yes
Ssl_accepts Yes Global No Yes Yes Yes
ssl_ca Yes Yes Yes Global Varies Yes Yes Yes
Ssl_callback_cache_hits Yes Global No Yes Yes Yes
ssl_capath Yes Yes Yes Global Varies Yes Yes Yes
ssl_cert Yes Yes Yes Global Varies Yes Yes Yes
Ssl_cipher Yes Both No Yes Yes Yes
ssl_cipher Yes Yes Yes Global Varies Yes Yes Yes
Ssl_cipher_list Yes Both No Yes Yes Yes
Ssl_client_connects Yes Global No Yes Yes Yes
Ssl_connect_renegotiates Yes Global No Yes Yes Yes
ssl_crl 5.6.3 Yes Yes Yes Global Varies Yes Yes Yes
ssl_crlpath 5.6.3 Yes Yes Yes Global Varies Yes Yes Yes
Ssl_ctx_verify_depth Yes Global No Yes Yes Yes
Ssl_ctx_verify_mode Yes Global No Yes Yes Yes
Ssl_default_timeout Yes Both No Yes Yes Yes
Ssl_finished_accepts Yes Global No Yes Yes Yes
Ssl_finished_connects Yes Global No Yes Yes Yes
ssl_fips_mode 8.0.11 Yes Yes Yes Global Yes Yes
ssl_key Yes Yes Yes Global Varies Yes Yes Yes
Ssl_server_not_after 5.6.3 Yes Both No Yes Yes Yes
Ssl_server_not_before 5.6.3 Yes Both No Yes Yes Yes
Ssl_session_cache_hits Yes Global No Yes Yes Yes
Ssl_session_cache_misses Yes Global No Yes Yes Yes
Ssl_session_cache_mode Yes Global No Yes Yes Yes
Ssl_session_cache_overflows Yes Global No Yes Yes Yes
Ssl_session_cache_size Yes Global No Yes Yes Yes
Ssl_session_cache_timeouts Yes Global No Yes Yes Yes
Ssl_sessions_reused Yes Both No Yes Yes Yes
Ssl_used_session_cache_entries Yes Global No Yes Yes Yes
Ssl_verify_depth Yes Both No Yes Yes Yes
Ssl_verify_mode Yes Both No Yes Yes Yes
Ssl_version Yes Both No Yes Yes Yes
standalone Yes Yes Yes Yes Yes
storage_engine 5.7.5 Yes Both Yes Yes Yes
stored_program_cache 5.6.5 Yes Yes Yes Global Yes Yes Yes Yes
stored_program_definition_cache Yes Yes Yes Global Yes Yes
super-large-pages Yes Yes Yes Yes Yes
super_read_only 5.7.8 Yes Yes Yes Global Yes Yes Yes
symbolic-links 8.0.2 Yes Yes Yes Yes Yes
sync_binlog Yes Yes Yes Global Yes Yes Yes Yes
sync_frm 5.7.6 Yes Yes Yes Global Yes Yes Yes
sync_master_info Yes Yes Yes Global Yes Yes Yes Yes
sync_relay_log Yes Yes Yes Global Yes Yes Yes Yes
sync_relay_log_info Yes Yes Yes Global Yes Yes Yes Yes
sysdate-is-now Yes Yes Yes Yes Yes
syseventlog.facility 8.0.13 Yes Yes Yes Global Yes Yes
syseventlog.include_pid 8.0.13 Yes Yes Yes Global Yes Yes
syseventlog.tag 8.0.13 Yes Yes Yes Global Yes Yes
system_time_zone Yes Global No Yes Yes Yes
table_definition_cache Yes Yes Yes Global Yes Yes Yes Yes
table_encryption_privilege_check 8.0.16 Yes Yes Yes Global Yes Yes
Table_locks_immediate Yes Global No Yes Yes Yes
Table_locks_waited Yes Global No Yes Yes Yes
table_open_cache Yes Yes Yes Global Yes Yes Yes Yes
Table_open_cache_hits 5.6.6 Yes Both No Yes Yes Yes
table_open_cache_instances 5.6.6 Yes Yes Yes Global No Yes Yes Yes
Table_open_cache_misses 5.6.6 Yes Both No Yes Yes Yes
Table_open_cache_overflows 5.6.6 Yes Both No Yes Yes Yes
tablespace_definition_cache Yes Yes Yes Global Yes Yes
tc-heuristic-recover Yes Yes Yes Yes Yes
Tc_log_max_pages_used Yes Global No Yes Yes Yes
Tc_log_page_size Yes Global No Yes Yes Yes
Tc_log_page_waits Yes Global No Yes Yes Yes
temp-pool 5.7.18 8.0.1 Yes Yes Yes Yes Yes
temptable_max_ram 8.0.2 Yes Yes Yes Global Yes Yes
temptable_use_mmap 8.0.16 Yes Yes Yes Global Yes Yes
thread_cache_size Yes Yes Yes Global Yes Yes Yes Yes
thread_concurrency 5.6.1 5.7.2 Yes Yes Yes Global No Yes Yes
thread_handling Yes Yes Yes Global No Yes Yes Yes
thread_pool_algorithm 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Global No Yes Yes Yes
thread_pool_high_priority_connection 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Both Yes Yes Yes Yes
thread_pool_max_active_query_threads 8.0.19 Yes Yes Yes Global Yes Yes
thread_pool_max_unused_threads 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Global Yes Yes Yes Yes
thread_pool_prio_kickup_timer 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Both Yes Yes Yes Yes
thread_pool_size 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Global No Yes Yes Yes
thread_pool_stall_limit 5.6.10, 5.7.9, 8.0.11 Yes Yes Yes Global Yes Yes Yes Yes
thread_stack Yes Yes Yes Global No Yes Yes Yes
Threads_cached Yes Global No Yes Yes Yes
Threads_connected Yes Global No Yes Yes Yes
Threads_created Yes Global No Yes Yes Yes
Threads_running Yes Global No Yes Yes Yes
time_format 8.0.3 Yes Global No Yes Yes Yes
time_zone Yes Both Yes Yes Yes Yes
timed_mutexes 5.5.39, 5.6.20 5.7.5 Yes Yes Yes Global Yes Yes Yes
timestamp Yes Session Yes Yes Yes Yes
tls_ciphersuites 8.0.16 Yes Yes Yes Global Yes Yes
tls_version 5.7.10 Yes Yes Yes Global Varies Yes Yes
tmp_table_size Yes Yes Yes Both Yes Yes Yes Yes
tmpdir Yes Yes Yes Global No Yes Yes Yes
transaction_alloc_block_size Yes Yes Yes Both Yes Yes Yes Yes
transaction_allow_batching Yes Session Yes Yes Yes Yes
transaction-isolation Yes Yes Yes Both Yes Yes Yes Yes
transaction_prealloc_size Yes Yes Yes Both Yes Yes Yes Yes
transaction-read-only 5.6.5 Yes Yes Yes Both Yes Yes Yes Yes
transaction_write_set_extraction 5.7.6 Yes Yes Yes Both Yes Yes Yes
tx_isolation 5.7.20 8.0.3 Yes Both Yes Yes Yes Yes
tx_read_only 5.6.5 5.7.20 8.0.3 Yes Both Yes Yes Yes Yes
unique_checks Yes Both Yes Yes Yes Yes
updatable_views_with_limit Yes Yes Yes Both Yes Yes Yes Yes
upgrade 8.0.16 Yes Yes Yes
Uptime Yes Global No Yes Yes Yes
Uptime_since_flush_status Yes Global No Yes Yes Yes
use_secondary_engine 8.0.13 Yes Session Yes Yes
user Yes Yes Yes Yes Yes
validate-config 8.0.16 Yes Yes Yes
validate-password 5.6.6 Yes Yes Yes Yes Yes
validate_password_check_user_name 5.7.15 Yes Yes Yes Global Yes Yes Yes
validate_password_dictionary_file 5.6.6 Yes Yes Yes Global Varies Yes Yes Yes
validate_password_dictionary_file_last_parsed 5.6.26, 5.7.8 Yes Global No Yes Yes Yes
validate_password_dictionary_file_words_count 5.6.26, 5.7.8 Yes Global No Yes Yes Yes
validate_password_length 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
validate_password_mixed_case_count 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
validate_password_number_count 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
validate_password_policy 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
validate_password_special_char_count 5.6.6 Yes Yes Yes Global Yes Yes Yes Yes
validate_password.check_user_name 8.0.4 Yes Yes Yes Global Yes Yes
validate_password.dictionary_file 8.0.4 Yes Yes Yes Global Yes Yes
validate_password.dictionary_file_last_parsed 8.0.4 Yes Global No Yes
validate_password.dictionary_file_words_count 8.0.4 Yes Global No Yes
validate_password.length 8.0.4 Yes Yes Yes Global Yes Yes
validate_password.mixed_case_count 8.0.4 Yes Yes Yes Global Yes Yes
validate_password.number_count 8.0.4 Yes Yes Yes Global Yes Yes
validate_password.policy 8.0.4 Yes Yes Yes Global Yes Yes
validate_password.special_char_count 8.0.4 Yes Yes Yes Global Yes Yes
validate_user_plugins 5.6.11 Yes Yes Yes Global No Yes Yes Yes
verbose Yes Yes Yes Yes Yes
version Yes Global No Yes Yes Yes
version_comment Yes Global No Yes Yes Yes
version_compile_machine Yes Global No Yes Yes Yes
version_compile_os Yes Global No Yes Yes Yes
version_compile_zlib 8.0.11 Yes Global No Yes
version_tokens_session 5.7.8 Yes Yes Yes Both Yes Yes Yes
version_tokens_session_number 5.7.8 Yes Yes Yes Both No Yes Yes
wait_timeout Yes Yes Yes Both Yes Yes Yes Yes
warning_count Yes Session No Yes Yes Yes
windowing_use_high_precision 8.0.2 Yes Yes Yes Both Yes Yes


PREV   HOME   UP   NEXT
Download this Manual
PDF (US Ltr) - 2.5Mb
PDF (A4) - 2.5Mb
HTML Download (TGZ) - 107.8Kb
HTML Download (Zip) - 109.3Kb