Related Documentation Download this Manual
PDF (US Ltr) - 39.9Mb
PDF (A4) - 40.0Mb
Man Pages (TGZ) - 258.3Kb
Man Pages (Zip) - 365.2Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb


MySQL 8.4 Reference Manual  /  General Information  /  Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.4 since 8.0

1.5 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.4 since 8.0

This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL 8.4 since 8.0.

Options and Variables Introduced in MySQL 8.4

The following system variables, status variables, and server options have been added in MySQL 8.4.

Options and Variables Deprecated in MySQL 8.4

The following system variables, status variables, and options have been deprecated in MySQL 8.4.

  • Com_show_master_status: Count of SHOW MASTER STATUS statements. Deprecated in MySQL 8.2.0.

  • authentication_fido_rp_id: Relying party ID for FIDO multifactor authentication. Deprecated in MySQL 8.2.0.

  • binlog_transaction_dependency_tracking: Source of dependency information (commit timestamps or transaction write sets) from which to assess which transactions can be executed in parallel by replica's multithreaded applier. Deprecated in MySQL 8.2.0.

  • character-set-client-handshake: Do not ignore client side character set value sent during handshake. Deprecated in MySQL 8.2.0.

  • group_replication_allow_local_lower_version_join: Allow current server to join group even if it has lower plugin version than group. Deprecated in MySQL 8.4.0.

  • group_replication_view_change_uuid: UUID for view change event GTIDs. Deprecated in MySQL 8.3.0.

  • mysql-native-password: Enable mysql_native_password authentication plugin. Deprecated in MySQL 8.4.0.

  • new: Use very new, possibly 'unsafe' functions. Deprecated in MySQL 8.2.0.

  • old: Cause server to revert to certain behaviors present in older versions. Deprecated in MySQL 8.2.0.

  • performance_schema_show_processlist: Select SHOW PROCESSLIST implementation. Deprecated in MySQL 8.2.0.

  • restrict_fk_on_non_standard_key: Disallow creation of foreign keys on non-unique or partial keys. Deprecated in MySQL 8.4.0.

  • skip-character-set-client-handshake: Ignore client side character set value sent during handshake. Deprecated in MySQL 8.2.0.

  • skip-new: Do not use new, possibly wrong routines. Deprecated in MySQL 8.2.0.

Options and Variables Removed in MySQL 8.4

