1.2 Option and Variable Changes for MySQL 8.0

The following list details the changes to specific options and variables within MySQL 8.0.

• abort-slave-event-count

  Deprecated in version 8.0.29

• Acl_cache_items_count

  Introduced in version 8.0.0

• activate_all_roles_on_login

  Introduced in version 8.0.2

• admin_address

  Introduced in version 8.0.14

• admin_port

  Introduced in version 8.0.14

• admin-ssl

  Introduced in version 8.0.21

  Deprecated in version 8.0.26

• admin_ssl_ca

  Introduced in version 8.0.21

• admin_ssl_capath

  Introduced in version 8.0.21

• admin_ssl_cert

  Introduced in version 8.0.21

• admin_ssl_cipher

  Introduced in version 8.0.21

• admin_ssl_crl

  Introduced in version 8.0.21

• admin_ssl_crlpath

  Introduced in version 8.0.21

• admin_ssl_key

  Introduced in version 8.0.21

• admin_tls_ciphersuites

  Introduced in version 8.0.21

• admin_tls_version

  Introduced in version 8.0.21

  Value parameter changes in version 8.0.28:

  • Default is TLSv1.2,TLSv1.3

• audit-log

  Introduced in version 8.0.11

• audit_log_buffer_size

  Introduced in version 8.0.11

• audit_log_compression

  Introduced in version 8.0.11

• audit_log_connection_policy

  Introduced in version 8.0.11

  Deprecated in version 8.0.34

• audit_log_current_session

  Introduced in version 8.0.11

• Audit_log_current_size

  Introduced in version 8.0.11

• audit_log_database

  Introduced in version 8.0.33

• audit_log_disable

  Introduced in version 8.0.28

• audit_log_encryption

  Introduced in version 8.0.11

• Audit_log_event_max_drop_size

  Introduced in version 8.0.11

• Audit_log_events

  Introduced in version 8.0.11

• Audit_log_events_filtered

  Introduced in version 8.0.11

• Audit_log_events_lost

  Introduced in version 8.0.11

• Audit_log_events_written

  Introduced in version 8.0.11

• audit_log_exclude_accounts

  Introduced in version 8.0.11

  Deprecated in version 8.0.34

• audit_log_file

  Introduced in version 8.0.11

• audit_log_filter_id

  Introduced in version 8.0.11

• audit_log_flush

  Introduced in version 8.0.11

• audit_log_flush_interval_seconds

  Introduced in version 8.0.34

• audit_log_format

  Introduced in version 8.0.11

• audit_log_format_unix_timestamp

  Introduced in version 8.0.26

• audit_log_include_accounts

  Introduced in version 8.0.11

  Deprecated in version 8.0.34

• audit_log_max_size

  Introduced in version 8.0.26

• audit_log_password_history_keep_days

  Introduced in version 8.0.17

• audit_log_policy

  Introduced in version 8.0.11

  Deprecated in version 8.0.34

• audit_log_prune_seconds

  Introduced in version 8.0.24

• audit_log_read_buffer_size

  Introduced in version 8.0.11

  Value parameter changes in version 8.0.12:

  • Default is 32768, minimum is 32768, maximum is 4194304

• audit_log_rotate_on_size

  Introduced in version 8.0.11

• audit_log_statement_policy

  Introduced in version 8.0.11

  Deprecated in version 8.0.34

• audit_log_strategy

  Introduced in version 8.0.11

• Audit_log_total_size

  Introduced in version 8.0.11

• Audit_log_write_waits

  Introduced in version 8.0.11

• authentication_fido_rp_id

  Introduced in version 8.0.27

  Deprecated in version 8.0.35

• authentication_kerberos_service_key_tab

  Introduced in version 8.0.26

• authentication_kerberos_service_principal

  Introduced in version 8.0.26

• authentication_ldap_sasl_auth_method_name

  Introduced in version 8.0.11

  Value parameter changes in version 8.0.20:

  • Default is SCRAM-SHA-1

  Value parameter changes in version 8.0.23:

  • Default is SCRAM-SHA-1

• authentication_ldap_sasl_bind_base_dn

  Introduced in version 8.0.11

• authentication_ldap_sasl_bind_root_dn

  Introduced in version 8.0.11

• authentication_ldap_sasl_bind_root_pwd

  Introduced in version 8.0.11

• authentication_ldap_sasl_ca_path

  Introduced in version 8.0.11

• authentication_ldap_sasl_group_search_attr

  Introduced in version 8.0.11

• authentication_ldap_sasl_group_search_filter

  Introduced in version 8.0.11

• authentication_ldap_sasl_init_pool_size

  Introduced in version 8.0.11

• authentication_ldap_sasl_log_status

  Introduced in version 8.0.11

  Value parameter changes in version 8.0.18:

  • Default is 1, minimum is 1, maximum is 6

• authentication_ldap_sasl_max_pool_size

  Introduced in version 8.0.11

• authentication_ldap_sasl_referral

  Introduced in version 8.0.20

• authentication_ldap_sasl_server_host

  Introduced in version 8.0.11

• authentication_ldap_sasl_server_port

  Introduced in version 8.0.11

• Authentication_ldap_sasl_supported_methods

  Introduced in version 8.0.21

• authentication_ldap_sasl_tls

  Introduced in version 8.0.11

• authentication_ldap_sasl_user_search_attr

  Introduced in version 8.0.11

• authentication_ldap_simple_auth_method_name

  Introduced in version 8.0.11

• authentication_ldap_simple_bind_base_dn

  Introduced in version 8.0.11

• authentication_ldap_simple_bind_root_dn

  Introduced in version 8.0.11

• authentication_ldap_simple_bind_root_pwd

  Introduced in version 8.0.11

• authentication_ldap_simple_ca_path

  Introduced in version 8.0.11

• authentication_ldap_simple_group_search_attr

  Introduced in version 8.0.11

• authentication_ldap_simple_group_search_filter

  Introduced in version 8.0.11

• authentication_ldap_simple_init_pool_size

  Introduced in version 8.0.11

• authentication_ldap_simple_log_status

  Introduced in version 8.0.11

  Value parameter changes in version 8.0.18:

  • Default is 1, minimum is 1, maximum is 6

• authentication_ldap_simple_max_pool_size

  Introduced in version 8.0.11

• authentication_ldap_simple_referral

  Introduced in version 8.0.20

• authentication_ldap_simple_server_host

  Introduced in version 8.0.11

• authentication_ldap_simple_server_port

  Introduced in version 8.0.11

• authentication_ldap_simple_tls

  Introduced in version 8.0.11

• authentication_ldap_simple_user_search_attr

  Introduced in version 8.0.11

• authentication_policy

  Introduced in version 8.0.27

• authentication_windows_log_level

  Introduced in version 8.0.11

• authentication_windows_use_principal_name

  Introduced in version 8.0.11

• basedir

  Value parameter changes in version 8.0.2:

  • Default is parent of mysqld installation directory

• binlog_encryption

  Introduced in version 8.0.14

• binlog_expire_logs_auto_purge

  Introduced in version 8.0.29

• binlog_expire_logs_seconds

  Introduced in version 8.0.1

  Value parameter changes in version 8.0.11:

  • Default is 2592000, minimum is 0, maximum is 4294967295

• binlog_format

  Deprecated in version 8.0.34

• binlog_rotate_encryption_master_key_at_startup

  Introduced in version 8.0.14

• binlog_row_metadata

  Introduced in version 8.0.1

• binlog_row_value_options

  Introduced in version 8.0.3

