The audit log plugin uses too much memory
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
High
|
Sergei Glushchenko | |||
5.7 |
Fix Released
|
High
|
Sergei Glushchenko |
Bug Description
+------
| code_area | current_alloc |
+------
| memory/audit_log | 9.58 GiB |
| memory/innodb | 5.49 GiB |
| memory/sql | 266.00 MiB |
| memory/
| memory/mysys | 74.70 MiB |
| memory/memory | 1.18 MiB |
| memory/myisam | 903.17 KiB |
| memory/csv | 18.14 KiB |
| memory/blackhole | 512 bytes |
| memory/vio | 8 bytes |
+------
10 rows in set (0.01 sec)
mysql Ver 14.14 Distrib 5.7.14-7, for Linux (x86_64) using 6.0
Server version: 5.7.14-7-log Percona Server (GPL), Release 7, Revision 083e298
CentOS 6.7
loose-audit-log = ON log_file = /opt/mysql/ dblogs1/ monty-q0/ audit/audit. log log_format = JSON log_handler = FILE log_strategy = SEMISYNCHRONOUS log_syslog_ facility = LOG_LOCAL6 log_syslog_ ident = mysql-audit
loose-audit_
loose-audit_
loose-audit_
loose-audit_
loose-audit_
loose-audit_