Warning in Exasol system log is generated when auditing data gets too large
Details
| Detail name | Value |
|---|---|
| Changelog Number | 16087 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 8.13.0 |
| Resolution Date | 2023-03-22 |
Background
When auditing is enabled, it keeps track of information for every query for as long as it is active. After a long time, this can end up using significant amounts of space and/or have a detrimental effect on the system performance. Auditing data can be deleted using the TRUNCATE AUDIT LOGS statement.
Improvement
Whenever the size of the auditing data reaches 25% of the size of Database RAM, a warning in the Exasol System Log is generated