• binlog_transaction_compression

  Introduced in version 8.0.20

• binlog_transaction_compression_level_zstd

  Introduced in version 8.0.20

• binlog_transaction_dependency_history_size

  Introduced in version 8.0.1

• binlog_transaction_dependency_tracking

  Introduced in version 8.0.1

  Deprecated in version 8.0.35

• build_id

  Introduced in version 8.0.31

• caching_sha2_password_auto_generate_rsa_keys

  Introduced in version 8.0.4

• caching_sha2_password_digest_rounds

  Introduced in version 8.0.24

• caching_sha2_password_private_key_path

  Introduced in version 8.0.3

• caching_sha2_password_public_key_path

  Introduced in version 8.0.3

• Caching_sha2_password_rsa_public_key

  Introduced in version 8.0.4

• character_set_client

  Value parameter changes in version 8.0.1:

  • Default is utf8mb4

• character-set-client-handshake

  Deprecated in version 8.0.35

• character_set_connection

  Value parameter changes in version 8.0.1:

  • Default is utf8mb4

• character_set_database

  Value parameter changes in version 8.0.1:

  • Default is utf8mb4

• character_set_results

  Value parameter changes in version 8.0.1:

  • Default is utf8mb4

• character_set_server

  Value parameter changes in version 8.0.1:

  • Default is utf8mb4

• character_set_system

  Value parameter changes in version 8.0.1:

  • Default is utf8mb3

• check-table-functions

  Introduced in version 8.0.42

• clone_autotune_concurrency

  Introduced in version 8.0.17

• clone_block_ddl

  Introduced in version 8.0.27

• clone_buffer_size

  Introduced in version 8.0.17

• clone_ddl_timeout

  Introduced in version 8.0.17

• clone_delay_after_data_drop

  Introduced in version 8.0.29

• clone_donor_timeout_after_network_failure

  Introduced in version 8.0.24

• clone_enable_compression

  Introduced in version 8.0.17

• clone_max_concurrency

  Introduced in version 8.0.17

• clone_max_data_bandwidth

  Introduced in version 8.0.17

• clone_max_network_bandwidth

  Introduced in version 8.0.17

• clone_ssl_ca

  Introduced in version 8.0.14

• clone_ssl_cert

  Introduced in version 8.0.14

• clone_ssl_key

  Introduced in version 8.0.14

• clone_valid_donor_list

  Introduced in version 8.0.17

• collation_database

  Value parameter changes in version 8.0.1:

  • Default is utf8mb4_0900_ai_ci

• collation_server

  Value parameter changes in version 8.0.1:

  • Default is utf8mb4_0900_ai_ci

• Com_alter_resource_group

  Introduced in version 8.0.3

• Com_alter_user_default_role

  Introduced in version 8.0.0

• Com_change_replication_source

  Introduced in version 8.0.23

• Com_clone

  Introduced in version 8.0.2

• Com_create_resource_group

  Introduced in version 8.0.3

• Com_create_role

  Introduced in version 8.0.0

• Com_drop_resource_group

  Introduced in version 8.0.3

• Com_drop_role

  Introduced in version 8.0.0

• Com_grant_roles

  Introduced in version 8.0.0

• Com_install_component

  Introduced in version 8.0.0

• Com_replica_start

  Introduced in version 8.0.22

• Com_replica_stop

  Introduced in version 8.0.22

• Com_restart

  Introduced in version 8.0.4

• Com_revoke_roles

  Introduced in version 8.0.0

• Com_set_resource_group

  Introduced in version 8.0.3

• Com_set_role

  Introduced in version 8.0.0

• Com_show_replica_status

  Introduced in version 8.0.22

• Com_show_replicas

  Introduced in version 8.0.22

• Com_uninstall_component

  Introduced in version 8.0.0

• component_scheduler.enabled

  Introduced in version 8.0.34

• Compression

  Deprecated in version 8.0.18

• Compression_algorithm

  Introduced in version 8.0.18

• Compression_level

  Introduced in version 8.0.18

• Connection_control_delay_generated

  Introduced in version 8.0.1

• connection_control_failed_connections_threshold

  Introduced in version 8.0.1

• connection_control_max_connection_delay

  Introduced in version 8.0.1

• connection_control_min_connection_delay

  Introduced in version 8.0.1

• connection_memory_chunk_size

  Introduced in version 8.0.28

  Value parameter changes in version 8.0.34:

  • Default is 8192, minimum is 0, maximum is 536870912

• connection_memory_limit

  Introduced in version 8.0.28

• create_admin_listener_thread

  Introduced in version 8.0.14

• cte_max_recursion_depth

  Introduced in version 8.0.3

• Current_tls_ca

  Introduced in version 8.0.16

• Current_tls_capath

  Introduced in version 8.0.16

• Current_tls_cert

  Introduced in version 8.0.16

• Current_tls_cipher

  Introduced in version 8.0.16

• Current_tls_ciphersuites

  Introduced in version 8.0.16

• Current_tls_crl

  Introduced in version 8.0.16

• Current_tls_crlpath

  Introduced in version 8.0.16

• Current_tls_key

  Introduced in version 8.0.16

• Current_tls_version

  Introduced in version 8.0.16

• daemon_memcached_enable_binlog

  Deprecated in version 8.0.22

• daemon_memcached_engine_lib_name

  Deprecated in version 8.0.22

• daemon_memcached_engine_lib_path

  Deprecated in version 8.0.22

• daemon_memcached_option

  Deprecated in version 8.0.22

• daemon_memcached_r_batch_size

  Deprecated in version 8.0.22

• daemon_memcached_w_batch_size

  Deprecated in version 8.0.22

• date_format

  Removed in version 8.0.3

• datetime_format

  Removed in version 8.0.3

• ddl-rewriter

  Introduced in version 8.0.16

• default_authentication_plugin

  Deprecated in version 8.0.27

  Value parameter changes in version 8.0.3:

  • Default is mysql_native_password

  Value parameter changes in version 8.0.4:

  • Default is caching_sha2_password

• default_collation_for_utf8mb4

  Introduced in version 8.0.11

• default_table_encryption

  Introduced in version 8.0.16

• des-key-file

  Removed in version 8.0.3

• disconnect-slave-event-count

  Deprecated in version 8.0.29

• dragnet.log_error_filter_rules

  Introduced in version 8.0.4

• dragnet.Status

  Introduced in version 8.0.12

• early-plugin-load

  Introduced in version 8.0.0

• enterprise_encryption.maximum_rsa_key_size

  Introduced in version 8.0.30

• enterprise_encryption.rsa_support_legacy_padding

  Introduced in version 8.0.30

• Error_log_buffered_bytes

  Introduced in version 8.0.22

• Error_log_buffered_events

  Introduced in version 8.0.22

• Error_log_expired_events

  Introduced in version 8.0.22

• Error_log_latest_write

  Introduced in version 8.0.22

• event_scheduler

  Value parameter changes in version 8.0.3:

  • Default is ON

• expire_logs_days

  Deprecated in version 8.0.3

  Value parameter changes in version 8.0.2:

  • Default is 30, minimum is 0, maximum is 99

  Value parameter changes in version 8.0.11:

  • Default is 0, minimum is 0, maximum is 99

• explain_format

  Introduced in version 8.0.32

• explicit_defaults_for_timestamp

  Value parameter changes in version 8.0.2:

  • Default is ON

• Firewall_access_denied

  Introduced in version 8.0.11

• Firewall_access_granted

  Introduced in version 8.0.11

