Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
12.1.1
-
None
-
Not for Release Notes
Description
Finding the maximum for server_audit_file_buffer_size to aid the documentation request in MDEV-36956, I found out that the maximum is 65536 bytes:
|
MDEV-34680-7 CS 12.1.1 6e8dbb9693346274f0998e99f3fea38e9fd86a59 (Optimized, Clang) Build 04/08/2025 |
12.1.1-opt>INSTALL PLUGIN server_audit SONAME 'server_audit';
|
Query OK, 0 rows affected (0.002 sec)
|
|
|
12.1.1-opt>set global server_audit_file_buffer_size=19999999999999999999999999;
|
Query OK, 0 rows affected, 2 warnings (0.000 sec)
|
|
|
12.1.1-opt>show warnings;
|
+---------+------+-----------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+-----------------------------------------------------------------------------------+
|
| Warning | 1916 | Got overflow when converting '19999999999999999999999999' to INT. Value truncated |
|
| Warning | 1292 | Truncated incorrect server_audit_file_buffer_size value: '9223372036854775807' |
|
+---------+------+-----------------------------------------------------------------------------------+
|
2 rows in set (0.000 sec)
|
|
|
12.1.1-opt>select @@global.server_audit_file_buffer_size;
|
+----------------------------------------+
|
| @@global.server_audit_file_buffer_size |
|
+----------------------------------------+
|
| 65536 |
|
+----------------------------------------+
|
1 row in set (0.000 sec)
|
This 65K bytes buffer is very small. This is possibly a leftover from a more original idea where server_audit_file_buffer_size may have represented the number of lines, or similar.
Please increase this limit, though I am not sure what a reasonable upper limit is, keeping large single-burst disk writes in mind. Perhaps 536870912 (512M) or 256M?
Attachments
Issue Links
- is caused by
-
MDEV-34680 Asynchronous and Buffered Logging for Audit Plugin
-
- Closed
-
- relates to
-
-
- In Review
-
-
MDEV-37355 Performance testing of final Audit log buffering patch
-
- Closed
-