content_image/781813.jpg content_image/781818.jpg content_image/781819.jpg
mysql> SHOW VARIABLES LIKE ’audit_log%’; 

<img src='content_image/781813.jpg'>

You can set any of these variables at server startup, and some of them at runtime. Those that are available only for legacy mode audit log filtering are so noted. 

• audit_log_buffer_size 

<img src='content_image/781818.jpg'>

When the audit log plugin writes events to the log asynchronously, it uses a buffer to store event contents prior to writing them. This variable controls the size of that buffer, in bytes. The server adjusts the value to a multiple of 4096. The plugin uses a single buffer, which it allocates when it initializes and removes when it terminates. The plugin allocates this buffer only if logging is asynchronous. 

• audit_log_compression 

<img src='content_image/781819.jpg'>