• Firewall_access_suspicious

  Introduced in version 8.0.11

• Firewall_cached_entries

  Introduced in version 8.0.11

• generated_random_password_length

  Introduced in version 8.0.18

• Global_connection_memory

  Introduced in version 8.0.28

• global_connection_memory_limit

  Introduced in version 8.0.28

• global_connection_memory_tracking

  Introduced in version 8.0.28

• group_replication_advertise_recovery_endpoints

  Introduced in version 8.0.21

• group_replication_allow_local_disjoint_gtids_join

  Removed in version 8.0.4

• group_replication_autorejoin_tries

  Introduced in version 8.0.16

  Value parameter changes in version 8.0.21:

  • Default is 3, minimum is 0, maximum is 2016

• group_replication_clone_threshold

  Introduced in version 8.0.17

• group_replication_communication_debug_options

  Introduced in version 8.0.3

• group_replication_communication_max_message_size

  Introduced in version 8.0.16

• group_replication_communication_stack

  Introduced in version 8.0.27

• group_replication_components_stop_timeout

  Value parameter changes in version 8.0.27:

  • Default is 300, minimum is 2, maximum is 31536000

• group_replication_consistency

  Introduced in version 8.0.14

• group_replication_exit_state_action

  Introduced in version 8.0.12

  Value parameter changes in version 8.0.16:

  • Default is READ_ONLY

  Value parameter changes in version 8.0.18:

  • Default is READ_ONLY

• group_replication_flow_control_hold_percent

  Introduced in version 8.0.2

• group_replication_flow_control_max_quota

  Introduced in version 8.0.2

• group_replication_flow_control_member_quota_percent

  Introduced in version 8.0.2

• group_replication_flow_control_min_quota

  Introduced in version 8.0.2

• group_replication_flow_control_min_recovery_quota

  Introduced in version 8.0.2

• group_replication_flow_control_period

  Introduced in version 8.0.2

• group_replication_flow_control_release_percent

  Introduced in version 8.0.2

• group_replication_ip_allowlist

  Introduced in version 8.0.22

• group_replication_ip_whitelist

  Deprecated in version 8.0.22

• group_replication_member_expel_timeout

  Introduced in version 8.0.13

  Value parameter changes in version 8.0.14:

  • Default is 0, minimum is 0, maximum is 3600

  Value parameter changes in version 8.0.21:

  • Default is 5, minimum is 0, maximum is 3600

• group_replication_member_weight

  Introduced in version 8.0.2

• group_replication_message_cache_size

  Introduced in version 8.0.16

  Value parameter changes in version 8.0.21 (bitsize=64):

  • Default is 1073741824 (1 GB), minimum is 134217728 (128 MB), maximum is 18446744073709551615 (16 EiB)

  Value parameter changes in version 8.0.21 (bitsize=32):

  • Default is 1073741824 (1 GB), minimum is 134217728 (128 MB), maximum is 315360004294967295 (4 GB)

• group_replication_paxos_single_leader

  Introduced in version 8.0.27

• group_replication_primary_member

  Deprecated in version 8.0.4

• group_replication_recovery_complete_at

  Deprecated in version 8.0.34

• group_replication_recovery_compression_algorithms

  Introduced in version 8.0.18

• group_replication_recovery_get_public_key

  Introduced in version 8.0.4

• group_replication_recovery_public_key_path

  Introduced in version 8.0.4

• group_replication_recovery_tls_ciphersuites

  Introduced in version 8.0.19

• group_replication_recovery_tls_version

  Introduced in version 8.0.19

  Value parameter changes in version 8.0.28:

  • Default is TLSv1.2,TLSv1.3

• group_replication_recovery_zstd_compression_level

  Introduced in version 8.0.18

• group_replication_tls_source

  Introduced in version 8.0.21

• group_replication_unreachable_majority_timeout

  Introduced in version 8.0.2

• group_replication_view_change_uuid

  Introduced in version 8.0.26

• gtid_executed_compression_period

  Value parameter changes in version 8.0.23:

  • Default is 0, minimum is 0, maximum is 4294967295

• have_crypt

  Removed in version 8.0.3

• have_openssl

  Deprecated in version 8.0.26

• have_ssl

  Deprecated in version 8.0.26

• histogram_generation_max_mem_size

  Introduced in version 8.0.2

• ignore_builtin_innodb

  Removed in version 8.0.3

• immediate_server_version

  Introduced in version 8.0.14

• information_schema_stats_expiry

  Introduced in version 8.0.3

• init_replica

  Introduced in version 8.0.26

• init_slave

  Deprecated in version 8.0.26

• innodb_api_bk_commit_interval

  Deprecated in version 8.0.22

• innodb_api_disable_rowlock

  Deprecated in version 8.0.22

• innodb_api_enable_binlog

  Deprecated in version 8.0.22

• innodb_api_enable_mdl

  Deprecated in version 8.0.22

• innodb_api_trx_level

  Deprecated in version 8.0.22

• innodb_autoinc_lock_mode

  Value parameter changes in version 8.0.3:

  • Default is 2, minimum is not specified, maximum is not specified

• Innodb_available_undo_logs

  Removed in version 8.0.2

• innodb_buffer_pool_debug

  Introduced in version 8.0.0

• innodb_buffer_pool_in_core_file

  Introduced in version 8.0.14

• Innodb_buffer_pool_resize_status_code

  Introduced in version 8.0.31

• Innodb_buffer_pool_resize_status_progress

  Introduced in version 8.0.31

• innodb_checkpoint_disabled

  Introduced in version 8.0.2

• innodb_ddl_buffer_size

  Introduced in version 8.0.27

• innodb_ddl_log_crash_reset_debug

  Introduced in version 8.0.3

• innodb_ddl_threads

  Introduced in version 8.0.27

• innodb_deadlock_detect

  Introduced in version 8.0.0

• innodb-dedicated-server

  Introduced in version 8.0.3

• innodb_directories

  Introduced in version 8.0.4

• innodb_doublewrite

  Value parameter changes in version 8.0.30:

  • Default is ON

• innodb_doublewrite_batch_size

  Introduced in version 8.0.20

• innodb_doublewrite_dir

  Introduced in version 8.0.20

• innodb_doublewrite_files

  Introduced in version 8.0.20

• innodb_doublewrite_pages

  Introduced in version 8.0.20

• innodb_extend_and_initialize

  Introduced in version 8.0.22

• innodb_flush_neighbors

  Value parameter changes in version 8.0.3:

  • Default is 0

• innodb_fsync_threshold

  Introduced in version 8.0.13

• innodb_idle_flush_pct

  Introduced in version 8.0.18

• innodb_log_checkpoint_fuzzy_now

  Introduced in version 8.0.13

• innodb_log_file_size

  Deprecated in version 8.0.30

• innodb_log_files_in_group

  Deprecated in version 8.0.30

• innodb_log_spin_cpu_abs_lwm

  Introduced in version 8.0.11

• innodb_log_spin_cpu_pct_hwm

  Introduced in version 8.0.11

• innodb_log_wait_for_flush_spin_hwm

  Introduced in version 8.0.11

• innodb_log_writer_threads

  Introduced in version 8.0.22

• innodb_max_dirty_pages_pct

  Value parameter changes in version 8.0.3:

  • Default is 90, minimum is 0, maximum is 99.999

• innodb_max_dirty_pages_pct_lwm

  Value parameter changes in version 8.0.3:

  • Default is 10, minimum is 0, maximum is 99.999

• innodb_parallel_read_threads

  Introduced in version 8.0.14

