# How can compress Percona MySQL8 audit logs

**URL:** <https://forums.percona.com/t/how-can-compress-percona-mysql8-audit-logs/19356>\
**Category:** Percona Server for MySQL 8.0\
**Created:** [December 28, 2022, 12:47pm UTC](https://forums.percona.com/t/how-can-compress-percona-mysql8-audit-logs/19356 "2022-12-28T12:47:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Muhammad\_Usman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/muhammad_usman/32/6118_2.png) [@Muhammad\_Usman](https://forums.percona.com/u/Muhammad_Usman)\
**Post date:** [December 28, 2022, 12:47pm UTC](https://forums.percona.com/t/how-can-compress-percona-mysql8-audit-logs/19356/1 "2022-12-28T12:47:39Z")

</div>

Dear Team,

plugin-load = audit\_log.so  
audit-log = FORCE\_PLUS\_PERMANENT  
audit\_log\_policy = ALL  
audit\_log\_format = OLD  
audit\_log\_rotate\_on\_size = 1M  
audit\_log\_rotations = 31  
audit\_log\_file = /var/lib/mysql/mysql\_audit/audit.log

Is there any way to compress the audit logs.

Regards,

---

<div class="post-metadata">

**Author:** ![yunus\_shaikh](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yunus_shaikh/32/3512_2.png) [@yunus\_shaikh](https://forums.percona.com/u/yunus_shaikh)\
**Post date:** [January 2, 2023, 10:05am UTC](https://forums.percona.com/t/how-can-compress-percona-mysql8-audit-logs/19356/2 "2023-01-02T10:05:38Z")

</div>

I don’t see any variable to control the compression of Audit logs in the Percona server yet.  
At this point, I think your 31 files of 1M would be just 31M, so I suggest managing it using the internal audit plugin without compression.  
However, if you need compression, you can use other log rotation tools to manage the logs, like logrotate etc.

---

<div class="post-metadata">

**Author:** ![jason\_chen](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jason_chen/32/19686_2.png) [@jason\_chen](https://forums.percona.com/u/jason_chen)\
**Post date:** [January 15, 2025, 9:16am UTC](https://forums.percona.com/t/how-can-compress-percona-mysql8-audit-logs/19356/3 "2025-01-15T09:16:03Z")

</div>

Probably you can refer to below:

> [@Percona MYSQL 8.0.36 audit log compression and encryption](https://forums.percona.com/t/percona-mysql-8-0-36-audit-log-compression-and-encryption/35974/7):
>
> @pbirch @CTutte Hello guys, Sorry for response late! Seems it works on mysql side. Thank you very much! Installed the Audit Log Filter as below steps: 1.Create a audit database to store the JSON audit table create database db\_audit; 2.install the script: audit\_log\_filter\_linux\_install.sql Find script: INFRA [mysql@dc02psqldbuat04 share]# pwd /data/percona8.0.36/share INFRA [mysql@dc02psqldbuat04 share]# ls -l | grep audit\_log\_filter\_linux\_install.sql -rw------- 1 mysql mysql 2316 …

---

<div class="post-metadata">

**Author:** ![Yunus](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yunus/32/6430_2.png) [@Yunus](https://forums.percona.com/u/Yunus)\
**Post date:** [January 15, 2025, 3:59pm UTC](https://forums.percona.com/t/how-can-compress-percona-mysql8-audit-logs/19356/4 "2025-01-15T15:59:49Z")

</div>

Thanks for updating this topic.  
Probably when the question was asked the plugin was not released  
Here is the note for audit log filter plugin

> **[Introducing the MySQL Audit Log Filter Plugin](https://www.percona.com/blog/introducing-the-mysql-audit-log-filter-plugin/)**
>
> The MySQL Audit Log Filter, an upgraded audit plugin with enhanced functionality akin to MySQL Enterprise Audit, is now available in technical preview as of Percona Server for MySQL 8.0.34-26.