1.6 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.2

• Options and Variables Introduced in MySQL 8.2

• Options and Variables Deprecated in MySQL 8.2

• Options and Variables Removed in MySQL 8.2

This section lists system variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL 8.2.

Note

If you are upgrading directly to MySQL 8.2 from MySQL 8.0, see Section 1.5, “Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.1”, for information about system variables, status variables, and options that were added for the first time, deprecated, or removed in MySQL 8.1.

Options and Variables Introduced in MySQL 8.2

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

• Com_show_binary_log_status: Count of SHOW BINARY LOG STATUS statements; use instead of Com_show_master_status. Added in MySQL 8.2.0.

• Performance_schema_meter_lost: Number of meter instruments that failed to be created. Added in MySQL 8.2.0.

• Performance_schema_metric_lost: Number of metric instruments that failed to be created. Added in MySQL 8.2.0.

• Telemetry_metrics_supported: Whether server telemetry metrics is supported. Added in MySQL 8.2.0.

• authentication_webauthn_rp_id: Relying party ID for multifactor authentication. Added in MySQL 8.2.0.

• mysql_firewall_database: The database from which MySQL Enterprise Firewall sources its tables and stored procedures. Added in MySQL 8.2.0.

• mysql_firewall_reload_interval_seconds: Reload data at specified intervals. Added in MySQL 8.2.0.

• performance_schema_max_meter_classes: Maximum number of meter instruments which can be created. Added in MySQL 8.2.0.

• performance_schema_max_metric_classes: Maximum number of metric instruments which can be created. Added in MySQL 8.2.0.

• set_operations_buffer_size: Amount of memory available for hashing of set operations. Added in MySQL 8.2.0.

Options and Variables Deprecated in MySQL 8.2

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

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

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

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

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

• abort-slave-event-count: Option used by mysql-test for debugging and testing of replication. Removed in MySQL 8.2.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.