• innodb_print_ddl_logs

  Introduced in version 8.0.3

• innodb_redo_log_archive_dirs

  Introduced in version 8.0.17

• innodb_redo_log_capacity

  Introduced in version 8.0.30

  Value parameter changes in version 8.0.34:

  • Default is 104857600, minimum is 8388608, maximum is 549755813888

• Innodb_redo_log_capacity_resized

  Introduced in version 8.0.30

• Innodb_redo_log_checkpoint_lsn

  Introduced in version 8.0.30

• Innodb_redo_log_current_lsn

  Introduced in version 8.0.30

• Innodb_redo_log_enabled

  Introduced in version 8.0.21

• innodb_redo_log_encrypt

  Introduced in version 8.0.1

• Innodb_redo_log_flushed_to_disk_lsn

  Introduced in version 8.0.30

• Innodb_redo_log_logical_size

  Introduced in version 8.0.30

• Innodb_redo_log_physical_size

  Introduced in version 8.0.30

• Innodb_redo_log_read_only

  Introduced in version 8.0.30

• Innodb_redo_log_resize_status

  Introduced in version 8.0.30

• Innodb_redo_log_uuid

  Introduced in version 8.0.30

• innodb_scan_directories

  Introduced in version 8.0.2

  Removed in version 8.0.4

• innodb_segment_reserve_factor

  Introduced in version 8.0.26

• innodb_spin_wait_delay

  Value parameter changes in version 8.0.14:

  • Default is 6, minimum is 0, maximum is 1000

• innodb_spin_wait_pause_multiplier

  Introduced in version 8.0.16

• innodb_stats_include_delete_marked

  Introduced in version 8.0.1

• Innodb_system_rows_deleted

  Introduced in version 8.0.19

• Innodb_system_rows_inserted

  Introduced in version 8.0.19

• Innodb_system_rows_read

  Introduced in version 8.0.19

• Innodb_system_rows_updated

  Introduced in version 8.0.19

• innodb_temp_tablespaces_dir

  Introduced in version 8.0.13

• innodb_tmpdir

  Introduced in version 8.0.0

• innodb_undo_log_encrypt

  Introduced in version 8.0.1

• innodb_undo_log_truncate

  Value parameter changes in version 8.0.2:

  • Default is ON

• innodb_undo_logs

  Removed in version 8.0.2

• innodb_undo_tablespaces

  Deprecated in version 8.0.4

  Value parameter changes in version 8.0.2:

  • Default is 2, minimum is 0, maximum is 127

  Value parameter changes in version 8.0.3:

  • Default is 2, minimum is 2, maximum is 127

• Innodb_undo_tablespaces_active

  Introduced in version 8.0.14

• Innodb_undo_tablespaces_explicit

  Introduced in version 8.0.14

• Innodb_undo_tablespaces_implicit

  Introduced in version 8.0.14

• Innodb_undo_tablespaces_total

  Introduced in version 8.0.14

• innodb_use_fdatasync

  Introduced in version 8.0.26

• innodb_validate_tablespace_paths

  Introduced in version 8.0.21

• internal_tmp_disk_storage_engine

  Removed in version 8.0.16

• internal_tmp_mem_storage_engine

  Introduced in version 8.0.2

• keyring_aws_cmk_id

  Introduced in version 8.0.11

• keyring_aws_conf_file

  Introduced in version 8.0.11

• keyring_aws_data_file

  Introduced in version 8.0.11

• keyring_aws_region

  Introduced in version 8.0.11

  Value parameter changes in version 8.0.17:

  • Default is us-east-1

  Value parameter changes in version 8.0.30:

  • Default is us-east-1

• keyring_encrypted_file_data

  Introduced in version 8.0.11

  Deprecated in version 8.0.34

• keyring_encrypted_file_password

  Introduced in version 8.0.11

  Deprecated in version 8.0.34

• keyring_file_data

  Deprecated in version 8.0.34

• keyring_hashicorp_auth_path

  Introduced in version 8.0.18

• keyring_hashicorp_ca_path

  Introduced in version 8.0.18

• keyring_hashicorp_caching

  Introduced in version 8.0.18

• keyring_hashicorp_commit_auth_path

  Introduced in version 8.0.18

• keyring_hashicorp_commit_ca_path

  Introduced in version 8.0.18

• keyring_hashicorp_commit_caching

  Introduced in version 8.0.18

• keyring_hashicorp_commit_role_id

  Introduced in version 8.0.18

• keyring_hashicorp_commit_server_url

  Introduced in version 8.0.18

• keyring_hashicorp_commit_store_path

  Introduced in version 8.0.18

• keyring_hashicorp_role_id

  Introduced in version 8.0.18

• keyring_hashicorp_secret_id

  Introduced in version 8.0.18

• keyring_hashicorp_server_url

  Introduced in version 8.0.18

• keyring_hashicorp_store_path

  Introduced in version 8.0.18

• keyring-migration-destination

  Introduced in version 8.0.4

• keyring-migration-host

  Introduced in version 8.0.4

• keyring-migration-password

  Introduced in version 8.0.4

• keyring-migration-port

  Introduced in version 8.0.4

• keyring-migration-socket

  Introduced in version 8.0.4

• keyring-migration-source

  Introduced in version 8.0.4

• keyring-migration-to-component

  Introduced in version 8.0.24

• keyring-migration-user

  Introduced in version 8.0.4

• keyring_oci_ca_certificate

  Introduced in version 8.0.22

  Deprecated in version 8.0.31

• keyring_oci_compartment

  Introduced in version 8.0.22

  Deprecated in version 8.0.31

• keyring_oci_encryption_endpoint

  Introduced in version 8.0.22

  Deprecated in version 8.0.31

• keyring_oci_key_file

  Introduced in version 8.0.22

  Deprecated in version 8.0.31

• keyring_oci_key_fingerprint

  Introduced in version 8.0.22

  Deprecated in version 8.0.31

• keyring_oci_management_endpoint

  Introduced in version 8.0.22

  Deprecated in version 8.0.31

• keyring_oci_master_key

  Introduced in version 8.0.22

  Deprecated in version 8.0.31

• keyring_oci_secrets_endpoint

  Introduced in version 8.0.22

  Deprecated in version 8.0.31

• keyring_oci_tenancy

  Introduced in version 8.0.22

  Deprecated in version 8.0.31

• keyring_oci_user

  Introduced in version 8.0.22

  Deprecated in version 8.0.31

• keyring_oci_vaults_endpoint

  Introduced in version 8.0.22

  Deprecated in version 8.0.31

• keyring_oci_virtual_vault

  Introduced in version 8.0.22

  Deprecated in version 8.0.31

• keyring_okv_conf_dir

  Introduced in version 8.0.11

• keyring_operations

  Introduced in version 8.0.4

• local_infile

  Value parameter changes in version 8.0.2:

  • Default is OFF

• lock_order

  Introduced in version 8.0.17

• lock_order_debug_loop

  Introduced in version 8.0.17

• lock_order_debug_missing_arc

  Introduced in version 8.0.17

• lock_order_debug_missing_key

  Introduced in version 8.0.17

• lock_order_debug_missing_unlock

  Introduced in version 8.0.17

• lock_order_dependencies

  Introduced in version 8.0.17

• lock_order_extra_dependencies

  Introduced in version 8.0.17

• lock_order_output_directory

  Introduced in version 8.0.17

• lock_order_print_txt

  Introduced in version 8.0.17

• lock_order_trace_loop

  Introduced in version 8.0.17

