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

connect performance regression

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • 10.1.47, 10.1.48, 10.2.34, 10.2.35, 10.3.25, 10.3.26, 10.4.15, 10.4.16, 10.5.6, 10.5.7
    • N/A
    • Server

    Description

      The performance regression test suite shows a significant reduction of the number of connect; SELECT 1; disconnect; cycles that the server allows.

      It affects the last two releases in the 10.1 .. 10.5 branches. This table shows the last 4 releases (2 good, 2 bad).

      Test 't_connect-TC=default' - connect test, default thread cache size
      workload: connect; SELECT 1 FROM dual; disconnect
      numbers are connects per second
       
      #thread count           1       8       16      32      64      128     256
      mariadb-10.1.45         2352.8  17846   19485   19080   19185   19530   18095
      mariadb-10.1.46         2338.2  17689   19723   19509   19097   18876   17951
      mariadb-10.1.47         2222.9  16003   18200   17919   17533   18101   16975
      mariadb-10.1.48         2222.1  16045   17830   17458   17415   17616   16809
       
      mariadb-10.2.32         6324.0  36137   84842   106303  103993  104089  81115
      mariadb-10.2.33         5632.8  35125   84811   106135  105619  105257  81129
      mariadb-10.2.34         5904.1  36200   75119   77941   77911   78606   69920
      mariadb-10.2.35-pre     6423.6  35748   74842   77825   76804   77706   69122
       
      mariadb-10.3.23         6076.1  35412   85235   107689  104335  108150  82766
      mariadb-10.3.24         6033.5  35755   86277   108305  107284  105296  81852
      mariadb-10.3.25         6087.5  35786   75976   78890   78415   78507   70032
      mariadb-10.3.26-pre     6069.6  35561   76046   79188   78527   78440   70107
       
      mariadb-10.4.13         5913.2  35183   83286   106969  106577  107517  82435
      mariadb-10.4.14         5856.8  34662   82742   105578  105473  106174  81587
      mariadb-10.4.15         5995.8  34949   74532   77821   77096   77449   69387
      mariadb-10.4.16-pre     5595.0  34511   74461   77918   78059   77830   70050
       
      mariadb-10.5.4          6673.0  36643   103875  129540  132678  96475   98152
      mariadb-10.5.5          5694.4  36919   103683  130704  133107  101547  100085
      mariadb-10.5.6          6162.1  36409   97850   116103  121092  106306  99883
      mariadb-10.5.7-pre      5609.8  36988   97164   118628  121102  109606  93927
      

      Attachments

        Activity

          People

            axel Axel Schwenke
            axel Axel Schwenke
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.