Delete logs on rotation to save storage and avoid performance issues due to large log files
- 15% of the size of DB instance is only allowed for the log files
- Log rotation are done every hour
- Logs older than 30 days are deleted or the oldest log file
- audit, general and slow query logs are deleted 24 hours / threshold exceeded
- if
log_outputis set toTABLE, then the table is truncated