• lock_order_trace_missing_arc

  Introduced in version 8.0.17

• lock_order_trace_missing_key

  Introduced in version 8.0.17

• lock_order_trace_missing_unlock

  Introduced in version 8.0.17

• log_bin_trust_function_creators

  Deprecated in version 8.0.34

• log_bin_use_v1_row_events

  Deprecated in version 8.0.18

• log_builtin_as_identified_by_password

  Removed in version 8.0.11

• log_error_filter_rules

  Introduced in version 8.0.2

  Removed in version 8.0.4

• log_error_services

  Introduced in version 8.0.2

• log_error_suppression_list

  Introduced in version 8.0.13

• log_error_verbosity

  Value parameter changes in version 8.0.4:

  • Default is 2, minimum is 1, maximum is 3

• log_replica_updates

  Introduced in version 8.0.26

• log_slave_updates

  Deprecated in version 8.0.26

  Value parameter changes in version 8.0.3:

  • Default is ON

• log_slow_extra

  Introduced in version 8.0.14

• log_slow_replica_statements

  Introduced in version 8.0.26

• log_slow_slave_statements

  Deprecated in version 8.0.26

• log_statements_unsafe_for_binlog

  Deprecated in version 8.0.34

• log_syslog

  Removed in version 8.0.13

  Deprecated in version 8.0.2

  Value parameter changes in version 8.0.2:

  • Default is ON (when error logging to system log is enabled)

• log_syslog_facility

  Removed in version 8.0.13

• log_syslog_include_pid

  Removed in version 8.0.13

• log_syslog_tag

  Removed in version 8.0.13

• log-warnings

  Removed in version 8.0.3

• mandatory_roles

  Introduced in version 8.0.2

• master-info-file

  Deprecated in version 8.0.18

• master_info_repository

  Deprecated in version 8.0.23

  Value parameter changes in version 8.0.2:

  • Default is TABLE

• master_verify_checksum

  Deprecated in version 8.0.26

• max_allowed_packet

  Value parameter changes in version 8.0.3:

  • Default is 67108864, minimum is 1024, maximum is 1073741824

• max_error_count

  Value parameter changes in version 8.0.3:

  • Default is 1024, minimum is 0, maximum is 65535

• max_length_for_sort_data

  Deprecated in version 8.0.20

  Value parameter changes in version 8.0.1:

  • Default is 4096, minimum is 4, maximum is 8388608

• max_prepared_stmt_count

  Value parameter changes in version 8.0.18:

  • Default is 16382, minimum is 0, maximum is 4194304

• max_tmp_tables

  Removed in version 8.0.3

• metadata_locks_cache_size

  Removed in version 8.0.13

• metadata_locks_hash_instances

  Removed in version 8.0.13

• multi_range_count

  Removed in version 8.0.3

• myisam_repair_threads

  Removed in version 8.0.30

  Deprecated in version 8.0.29

• mysql_firewall_mode

  Introduced in version 8.0.11

• mysql_firewall_trace

  Introduced in version 8.0.11

• mysql_native_password_proxy_users

  Deprecated in version 8.0.16

• mysqlx

  Introduced in version 8.0.11

• Mysqlx_bytes_received_compressed_payload

  Introduced in version 8.0.19

• Mysqlx_bytes_received_uncompressed_frame

  Introduced in version 8.0.19

• Mysqlx_bytes_sent_compressed_payload

  Introduced in version 8.0.19

• Mysqlx_bytes_sent_uncompressed_frame

  Introduced in version 8.0.19

• Mysqlx_compression_algorithm

  Introduced in version 8.0.20

• mysqlx_compression_algorithms

  Introduced in version 8.0.19

• Mysqlx_compression_level

  Introduced in version 8.0.20

• mysqlx_deflate_default_compression_level

  Introduced in version 8.0.20

• mysqlx_deflate_max_client_compression_level

  Introduced in version 8.0.20

• mysqlx_interactive_timeout

  Introduced in version 8.0.4

• mysqlx_lz4_default_compression_level

  Introduced in version 8.0.20

• mysqlx_lz4_max_client_compression_level

  Introduced in version 8.0.20

• mysqlx_read_timeout

  Introduced in version 8.0.4

• mysqlx_wait_timeout

  Introduced in version 8.0.4

• mysqlx_write_timeout

  Introduced in version 8.0.4

• mysqlx_zstd_default_compression_level

  Introduced in version 8.0.20

• mysqlx_zstd_max_client_compression_level

  Introduced in version 8.0.20

• named_pipe_full_access_group

  Introduced in version 8.0.14

• Ndb_api_adaptive_send_deferred_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_adaptive_send_deferred_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_adaptive_send_forced_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_adaptive_send_forced_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_adaptive_send_unforced_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_adaptive_send_unforced_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_bytes_received_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_bytes_received_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_bytes_sent_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_bytes_sent_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_pk_op_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_pk_op_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_pruned_scan_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_pruned_scan_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_range_scan_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_range_scan_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_read_row_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_read_row_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_scan_batch_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_scan_batch_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_table_scan_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_table_scan_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_trans_abort_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_trans_abort_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_trans_close_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_trans_close_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_trans_commit_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_trans_commit_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_trans_local_read_row_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_trans_local_read_row_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_trans_start_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_trans_start_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_uk_op_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_uk_op_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_wait_exec_complete_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_wait_exec_complete_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_wait_meta_request_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_wait_meta_request_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_wait_nanos_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_wait_nanos_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_api_wait_scan_result_count_replica

  Introduced in version 8.0.23-ndb-8.0.23

• Ndb_api_wait_scan_result_count_slave

  Deprecated in version 8.0.23-ndb-8.0.23

• ndb-applier-allow-skip-epoch

  Introduced in version 8.0.28-ndb-8.0.28

• ndb_autoincrement_prefetch_sz

  Value parameter changes in version 8.0.19-ndb-8.0.19:

  • Default is 512, minimum is 1, maximum is 65536

• ndb-batch-size

  Value parameter changes in version 8.0.29-ndb-8.0.29:

  • Default is 32768, minimum is 0, maximum is 2147483648

• ndb_cache_check_time

  Removed in version 8.0.1

• Ndb_config_generation

  Introduced in version 8.0.24-ndb-8.0.24

• Ndb_conflict_fn_max_del_win_ins

  Introduced in version 8.0.30-ndb-8.0.30

• Ndb_conflict_fn_max_ins

  Introduced in version 8.0.30-ndb-8.0.30

• ndb_conflict_role

  Introduced in version 8.0.23-ndb-8.0.23

• ndb_dbg_check_shares

  Introduced in version 8.0.13-ndb-8.0.13

• ndb_eventbuffer_max_alloc

  Value parameter changes in version 8.0.26-ndb-8.0.26:

  • Default is 0, minimum is 0, maximum is 9223372036854775807

• Ndb_fetch_table_stats

  Introduced in version 8.0.27-ndb-8.0.27

• ndb_log_bin

  Value parameter changes in version 8.0.16-ndb-8.0.16:

  • Default is OFF

• ndb_log_cache_size

  Introduced in version 8.0.40-ndb_8.0.40

• ndb-log-fail-terminate

  Introduced in version 8.0.21-ndb-8.0.21

• ndb_log_transaction_compression

  Introduced in version 8.0.31-ndb-8.0.31

• ndb_log_transaction_compression_level_zstd

  Introduced in version 8.0.31-ndb-8.0.31

• ndb-log-transaction-dependency

  Introduced in version 8.0.33-ndb-8.0.33