The following system variables, status variables, and options have been removed in MySQL 8.4.

  • Com_change_master: Count of CHANGE REPLICATION SOURCE TO and CHANGE MASTER TO statements. Removed in MySQL 8.4.0.

  • Com_show_master_status: Count of SHOW MASTER STATUS statements. Removed in MySQL 8.4.0.

  • Com_show_slave_hosts: Count of SHOW REPLICAS and SHOW SLAVE HOSTS statements. Removed in MySQL 8.4.0.

  • Com_show_slave_status: Count of SHOW REPLICA STATUS and SHOW SLAVE STATUS statements. Removed in MySQL 8.4.0.

  • Com_slave_start: Count of START REPLICA and START SLAVE statements. Removed in MySQL 8.4.0.

  • Com_slave_stop: Count of STOP REPLICA and STOP SLAVE statements. Removed in MySQL 8.4.0.

  • Replica_rows_last_search_algorithm_used: Search algorithm most recently used by this replica to locate rows for row-based replication (index, table, or hash scan). Removed in MySQL 8.3.0.

  • abort-slave-event-count: Option used by mysql-test for debugging and testing of replication. Removed in MySQL 8.2.0.

  • admin-ssl: Enable connection encryption. Removed in MySQL 8.4.0.

  • authentication_fido_rp_id: Relying party ID for FIDO multifactor authentication. Removed in MySQL 8.4.0.

  • avoid_temporal_upgrade: Whether ALTER TABLE should upgrade pre-5.6.4 temporal columns. Removed in MySQL 8.4.0.

  • binlog_transaction_dependency_tracking: Source of dependency information (commit timestamps or transaction write sets) from which to assess which transactions can be executed in parallel by replica's multithreaded applier. Removed in MySQL 8.4.0.

  • character-set-client-handshake: Do not ignore client side character set value sent during handshake. Removed in MySQL 8.3.0.

  • daemon_memcached_enable_binlog: . Removed in MySQL 8.3.0.

  • daemon_memcached_engine_lib_name: Shared library implementing InnoDB memcached plugin. Removed in MySQL 8.3.0.

  • daemon_memcached_engine_lib_path: Directory which contains shared library implementing InnoDB memcached plugin. Removed in MySQL 8.3.0.

  • daemon_memcached_option: Space-separated options which are passed to underlying memcached daemon on startup. Removed in MySQL 8.3.0.

  • daemon_memcached_r_batch_size: Specifies how many memcached read operations to perform before doing COMMIT to start new transaction. Removed in MySQL 8.3.0.

  • daemon_memcached_w_batch_size: Specifies how many memcached write operations to perform before doing COMMIT to start new transaction. Removed in MySQL 8.3.0.

  • default_authentication_plugin: Default authentication plugin. Removed in MySQL 8.4.0.

  • disconnect-slave-event-count: Option used by mysql-test for debugging and testing of replication. Removed in MySQL 8.2.0.

  • expire_logs_days: Purge binary logs after this many days. Removed in MySQL 8.2.0.

  • group_replication_ip_whitelist: List of hosts permitted to connect to group. Removed in MySQL 8.3.0.

  • group_replication_primary_member: Primary member UUID when group operates in single-primary mode. Empty string if group is operating in multi-primary mode. Removed in MySQL 8.3.0.

  • group_replication_recovery_complete_at: Recovery policies when handling cached transactions after state transfer. Removed in MySQL 8.4.0.

  • have_openssl: Whether mysqld supports SSL connections. Removed in MySQL 8.4.0.

  • have_ssl: Whether mysqld supports SSL connections. Removed in MySQL 8.4.0.

  • innodb: Enable InnoDB (if this version of MySQL supports it). Removed in MySQL 8.3.0.

  • innodb_api_bk_commit_interval: How often to auto-commit idle connections which use InnoDB memcached interface, in seconds. Removed in MySQL 8.3.0.

  • innodb_api_disable_rowlock: . Removed in MySQL 8.3.0.

  • innodb_api_enable_binlog: Allows use of InnoDB memcached plugin with MySQL binary log. Removed in MySQL 8.3.0.

  • innodb_api_enable_mdl: Locks table used by InnoDB memcached plugin, so that it cannot be dropped or altered by DDL through SQL interface. Removed in MySQL 8.3.0.

  • innodb_api_trx_level: Allows control of transaction isolation level on queries processed by memcached interface. Removed in MySQL 8.3.0.

  • keyring_encrypted_file_data: keyring_encrypted_file plugin data file. Removed in MySQL 8.4.0.

  • keyring_encrypted_file_password: keyring_encrypted_file plugin password. Removed in MySQL 8.4.0.

  • keyring_file_data: keyring_file plugin data file. Removed in MySQL 8.4.0.

  • keyring_oci_ca_certificate: CA certificate file for peer authentication. Removed in MySQL 8.4.0.

  • keyring_oci_compartment: OCI compartment OCID. Removed in MySQL 8.4.0.

  • keyring_oci_encryption_endpoint: OCI encryption server endpoint. Removed in MySQL 8.4.0.

  • keyring_oci_key_file: OCI RSA private key file. Removed in MySQL 8.4.0.

  • keyring_oci_key_fingerprint: OCI RSA private key file fingerprint. Removed in MySQL 8.4.0.

  • keyring_oci_management_endpoint: OCI management server endpoint. Removed in MySQL 8.4.0.

  • keyring_oci_master_key: OCI master key OCID. Removed in MySQL 8.4.0.

  • keyring_oci_secrets_endpoint: OCI secrets server endpoint. Removed in MySQL 8.4.0.

  • keyring_oci_tenancy: OCI tenancy OCID. Removed in MySQL 8.4.0.

  • keyring_oci_user: OCI user OCID. Removed in MySQL 8.4.0.

  • keyring_oci_vaults_endpoint: OCI vaults server endpoint. Removed in MySQL 8.4.0.

  • keyring_oci_virtual_vault: OCI vault OCID. Removed in MySQL 8.4.0.

  • language: Client error messages in given language. May be given as full path. Removed in MySQL 8.4.0.

  • log_bin_use_v1_row_events: Whether server is using version 1 binary log row events. Removed in MySQL 8.3.0.

  • master-info-file: Location and name of file that remembers source and where I/O replication thread is in source's binary log. Removed in MySQL 8.3.0.

  • master_info_repository: Whether to write connection metadata repository, containing source information and replication I/O thread location in source's binary log, to file or table. Removed in MySQL 8.3.0.

  • new: Use very new, possibly 'unsafe' functions. Removed in MySQL 8.4.0.

  • no-dd-upgrade: Prevent automatic upgrade of data dictionary tables at startup. Removed in MySQL 8.4.0.

  • old: Cause server to revert to certain behaviors present in older versions. Removed in MySQL 8.4.0.

  • old-style-user-limits: Enable old-style user limits (before 5.0.3, user resources were counted per each user+host vs. per account). Removed in MySQL 8.3.0.

  • relay_log_info_file: File name for applier metadata repository in which replica records information about relay logs. Removed in MySQL 8.3.0.

  • relay_log_info_repository: Whether to write location of replication SQL thread in relay logs to file or table. Removed in MySQL 8.3.0.

  • show_old_temporals: Whether SHOW CREATE TABLE should indicate pre-5.6.4 temporal columns. Removed in MySQL 8.4.0.

  • skip-character-set-client-handshake: Ignore client side character set value sent during handshake. Removed in MySQL 8.3.0.

  • skip-host-cache: Do not cache host names. Removed in MySQL 8.3.0.

  • slave_rows_search_algorithms: Determines search algorithms used for replica update batching. Any 2 or 3 from this list: INDEX_SEARCH, TABLE_SCAN, HASH_SCAN. Removed in MySQL 8.3.0.

  • ssl: Enable connection encryption. Removed in MySQL 8.4.0.

  • transaction_write_set_extraction: Defines algorithm used to hash writes extracted during transaction. Removed in MySQL 8.3.0.