MySQL 9.7 Release Notes
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 9.7.
The following system variables, status variables, and server options have been added in MySQL 9.7.
audit_log.filter_recovery_mode: Controls the recovery mode of the server if mysql_log_filter is incorrectly configured.. Added in MySQL 9.7.0.audit_log.rotate_on_time: Close and reopen audit log file based on elapsed time since current file was created. Added in MySQL 9.7.0.audit_log_filter_recovery_mode: Controls the recovery mode of the server if mysql_log_filter is incorrectly configured.. Added in MySQL 9.7.0.caching_sha2_password_enforce_storage_format: Enforces storage format for caching_sha2_password_storage_format.. Added in MySQL 9.7.0.caching_sha2_password_storage_format: Storage format for caching_sha2_password.. Added in MySQL 9.7.0.enable_cascade_triggers: Specifies handling of foreign keys by the server runtime or the InnoDB engine. Added in MySQL 9.7.0.object_policy_flush_interval_seconds: Enables refreshing of object policy cache for secondaries and replicas. Added in MySQL 9.7.0.replica_allow_higher_version_source: Controls whether asynchronous replication is allowed from a higher-version source server.. Added in MySQL 9.7.0.
The following system variables, status variables, and options have been deprecated in MySQL 9.7.
enable_cascade_triggers: Specifies handling of foreign keys by the server runtime or the InnoDB engine. Deprecated in MySQL 9.7.0.group_replication_communication_stack: Specifies which communication stack (XCom or MySQL) should be used to establish group communication connections between members. Deprecated in MySQL 9.7.2.