• Ndb_metadata_blacklist_size

  Introduced in version 8.0.18-ndb-8.0.18

  Removed in version 8.0.22-ndb-8.0.22

  Deprecated in version 8.0.21-ndb-8.0.21

• ndb_metadata_check

  Introduced in version 8.0.16-ndb-8.0.16

• ndb_metadata_check_interval

  Introduced in version 8.0.16-ndb-8.0.16

• Ndb_metadata_detected_count

  Introduced in version 8.0.16-ndb-8.0.16

• Ndb_metadata_excluded_count

  Introduced in version 8.0.18-ndb-8.0.22

• ndb_metadata_sync

  Introduced in version 8.0.19-ndb-8.0.19

• Ndb_metadata_synced_count

  Introduced in version 8.0.18-ndb-8.0.18

• ndb_read_backup

  Value parameter changes in version 8.0.19-ndb-8.0.19:

  • Default is ON

• ndb_replica_batch_size

  Introduced in version 8.0.30-ndb-8.0.30

• ndb_replica_blob_write_batch_bytes

  Introduced in version 8.0.30-ndb-8.0.30

• Ndb_replica_max_replicated_epoch

  Deprecated in version 8.0.23-ndb-8.0.23

• ndb_schema_dist_lock_wait_timeout

  Introduced in version 8.0.18-ndb-8.0.18

• ndb-schema-dist-timeout

  Introduced in version 8.0.17-ndb-8.0.17

• ndb_schema_dist_timeout

  Introduced in version 8.0.16-ndb-8.0.16

• ndb_schema_dist_upgrade_allowed

  Introduced in version 8.0.17-ndb-8.0.17

• Ndb_schema_participant_count

  Introduced in version 8.0.42

• ndb_slave_conflict_role

  Deprecated in version 8.0.23-ndb-8.0.23

• Ndb_trans_hint_count_session

  Introduced in version 8.0.17-ndb-8.0.17

• ndb-wait-connected

  Value parameter changes in version 8.0.27-ndb-8.0.27:

  • Default is 120, minimum is 0, maximum is 31536000

• ndb-wait-setup

  Value parameter changes in version 8.0.27-ndb-8.0.27:

  • Default is 120, minimum is 0, maximum is 31536000

• ndbcluster

  Value parameter changes in version 8.0.13-ndb-8.0.13:

  • Default is ON

• ndbinfo

  Introduced in version 8.0.13-ndb-8.0.13

• new

  Deprecated in version 8.0.35

• no-dd-upgrade

  Introduced in version 8.0.4

  Deprecated in version 8.0.16

• no-monitor

  Introduced in version 8.0.12

• old

  Deprecated in version 8.0.35

• old_passwords

  Removed in version 8.0.11

• old-style-user-limits

  Deprecated in version 8.0.30

• optimizer_switch

  Value parameter changes in version 8.0.3:

  • Default is not specified

  Value parameter changes in version 8.0.13:

  • Default is not specified

  Value parameter changes in version 8.0.18:

  • Default is not specified

  Value parameter changes in version 8.0.21:

  • Default is not specified

  Value parameter changes in version 8.0.22:

  • Default is not specified

• optimizer_trace_max_mem_size

  Value parameter changes in version 8.0.4:

  • Default is 1048576, minimum is 0, maximum is 4294967295

• original_commit_timestamp

  Introduced in version 8.0.1

• original_server_version

  Introduced in version 8.0.14

• partial_revokes

  Introduced in version 8.0.16

• password_history

  Introduced in version 8.0.3

• password_require_current

  Introduced in version 8.0.13

• password_reuse_interval

  Introduced in version 8.0.3

• performance-schema-consumer-events-statements-cpu

  Introduced in version 8.0.28

• performance_schema_max_cond_classes

  Value parameter changes in version 8.0.12:

  • Default is 80, minimum is 0, maximum is 1024

  Value parameter changes in version 8.0.13:

  • Default is 100, minimum is 0, maximum is 1024

  Value parameter changes in version 8.0.27:

  • Default is 150, minimum is 0, maximum is 1024

• performance_schema_max_digest_sample_age

  Introduced in version 8.0.3

• performance_schema_max_file_classes

  Value parameter changes in version 8.0.12:

  • Default is 80, minimum is 0, maximum is 1024

• performance_schema_max_memory_classes

  Value parameter changes in version 8.0.1:

  • Default is 450, minimum is 0, maximum is 1024

• performance_schema_max_mutex_classes

  Value parameter changes in version 8.0.1:

  • Default is 220, minimum is 0, maximum is 256

  Value parameter changes in version 8.0.3:

  • Default is 250, minimum is 0, maximum is 256

  Value parameter changes in version 8.0.12:

  • Default is 300, minimum is 0, maximum is 1024

  Value parameter changes in version 8.0.27:

  • Default is 350, minimum is 0, maximum is 1024

• performance_schema_max_rwlock_classes

  Value parameter changes in version 8.0.3:

  • Default is 60, minimum is 0, maximum is 256

  Value parameter changes in version 8.0.12:

  • Default is 100, minimum is 0, maximum is 1024

• performance_schema_max_socket_classes

  Value parameter changes in version 8.0.12:

  • Default is 10, minimum is 0, maximum is 1024

• performance_schema_max_stage_classes

  Value parameter changes in version 8.0.12:

  • Default is 150, minimum is 0, maximum is 1024

  Value parameter changes in version 8.0.13:

  • Default is 175, minimum is 0, maximum is 1024

• performance_schema_max_thread_classes

  Value parameter changes in version 8.0.3:

  • Default is 100, minimum is 0, maximum is 256

  Value parameter changes in version 8.0.12:

  • Default is 100, minimum is 0, maximum is 1024

• performance_schema_show_processlist

  Introduced in version 8.0.22

  Deprecated in version 8.0.35

• persist_only_admin_x509_subject

  Introduced in version 8.0.14

• persist_sensitive_variables_in_plaintext

  Introduced in version 8.0.29

• persisted_globals_load

  Introduced in version 8.0.0

• print_identified_with_as_hex

  Introduced in version 8.0.17

• protocol_compression_algorithms

  Introduced in version 8.0.18

• pseudo_replica_mode

  Introduced in version 8.0.26

• pseudo_slave_mode

  Deprecated in version 8.0.26

• Qcache_free_blocks

  Removed in version 8.0.3

• Qcache_free_memory

  Removed in version 8.0.3

• Qcache_hits

  Removed in version 8.0.3

• Qcache_inserts

  Removed in version 8.0.3

• Qcache_lowmem_prunes

  Removed in version 8.0.3

• Qcache_not_cached

  Removed in version 8.0.3

• Qcache_queries_in_cache

  Removed in version 8.0.3

• Qcache_total_blocks

  Removed in version 8.0.3

• query_cache_limit

  Removed in version 8.0.3

• query_cache_min_res_unit

  Removed in version 8.0.3

• query_cache_size

  Removed in version 8.0.3

  Value parameter changes in version 8.0.1 (bitsize=64):

  • Default is 0, minimum is 0, maximum is 18446744073709551615

  Value parameter changes in version 8.0.1 (bitsize=32):

  • Default is 0, minimum is 0, maximum is 4294967295

• query_cache_type

  Removed in version 8.0.3

• query_cache_wlock_invalidate

  Removed in version 8.0.3

• query_prealloc_size

  Deprecated in version 8.0.29

• regexp_stack_limit

  Introduced in version 8.0.4

• regexp_time_limit

  Introduced in version 8.0.4

