MySQL Enterprise Audit Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value (Windows) 4294967295 Maximum Value (Other) 18446744073709551615 Unit bytes audit_log_prune_seconds  pertains to audit log file pruning, which is supported for JSON-format log files only. It controls pruning based on log file age: Setting  audit_log_prune_seconds  by itself is not sufficient to cause log file pruning to occur because the pruning algorithm uses audit_log_rotate_on_size ,  audit_log_max_size , and audit_log_prune_seconds  in conjunction. For details, see Space Management of Audit Log Files. The buffer size for reading from the audit log file, in bytes. The  audit_log_read()  function reads no more than this many bytes. Log file reading is supported only for JSON log format. For more information, see Section 6.4.5.6, “Reading Audit Log Files” . As of MySQL 8.0.12, this variable has a default of 32KB and can be set at runtime. Each client should set its session value of  audit_log_read_buffer_size  appropriately for its use of 1538 Command-Line Format --audit-log-read-buffer-size=# System Variable audit_log_read_buffer_size Scope ( ≥  8.0.12) Global, Session Scope (8.0.11) Global Dynamic ( ≥  8.0.12) Yes Dynamic (8.0.11) No SET_VAR  Hint Applies No Type Integer Default Value ( ≥  8.0.12) 32768 Default Value (8.0.11) 1048576 Minimum Value ( ≥  8.0.12) 32768 Minimum Value (8.0.11) 1024 Maximum Value 4194304 • audit_log_read_buffer_size •A value greater than 0 enables age-based pruning. The value is the number of seconds after which audit log files become subject to pruning. •A value of 0 (the default) disables age-based pruning. No age limit is enforced. Note