content_image/747521.jpg content_image/747532.jpg content_image/747527.jpg
<img src='content_image/747521.jpg'>

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: 

•A value of 0 (the default) disables age-based pruning. No age limit is enforced. 

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

<img src='content_image/747532.jpg'>

• audit_log_read_buffer_size 

## Note 

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. 

<img src='content_image/747527.jpg'>

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 