• relay_log_info_file

  Deprecated in version 8.0.18

• relay_log_info_repository

  Deprecated in version 8.0.23

  Value parameter changes in version 8.0.2:

  • Default is TABLE

• replica_allow_batching

  Introduced in version 8.0.26-ndb-8.0.26

  Value parameter changes in version 8.0.30-ndb-8.0.30:

  • Default is ON

• replica_checkpoint_group

  Introduced in version 8.0.26

• replica_checkpoint_period

  Introduced in version 8.0.26

• replica_compressed_protocol

  Introduced in version 8.0.26

• replica_exec_mode

  Introduced in version 8.0.26

• replica_load_tmpdir

  Introduced in version 8.0.26

• replica_max_allowed_packet

  Introduced in version 8.0.26

• replica_net_timeout

  Introduced in version 8.0.26

• Replica_open_temp_tables

  Introduced in version 8.0.26

• replica_parallel_type

  Introduced in version 8.0.26

  Deprecated in version 8.0.29

  Value parameter changes in version 8.0.27:

  • Default is LOGICAL_CLOCK

• replica_parallel_workers

  Introduced in version 8.0.26

  Value parameter changes in version 8.0.27:

  • Default is 4, minimum is 0, maximum is 1024

• replica_pending_jobs_size_max

  Introduced in version 8.0.26

• replica_preserve_commit_order

  Introduced in version 8.0.26

  Value parameter changes in version 8.0.27:

  • Default is ON

• Replica_rows_last_search_algorithm_used

  Introduced in version 8.0.26

• replica_skip_errors

  Introduced in version 8.0.26

• replica_sql_verify_checksum

  Introduced in version 8.0.26

• replica_transaction_retries

  Introduced in version 8.0.26

• replica_type_conversions

  Introduced in version 8.0.26

• replication_optimize_for_static_plugin_config

  Introduced in version 8.0.23

• replication_sender_observe_commit_only

  Introduced in version 8.0.23

• require_row_format

  Introduced in version 8.0.19

• Resource_group_supported

  Introduced in version 8.0.31

• resultset_metadata

  Introduced in version 8.0.3

• rewriter_enabled_for_threads_without_privilege_checks

  Introduced in version 8.0.31

• rpl_read_size

  Introduced in version 8.0.11

• Rpl_semi_sync_master_clients

  Deprecated in version 8.0.26

• rpl_semi_sync_master_enabled

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_net_avg_wait_time

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_net_wait_time

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_net_waits

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_no_times

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_no_tx

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_status

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_timefunc_failures

  Deprecated in version 8.0.26

• rpl_semi_sync_master_timeout

  Deprecated in version 8.0.26

• rpl_semi_sync_master_trace_level

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_tx_avg_wait_time

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_tx_wait_time

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_tx_waits

  Deprecated in version 8.0.26

• rpl_semi_sync_master_wait_for_slave_count

  Deprecated in version 8.0.26

• rpl_semi_sync_master_wait_point

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_wait_pos_backtraverse

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_wait_sessions

  Deprecated in version 8.0.26

• Rpl_semi_sync_master_yes_tx

  Deprecated in version 8.0.26

• rpl_semi_sync_replica_enabled

  Introduced in version 8.0.26

• Rpl_semi_sync_replica_status

  Introduced in version 8.0.26

• rpl_semi_sync_replica_trace_level

  Introduced in version 8.0.26

• rpl_semi_sync_slave_enabled

  Deprecated in version 8.0.26

• Rpl_semi_sync_slave_status

  Deprecated in version 8.0.26

• rpl_semi_sync_slave_trace_level

  Deprecated in version 8.0.26

• Rpl_semi_sync_source_clients

  Introduced in version 8.0.26

• rpl_semi_sync_source_enabled

  Introduced in version 8.0.26

• Rpl_semi_sync_source_net_avg_wait_time

  Introduced in version 8.0.26

• Rpl_semi_sync_source_net_wait_time

  Introduced in version 8.0.26

• Rpl_semi_sync_source_net_waits

  Introduced in version 8.0.26

• Rpl_semi_sync_source_no_times

  Introduced in version 8.0.26

• Rpl_semi_sync_source_no_tx

  Introduced in version 8.0.26

• Rpl_semi_sync_source_status

  Introduced in version 8.0.26

• Rpl_semi_sync_source_timefunc_failures

  Introduced in version 8.0.26

• rpl_semi_sync_source_timeout

  Introduced in version 8.0.26

• rpl_semi_sync_source_trace_level

  Introduced in version 8.0.26

• Rpl_semi_sync_source_tx_avg_wait_time

  Introduced in version 8.0.26

• Rpl_semi_sync_source_tx_wait_time

  Introduced in version 8.0.26

• Rpl_semi_sync_source_tx_waits

  Introduced in version 8.0.26

• rpl_semi_sync_source_wait_for_replica_count

  Introduced in version 8.0.26

• rpl_semi_sync_source_wait_no_replica

  Introduced in version 8.0.26

• rpl_semi_sync_source_wait_point

  Introduced in version 8.0.26

• Rpl_semi_sync_source_wait_pos_backtraverse

  Introduced in version 8.0.26

• Rpl_semi_sync_source_wait_sessions

  Introduced in version 8.0.26

• Rpl_semi_sync_source_yes_tx

  Introduced in version 8.0.26

• rpl_stop_replica_timeout

  Introduced in version 8.0.26

• rpl_stop_slave_timeout

  Deprecated in version 8.0.26

• Rsa_public_key

  Deprecated in version 8.0.16

• safe-user-create

  Deprecated in version 8.0.11

• schema_definition_cache

  Introduced in version 8.0.0

• secondary_engine_cost_threshold

  Introduced in version 8.0.16

• Secondary_engine_execution_count

  Introduced in version 8.0.13

• secure_auth

  Removed in version 8.0.3

• select_into_buffer_size

  Introduced in version 8.0.22

• select_into_disk_sync

  Introduced in version 8.0.22

• select_into_disk_sync_delay

  Introduced in version 8.0.22

• server_id

  Value parameter changes in version 8.0.3:

  • Default is 1, minimum is 0, maximum is 4294967295

• sha256_password_auto_generate_rsa_keys

  Deprecated in version 8.0.16

• sha256_password_private_key_path

  Deprecated in version 8.0.16

• sha256_password_proxy_users

  Deprecated in version 8.0.16

• sha256_password_public_key_path

  Deprecated in version 8.0.16

• show_compatibility_56

  Removed in version 8.0.1

• show_create_table_skip_secondary_engine

  Introduced in version 8.0.18

• show_create_table_verbosity

  Introduced in version 8.0.11

• show_gipk_in_create_table_and_information_schema

  Introduced in version 8.0.30

• show-replica-auth-info

  Introduced in version 8.0.26

• show-slave-auth-info

  Deprecated in version 8.0.26

• skip-character-set-client-handshake

  Deprecated in version 8.0.35

• skip-host-cache

  Deprecated in version 8.0.30

• skip-new

  Deprecated in version 8.0.35

• skip-replica-start

  Introduced in version 8.0.26

• skip-slave-start

  Deprecated in version 8.0.26

• skip-ssl

  Deprecated in version 8.0.26

• slave_allow_batching

  Deprecated in version 8.0.26-ndb-8.0.26

  Value parameter changes in version 8.0.30-ndb-8.0.30:

  • Default is ON

• slave_checkpoint_group

  Deprecated in version 8.0.26

• slave_checkpoint_period

  Deprecated in version 8.0.26

