[MDEV-18661] loading the audit plugin causes performance regression Created: 2019-02-20  Updated: 2021-05-31  Resolved: 2019-06-15

Status: Closed
Project: MariaDB Server
Component/s: Plugin - Audit
Affects Version/s: 10.4.2
Fix Version/s: 10.2.26, 10.1.41, 10.3.17, 10.4.7

Type: Bug Priority: Critical
Reporter: Axel Schwenke Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
includes MDEV-19174 server_audit plugin locks mutex for e... Closed
includes MDEV-19291 server_audit plugin mutex causes stal... Closed
Relates
relates to MDEV-20236 Add audit plugin API functions to dis... Closed
relates to MDEV-20269 Create new "Auditing" thread state Open

 Description   

Once the audit plugin is loaded into MariaDB server, it causes a performance loss. Even if the plugin is turned off with 

SET GLOBAL server_audit_logging=OFF

Unloading the audit plugin restores the original condition.

 Comments   
Comment by Axel Schwenke [ 2019-02-20 ]

reproduced with MariaDB 10.4.2:

#sysbench OLTP read/write, 14 reads + 4 writes per TRX, 1 table
 
#numbers are queries per second
 
#
 
#thread count           1       8       16      32      64      128     256
 
mariadb-10.4.2          4346.2  26684   53754   106532  155031  169569  161245
 
mariadb-10.4.2-audit    4335.4  27140   53612   98709   137914  149979  145754

The effect gets more visible at higher concurrency, so it is probably some shared global resource. The test machine has 16 cores (32 hardware threads). Customer with 40 core hardware reports up to 70% reduction in throughput.

Comment by Alexey Botchkov [ 2019-05-27 ]

http://lists.askmonty.org/pipermail/commits/2019-May/013802.html

Comment by Alexey Botchkov [ 2019-06-15 ]

fix to this
http://lists.askmonty.org/pipermail/commits/2019-June/013856.html

Pushed into 10.1.

Generated at Thu Feb 08 08:45:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.