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.
The following system variables, status variables, and server options have been added in MySQL 8.3.
-
Deprecated_use_i_s_processlist_count
: Number of times Information Schema processlist table has been accessed. Added in MySQL 8.3.0. -
Deprecated_use_i_s_processlist_last_timestamp
: Time of most recent access to Information Schema processlist table (timestamp). Added in MySQL 8.3.0. -
component_masking.dictionaries_flush_interval_seconds
: How long for scheduler to wait until attempting to schedule next execution, in seconds. Added in MySQL 8.3.0. -
component_masking.masking_database
: Database to use for masking dictionaries. Added in MySQL 8.3.0. -
telemetry.metrics_reader_frequency_1
: . Added in MySQL 8.3.0. -
telemetry.metrics_reader_frequency_1
: . Added in MySQL 8.3.0. -
telemetry.metrics_reader_frequency_1
: . Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_metrics_certificates
: The trusted certificate to use when verifying a server's TLS credentials. Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_metrics_cipher
: TLS cipher to use for metrics (TLS 1.2). Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_metrics_cipher_suite
: TLS cipher to use for metrics (TLS 1.3). Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_metrics_client_certificates
: Client certificate/chain trust for clients private key in PEM format. Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_metrics_client_key
: Client's private key in PEM format. Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_metrics_compression
: Compression used by exporter. Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_metrics_endpoint
: Metrics endpoint URL. Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_metrics_headers
: Key-value pairs to be used as headers associated with HTTP requests. Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_metrics_max_tls
: Maximum TLS version to use for metrics. Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_metrics_min_tls
: Minimum TLS version to use for metrics. Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_metrics_protocol
: Specifies the OTLP transport protocol. Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_metrics_timeout
: Time OLTP exporter waits for each batch export. Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_traces_cipher
: TLS cipher to use for traces (TLS 1.2). Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_traces_cipher_suite
: TLS cipher to use for traces (TLS 1.3). Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_traces_max_tls
: Maximum TLS version to use for traces. Added in MySQL 8.3.0. -
telemetry.otel_exporter_otlp_traces_min_tls
: Minimum TLS version to use for traces. Added in MySQL 8.3.0.
The following system variables, status variables, and options have been deprecated in MySQL 8.3.
-
group_replication_view_change_uuid
: UUID for view change event GTIDs. Deprecated in MySQL 8.3.0.
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.