MySQL 9.6 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.6.
The following system variables, status variables, and server options have been added in MySQL 9.6.
audit_log.buffer_size: Size of audit log buffer. Added in MySQL 9.6.0.audit_log.compression: Audit log file compression method. Added in MySQL 9.6.0.audit_log.current_size: Audit log file current size. Added in MySQL 9.6.0.audit_log.database: Schema where audit tables are stored. Added in MySQL 9.6.0.audit_log.disable: Whether to disable the audit log. Added in MySQL 9.6.0.audit_log.encryption: Audit log file encryption method. Added in MySQL 9.6.0.audit_log.event_max_drop_size: Size of largest dropped audited event. Added in MySQL 9.6.0.audit_log.events: Number of handled audited events. Added in MySQL 9.6.0.audit_log.events_buffered: The number of buffered events the writing thread is waiting to write. Added in MySQL 9.6.0.audit_log.events_direct_writes: Number of direct writes to the audit log file. Added in MySQL 9.6.0.audit_log.events_filtered: Number of filtered audited events. Added in MySQL 9.6.0.audit_log.events_lost: Number of dropped audited events. Added in MySQL 9.6.0.audit_log.events_written: Number of written audited events. Added in MySQL 9.6.0.audit_log.file: Name of audit log file. Added in MySQL 9.6.0.audit_log.filter_id: ID of current audit log filter. Added in MySQL 9.6.0.audit_log.flush_interval_seconds: Whether to perform a recurring flush of the memory cache. Added in MySQL 9.6.0.audit_log.format_unix_timestamp: Whether to include Unix timestamp in JSON-format audit log. Added in MySQL 9.6.0.audit_log.max_size: Limit on combined size of JSON audit log files. Added in MySQL 9.6.0.audit_log.password_history_keep_days: Number of days to retain archived audit log encryption passwords. Added in MySQL 9.6.0.audit_log.prune_seconds: The number of seconds after which audit log files become subject to pruning. Added in MySQL 9.6.0.audit_log.read_buffer_size: Audit log file read buffer size. Added in MySQL 9.6.0.audit_log.rotate_on_size: Close and reopen audit log file at this size. Added in MySQL 9.6.0.audit_log.strategy: Audit logging strategy. Added in MySQL 9.6.0.audit_log.total_size: Combined size of written audited events. Added in MySQL 9.6.0.audit_log.write_waits: Number of write-delayed audited events. Added in MySQL 9.6.0.server_memory: Enables the container aware features of MySQL Server. Added in MySQL 9.6.0.
The following system variables, status variables, and options have been deprecated in MySQL 9.6.
Audit_log_current_size: Audit log file current size. Deprecated in MySQL 9.6.0.Audit_log_direct_writes: Number of direct writes to the audit log file. Deprecated in MySQL 9.6.0.Audit_log_event_max_drop_size: Size of largest dropped audited event. Deprecated in MySQL 9.6.0.Audit_log_events: Number of handled audited events. Deprecated in MySQL 9.6.0.Audit_log_events_filtered: Number of filtered audited events. Deprecated in MySQL 9.6.0.Audit_log_events_lost: Number of dropped audited events. Deprecated in MySQL 9.6.0.Audit_log_events_written: Number of written audited events. Deprecated in MySQL 9.6.0.Audit_log_total_size: Combined size of written audited events. Deprecated in MySQL 9.6.0.Audit_log_write_waits: Number of write-delayed audited events. Deprecated in MySQL 9.6.0.audit_log_buffer_size: Size of audit log buffer. Deprecated in MySQL 9.6.0.audit_log_compression: Audit log file compression method. Deprecated in MySQL 9.6.0.audit_log_current_session: Whether to audit current session. Deprecated in MySQL 9.6.0.audit_log_database: Schema where audit tables are stored. Deprecated in MySQL 9.6.0.audit_log_disable: Whether to disable the audit log. Deprecated in MySQL 9.6.0.audit_log_encryption: Audit log file encryption method. Deprecated in MySQL 9.6.0.audit_log_file: Name of audit log file. Deprecated in MySQL 9.6.0.audit_log_filter_id: ID of current audit log filter. Deprecated in MySQL 9.6.0.audit_log_flush: Close and reopen audit log file. Deprecated in MySQL 9.6.0.audit_log_flush_interval_seconds: Whether to perform a recurring flush of the memory cache. Deprecated in MySQL 9.6.0.audit_log_format: Audit log file format. Deprecated in MySQL 9.6.0.audit_log_format_unix_timestamp: Whether to include Unix timestamp in JSON-format audit log. Deprecated in MySQL 9.6.0.audit_log_max_size: Limit on combined size of JSON audit log files. Deprecated in MySQL 9.6.0.audit_log_password_history_keep_days: Number of days to retain archived audit log encryption passwords. Deprecated in MySQL 9.6.0.audit_log_prune_seconds: The number of seconds after which audit log files become subject to pruning. Deprecated in MySQL 9.6.0.audit_log_read_buffer_size: Audit log file read buffer size. Deprecated in MySQL 9.6.0.audit_log_rotate_on_size: Close and reopen audit log file at this size. Deprecated in MySQL 9.6.0.audit_log_strategy: Audit logging strategy. Deprecated in MySQL 9.6.0.