Issues
- Audit plugin "leaks" memoryPS-9369Resolved issue: PS-9369Oleksandr Kachan
- The default db field of the audit log is abnormal.PS-9143
- Crash Occurs When the Audit Log Plugin Is InstalledPS-8797Resolved issue: PS-8797
- After the audit_log plug-in is uninstalled, recording is not stopped. An error is reported when the plug-in is reinstalled.PS-8788
- Documentation for Audit Log v2 pluginPS-8358Resolved issue: PS-8358patrick.birch
- Audit Log v2 initial design and implementationPS-8042Resolved issue: PS-8042Oleksandr Kachan
- Audit Log v2 plugin implementation
PS-8041Resolved issue: PS-8041Oleksandr Kachan - New role (group) based filter for Percona Audit Log PluginPS-7860Resolved issue: PS-7860
- Tracing Feature for MySQL requestsPS-7699Resolved issue: PS-7699
- Add new variable 'audit_log_timestamps' to control the timezone recorded in audit recordsPS-7654Resolved issue: PS-7654George Lorch
- Correct the buffer calculation for the audit plugin used when large queries are executed(PS-5395).PS-7346Resolved issue: PS-7346Marcelo Altmann
- Set Audit Log to rotate by default, clarify unit of measure for audit_log_rotate_on_sizePS-7331Resolved issue: PS-7331Oleksandr Kachan
- Perform Audit Plugin ComparisonPS-7314Resolved issue: PS-7314
- Audit Log Filter audit_log_include_databases doesn't work properlyPS-7152Resolved issue: PS-7152
- [Audit log plugin] Filters don't work as expectedPS-6909Resolved issue: PS-6909
- Audit plugin doesn't handle failed write operationsPS-6889
- audit_log plugin doesn't handle application messages from audit_api_message_emit componentPS-6863Resolved issue: PS-6863Oleksandr Kachan
- Add mysql server host name in audit_log details when writing to syslogPS-5945Resolved issue: PS-5945Oleksandr Kachan
- DB name not show in CSV format of audit pluginPS-5920Resolved issue: PS-5920
- Allow the audit log to be rotated when MySQL startsPS-5814Resolved issue: PS-5814Oleksandr Kachan
- MySQL 8 audit_log_format parameter value is NEW and Percona Audit Plugin the default is OLDPS-5784Resolved issue: PS-5784Oleksandr Kachan
- Audit log filtering by user is not workingPS-5707Resolved issue: PS-5707Kamil Holubicki
- audit_log plugin not rotating logsPS-5667Resolved issue: PS-5667Lalit Choudhary
- MySQL crashing after reaching max connectionsPS-5604Resolved issue: PS-5604
- Audit plugin cannot be reinstalledPS-5522Resolved issue: PS-5522
- Audit plugin does not exclude users which are definer for events if audit_log_include|exclude_accounts usedPS-5439Resolved issue: PS-5439
- Huge memory usage for audit plugin when large queries are executed.PS-5395Resolved issue: PS-5395Sergei Glushchenko
- Audit Plugin audit_log_buffer_size has wrong default valuePS-5370Resolved issue: PS-5370Borys Belinsky
- Add Rows_sent & Rows_examined field on audit logPS-5164Resolved issue: PS-5164Oleksandr Kachan
- Audit log doesn't track default database changesPS-4994Resolved issue: PS-4994
- audit_log_rotations is meant to not be dynamic, but can be changed with set globalPS-4963Resolved issue: PS-4963George Lorch
- Invalid audit log file size when audit_log_rotations is changed during runtimePS-4950Resolved issue: PS-4950Sergei Glushchenko
- auditlog lead to mysql hangPS-4910Resolved issue: PS-4910
- Add status variables on Audit logPS-3969Resolved issue: PS-3969Marcelo Altmann
- Adds the audit_log MTR test to make sure PING_CMD has correct command_classPS-3942Resolved issue: PS-3942Oleksandr Kachan
- Audit plugin, log values used in prepared statementsPS-236Resolved issue: PS-236Oleksandr Kachan
36 of 36
Hello!
We see the audit plugin is causing growth of memory over time if threads remain connected for long. Memory IS released when thread disconnects, but many applications remain forever connected and the excess utilization becomes visible over the days.
Disabling audit plugins prevents memory growth. Here’s simple test case:
You can then monitor memory like:
Eventually the memory grows faster over time, as allocations appear to double at some point.
This resembles old bug for audit plugin:
And in performance schema we see that doubling in THD::Variables:
You can see initial growth takes some time, but again: over the days it just racks up gigabytes worth.