Related Documentation Download this Manual
PDF (US Ltr) - 40.7Mb
PDF (A4) - 40.8Mb
Man Pages (TGZ) - 293.3Kb
Man Pages (Zip) - 408.3Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

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

1.4 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.3

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

Options and Variables Introduced in MySQL 8.3

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

Options and Variables Deprecated in MySQL 8.3

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

Options and Variables Removed in MySQL 8.3

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

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

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

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

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

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

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

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

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