MySQL Server Version Reference  /  mysqld Option/Variable Reference  /  Option/Variable Changes for mysqld 8.0

1.4 Option/Variable Changes for mysqld 8.0

The list below details the changes in specific options/variables within MySQL 8.0

  • 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

  • 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

  • audit_log_current_session

    Introduced in version 8.0.11

  • Audit_log_current_size

    Introduced in version 8.0.11

  • 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

  • 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_format

    Introduced in version 8.0.11

  • audit_log_include_accounts

    Introduced in version 8.0.11

  • audit_log_policy

    Introduced in version 8.0.11

  • 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

  • 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_ldap_sasl_auth_method_name

    Introduced in version 8.0.11

  • 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

  • authentication_ldap_sasl_max_pool_size

    Introduced in version 8.0.11

  • 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_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

  • authentication_ldap_simple_max_pool_size

    Introduced in version 8.0.11

  • 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_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_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_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_dependency_history_size

    Introduced in version 8.0.1

  • binlog_transaction_dependency_tracking

    Introduced in version 8.0.1

  • bootstrap

    Removed in version 8.0.0

  • caching_sha2_password_auto_generate_rsa_keys

    Introduced in version 8.0.4

  • 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_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

  • 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_db_upgrade

    Removed in version 8.0.0

  • Com_alter_resource_group

    Introduced in version 8.0.3

  • Com_alter_user_default_role

    Introduced in version 8.0.0

  • 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_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_uninstall_component

    Introduced in version 8.0.0

  • 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

  • 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

  • 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

    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

  • 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

  • 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

  • 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_cached_entries

    Introduced in version 8.0.11

  • group_replication_allow_local_disjoint_gtids_join

    Removed in version 8.0.4

  • group_replication_autorejoin_tries

    Introduced in version 8.0.16

  • 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_consistency

    Introduced in version 8.0.14

  • group_replication_exit_state_action

    Introduced in version 8.0.12

  • group_replication_flow_control_hold_percent

    Introduced in version 8.0.2

  • group_replication_flow_control_max_commit_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_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

  • group_replication_member_weight

    Introduced in version 8.0.2

  • group_replication_message_cache_size

    Introduced in version 8.0.16

  • 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_transaction_size_limit

    Value parameter changes in version 8.0.2:

    • Default is 150000000, minimum is 0, maximum is 2147483647

  • group_replication_unreachable_majority_timeout

    Introduced in version 8.0.2

  • have_crypt

    Removed in version 8.0.3

  • histogram_generation_max_mem_size

    Introduced in version 8.0.2

  • ignore-builtin-innodb

    Removed in version 8.0.3

  • ignore-db-dir

    Removed in version 8.0.0

  • ignore_db_dirs

    Removed in version 8.0.0

  • immediate_server_version

    Introduced in version 8.0.14

  • information_schema_stats_expiry

    Introduced in version 8.0.3

  • 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_checkpoint_disabled

    Introduced in version 8.0.2

  • innodb_checksums

    Removed in version 8.0.0

  • innodb_ddl_log_crash_reset_debug

    Introduced in version 8.0.3

  • 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_disable_resize_buffer_pool_debug

    Removed in version 8.0.0

  • innodb_file_format

    Removed in version 8.0.0

  • innodb_file_format_check

    Removed in version 8.0.0

  • innodb_file_format_max

    Removed in version 8.0.0

  • innodb_flush_neighbors

    Value parameter changes in version 8.0.3:

    • Default is 0

  • innodb_fsync_threshold

    Introduced in version 8.0.13

  • innodb_large_prefix

    Removed in version 8.0.0

  • innodb_locks_unsafe_for_binlog

    Removed in version 8.0.0

  • innodb_log_checkpoint_fuzzy_now

    Introduced in version 8.0.13

  • 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_max_dirty_pages_pct

    Value parameter changes in version 8.0.3:

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

  • innodb_max_dirty_pages_pct_lwm

    Value parameter changes in version 8.0.3:

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

  • innodb_parallel_read_threads

    Introduced in version 8.0.14

  • innodb_print_ddl_logs

    Introduced in version 8.0.3

  • innodb_redo_log_encrypt

    Introduced in version 8.0.1

  • innodb_scan_directories

    Introduced in version 8.0.2

    Removed in version 8.0.4

  • 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_stats_sample_pages

    Removed in version 8.0.0

  • innodb_support_xa

    Removed in version 8.0.0

  • 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

  • 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

  • keyring_encrypted_file_data

    Introduced in version 8.0.11

  • keyring_encrypted_file_password

    Introduced in version 8.0.11

  • 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-user

    Introduced in version 8.0.4

  • 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_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-slave-updates

    Value parameter changes in version 8.0.3:

    • Default is ON

  • log_slave_updates

    Value parameter changes in version 8.0.3:

    • Default is ON

  • log_slow_extra

    Introduced in version 8.0.14

  • 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-repository

    Value parameter changes in version 8.0.2:

    • Default is TABLE

  • master_info_repository

    Value parameter changes in version 8.0.2:

    • Default is TABLE

  • 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

    Value parameter changes in version 8.0.1:

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

  • 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

  • mysql_firewall_mode

    Introduced in version 8.0.11

  • mysql_firewall_trace

    Introduced in version 8.0.11

  • mysqlx

    Introduced in version 8.0.11

  • mysqlx_interactive_timeout

    Introduced in version 8.0.4

  • 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

  • named_pipe_full_access_group

    Introduced in version 8.0.14

  • ndb_log_bin

    Value parameter changes in version 8.0.16-ndb-8.0.16:

    • Default is OFF

  • 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-schema-dist-timeout

    Introduced in version 8.0.17-ndb-8.0.17

  • Ndb_trans_hint_count_session

    Introduced in version 8.0.17-ndb-8.0.17

  • 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

  • no-dd-upgrade

    Introduced in version 8.0.4

    Deprecated in version 8.0.16

  • no-monitor

    Introduced in version 8.0.12

  • old_passwords

    Removed in version 8.0.11

  • 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

  • optimizer_trace_max_mem_size

    Value parameter changes in version 8.0.4:

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

  • 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

  • partition

    Removed in version 8.0.0

  • 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_max_cond_classes

    Value parameter changes in version 8.0.12:

    • Default is 80, 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 not specified, maximum is not specified

  • 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

  • performance_schema_max_rwlock_classes

    Value parameter changes in version 8.0.12:

    • Default is 40, 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

  • 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

  • persist_only_admin_x509_subject

    Introduced in version 8.0.14

  • persisted_globals_load

    Introduced in version 8.0.0

  • print_identified_with_as_hex

    Introduced in version 8.0.17

  • 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:

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

    Value parameter changes in version 8.0.1:

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

  • query_cache_type

    Removed in version 8.0.3

  • query_cache_wlock_invalidate

    Removed in version 8.0.3

  • regexp_stack_limit

    Introduced in version 8.0.4

  • regexp_time_limit

    Introduced in version 8.0.4

  • relay-log-info-repository

    Value parameter changes in version 8.0.2:

    • Default is TABLE

  • relay_log_info_repository

    Value parameter changes in version 8.0.2:

    • Default is TABLE

  • resultset_metadata

    Introduced in version 8.0.3

  • rpl_read_size

    Introduced in version 8.0.11

  • 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

  • server-id

    Value parameter changes in version 8.0.3:

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

  • show_compatibility_56

    Removed in version 8.0.1

  • show_create_table_verbosity

    Introduced in version 8.0.11

  • skip-partition

    Removed in version 8.0.0

  • Slave_heartbeat_period

    Removed in version 8.0.1

  • Slave_last_heartbeat

    Removed in version 8.0.1

  • slave-pending-jobs-size-max

    Value parameter changes in version 8.0.12:

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

  • slave_pending_jobs_size_max

    Value parameter changes in version 8.0.12:

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

  • Slave_received_heartbeats

    Removed in version 8.0.1

  • Slave_retried_transactions

    Removed in version 8.0.1

  • slave-rows-search-algorithms

    Value parameter changes in version 8.0.2:

    • Default is INDEX_SCAN,HASH_SCAN

  • slave_rows_search_algorithms

    Value parameter changes in version 8.0.2:

    • Default is INDEX_SCAN,HASH_SCAN

  • Slave_running

    Removed in version 8.0.1

  • 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_require_primary_key

    Introduced in version 8.0.13

  • ssl_fips_mode

    Introduced in version 8.0.11

  • symbolic-links

    Deprecated in version 8.0.2

    Value parameter changes in version 8.0.2:

    • Default is OFF

  • sync_frm

    Removed in version 8.0.0

  • 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

  • temp-pool

    Removed in version 8.0.1

  • temptable_max_ram

    Introduced in version 8.0.2

  • temptable_use_mmap

    Introduced in version 8.0.16

  • thread_pool_algorithm

    Introduced in version 8.0.11

  • thread_pool_high_priority_connection

    Introduced in version 8.0.11

  • thread_pool_max_unused_threads

    Introduced in version 8.0.11

  • thread_pool_prio_kickup_timer

    Introduced in version 8.0.11

  • thread_pool_size

    Introduced in version 8.0.11

  • thread_pool_stall_limit

    Introduced in version 8.0.11

  • thread_stack

    Value parameter changes in version 8.0.2:

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

    Value parameter changes in version 8.0.2:

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

  • time_format

    Removed in version 8.0.3

  • tls_ciphersuites

    Introduced in version 8.0.16

  • tls_version

    Value parameter changes in version 8.0.11:

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

    Value parameter changes in version 8.0.16:

    • Default is TLSv1,TLSv1.1,TLSv1.2,TLSv1.3 (OpenSSL 1.1.1 and higher), TLSv1,TLSv1.1,TLSv1.2 (otherwise)

  • transaction_write_set_extraction

    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.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