1.3 Option and Variable Changes for MySQL 9.7

The following list details the changes to specific options and variables within MySQL 9.7.

• audit_log_filter_recovery_mode

  Introduced in version 9.7.0

• audit_log.filter_recovery_mode

  Introduced in version 9.7.0

• audit_log.rotate_on_time

  Introduced in version 9.7.0

• caching_sha2_password_enforce_storage_format

  Introduced in version 9.7.0

• caching_sha2_password_storage_format

  Introduced in version 9.7.0

• enable_cascade_triggers

  Introduced in version 9.7.0

  Deprecated in version 9.7.0

• group_replication_communication_stack

  Deprecated in version 9.7.2

• object_policy_flush_interval_seconds

  Introduced in version 9.7.0

• replica_allow_higher_version_source

  Introduced in version 9.7.0

• thread_pool_max_unused_threads

  Value parameter changes in version 9.7.2:

  • Default is 32, minimum is 0, maximum is 4096