• slave_compressed_protocol

  Deprecated in version 8.0.18

• slave_exec_mode

  Deprecated in version 8.0.26

• Slave_heartbeat_period

  Removed in version 8.0.1

• Slave_last_heartbeat

  Removed in version 8.0.1

• slave_load_tmpdir

  Deprecated in version 8.0.26

• slave_max_allowed_packet

  Deprecated in version 8.0.26

• slave_net_timeout

  Deprecated in version 8.0.26

• Slave_open_temp_tables

  Deprecated in version 8.0.26

• slave_parallel_type

  Deprecated in version 8.0.26

  Value parameter changes in version 8.0.27:

  • Default is LOGICAL_CLOCK

• slave_parallel_workers

  Deprecated in version 8.0.26

  Value parameter changes in version 8.0.27:

  • Default is 4, minimum is 0, maximum is 1024

• slave_pending_jobs_size_max

  Deprecated in version 8.0.26

  Value parameter changes in version 8.0.12:

  • Default is 128M, minimum is 1024, maximum is 16EiB

• slave_preserve_commit_order

  Deprecated in version 8.0.26

  Value parameter changes in version 8.0.27:

  • Default is ON

• Slave_received_heartbeats

  Removed in version 8.0.1

• Slave_retried_transactions

  Removed in version 8.0.1

• Slave_rows_last_search_algorithm_used

  Deprecated in version 8.0.26

• slave_rows_search_algorithms

  Deprecated in version 8.0.18

  Value parameter changes in version 8.0.2:

  • Default is INDEX_SCAN,HASH_SCAN

• Slave_running

  Removed in version 8.0.1

• slave-skip-errors

  Deprecated in version 8.0.26

• slave_sql_verify_checksum

  Deprecated in version 8.0.26

• slave_transaction_retries

  Deprecated in version 8.0.26

• slave_type_conversions

  Deprecated in version 8.0.26

• source_verify_checksum

  Introduced in version 8.0.26

• sql_generate_invisible_primary_key

  Introduced in version 8.0.30

• sql-mode

  Value parameter changes in version 8.0.1:

  • Default is ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_ZERO_IN_DATE NO_ZERO_DATE ERROR_FOR_DIVISION_BY_ZERO NO_AUTO_CREATE_USER NO_ENGINE_SUBSTITUTION

  Value parameter changes in version 8.0.11:

  • Default is ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_ZERO_IN_DATE NO_ZERO_DATE ERROR_FOR_DIVISION_BY_ZERO NO_ENGINE_SUBSTITUTION

• sql_replica_skip_counter

  Introduced in version 8.0.26

• sql_require_primary_key

  Introduced in version 8.0.13

• sql_slave_skip_counter

  Deprecated in version 8.0.26

• ssl

  Deprecated in version 8.0.26

• ssl_fips_mode

  Introduced in version 8.0.11

  Deprecated in version 8.0.34

• ssl_session_cache_mode

  Introduced in version 8.0.29

• Ssl_session_cache_timeout

  Introduced in version 8.0.29

• ssl_session_cache_timeout

  Introduced in version 8.0.29

• symbolic-links

  Deprecated in version 8.0.2

  Value parameter changes in version 8.0.2:

  • Default is OFF

• sync_master_info

  Deprecated in version 8.0.26

• sync_relay_log_info

  Deprecated in version 8.0.34

• sync_source_info

  Introduced in version 8.0.26

• syseventlog.facility

  Introduced in version 8.0.13

• syseventlog.include_pid

  Introduced in version 8.0.13

• syseventlog.tag

  Introduced in version 8.0.13

• table_encryption_privilege_check

  Introduced in version 8.0.16

• table_open_cache

  Value parameter changes in version 8.0.4:

  • Default is 4000, minimum is 1, maximum is 524288

• tablespace_definition_cache

  Introduced in version 8.0.0

• Telemetry_traces_supported

  Introduced in version 8.0.33

• temp-pool

  Removed in version 8.0.1

• temptable_max_mmap

  Introduced in version 8.0.23

• temptable_max_ram

  Introduced in version 8.0.2

• temptable_use_mmap

  Introduced in version 8.0.16

  Deprecated in version 8.0.26

• terminology_use_previous

  Introduced in version 8.0.26

• thread_pool_algorithm

  Introduced in version 8.0.11

• thread_pool_dedicated_listeners

  Introduced in version 8.0.23

• thread_pool_high_priority_connection

  Introduced in version 8.0.11

• thread_pool_max_active_query_threads

  Introduced in version 8.0.19

• thread_pool_max_transactions_limit

  Introduced in version 8.0.23

• thread_pool_max_unused_threads

  Introduced in version 8.0.11

• thread_pool_prio_kickup_timer

  Introduced in version 8.0.11

• thread_pool_query_threads_per_group

  Introduced in version 8.0.31

• thread_pool_size

  Introduced in version 8.0.11

  Value parameter changes in version 8.0.19:

  • Default is 16, minimum is 1, maximum is 512

• thread_pool_stall_limit

  Introduced in version 8.0.11

• thread_pool_transaction_delay

  Introduced in version 8.0.31

• thread_stack

  Value parameter changes in version 8.0.2 (bitsize=64):

  • Default is 286720, minimum is 131072, maximum is 18446744073709550592

  Value parameter changes in version 8.0.27 (bitsize=64):

  • Default is 1048576, minimum is 131072, maximum is 18446744073709550592

  Value parameter changes in version 8.0.2 (bitsize=32):

  • Default is 221184, minimum is 131072, maximum is 4294966272

  Value parameter changes in version 8.0.27 (bitsize=32):

  • Default is 1048576, minimum is 131072, maximum is 4294966272

• time_format

  Removed in version 8.0.3

• time_zone

  Value parameter changes in version 8.0.19:

  • Default is SYSTEM

• tls_ciphersuites

  Introduced in version 8.0.16

• Tls_library_version

  Introduced in version 8.0.30

• tls_version

  Value parameter changes in version 8.0.16:

  • Default is TLSv1,TLSv1.1,TLSv1.2,TLSv1.3

  Value parameter changes in version 8.0.28:

  • Default is TLSv1.2,TLSv1.3

• transaction_prealloc_size

  Deprecated in version 8.0.29

• transaction_write_set_extraction

  Deprecated in version 8.0.26

  Value parameter changes in version 8.0.2:

  • Default is XXHASH64

• tx_isolation

  Removed in version 8.0.3

• tx_read_only

  Removed in version 8.0.3

• upgrade

  Introduced in version 8.0.16

• use_secondary_engine

  Introduced in version 8.0.13

• validate-config

  Introduced in version 8.0.16

• validate_password.changed_characters_percentage

  Introduced in version 8.0.34

• validate_password.check_user_name

  Introduced in version 8.0.4

• validate_password.dictionary_file

  Introduced in version 8.0.4

• validate_password.dictionary_file_last_parsed

  Introduced in version 8.0.4

• validate_password.dictionary_file_words_count

  Introduced in version 8.0.4

• validate_password.length

  Introduced in version 8.0.4

• validate_password.mixed_case_count

  Introduced in version 8.0.4

• validate_password.number_count

  Introduced in version 8.0.4

• validate_password.policy

  Introduced in version 8.0.4

• validate_password.special_char_count

  Introduced in version 8.0.4

• version_compile_zlib

  Introduced in version 8.0.11

• windowing_use_high_precision

  Introduced in version 8.0.2

• xa_detach_on_prepare

  Introduced in version 8.0.29