Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18661

loading the audit plugin causes performance regression

Details

    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.

      Attachments

        Issue Links

          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19174 server_audit plugin locks mutex for every event when server_audit_logging=OFF

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19291 server_audit plugin mutex causes stalls at very high concurrency

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-20236 Add audit plugin API functions to disable/enable specific audit plugins

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-20269 Create new "Auditing" thread state

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            axel Axel Schwenke added a comment -

            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.

            axel Axel Schwenke added a comment - 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.
            holyfoot Alexey Botchkov added a comment -

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

            holyfoot Alexey Botchkov added a comment - http://lists.askmonty.org/pipermail/commits/2019-May/013802.html
            holyfoot Alexey Botchkov added a comment -

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

            Pushed into 10.1.

            holyfoot Alexey Botchkov added a comment - fix to this http://lists.askmonty.org/pipermail/commits/2019-June/013856.html Pushed into 10.1.

            People

              holyfoot Alexey Botchkov
              axel Axel Schwenke
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.