Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.3.1
    • 10.3.15, 10.4.5
    • Server
    • None
    • 10.1.31

    Description

      This was found by the regression test suite. While we had a nice improvement in connect performance in MariaDB 10.2, a lot of that was lost between 10.3.0 and 10.3.1.

      #Workload: connect; select 1; disconnect;
      #numbers: connects per second (bigger=better)
      #
      #thread count           1       8       16      32      64      128     256
      ...
      mariadb-10.2.10         9740.9  70063   115054  132711  131760  128702  123058
      mariadb-10.2.11         9198.6  70738   114843  132299  131002  128688  122573
      mariadb-10.3.0          8733.6  69989   112238  121092  120087  119833  114413
      mariadb-10.3.1          8479.1  59291   80954   81046   80629   80344   79407
      mariadb-10.3.2          8439.2  60418   81373   81412   80924   80519   80056
      mariadb-10.3.3          8953.7  43717   80714   80412   78967   78009   75566                                                           
      mariadb-10.3.4          8939.6  48065   80113   79996   78368   78175   74769
      

      Attachments

        Activity

          Pushed removal of redundant plugin_thdvar_cleanup() to 10.2. Gives ~10% boost in 10.3 (when merged), still ~30% regression remaining.

          svoj Sergey Vojtovich added a comment - Pushed removal of redundant plugin_thdvar_cleanup() to 10.2. Gives ~10% boost in 10.3 (when merged), still ~30% regression remaining.

          serg, please review 11 patches tagged with MDEV-14984 in bb-10.3-svoj-MDEV-14984.

          svoj Sergey Vojtovich added a comment - serg , please review 11 patches tagged with MDEV-14984 in bb-10.3-svoj- MDEV-14984 .

          13 patches

          svoj Sergey Vojtovich added a comment - 13 patches

          Awaiting for:
          1. review of "Session_sysvars_tracker::session_track_system_variables", rev. 2f1c0ecb86d8727a2d53dcc93aa0f2d25d311cd3
          2. review of group commit change, rev. 21fde6b551db705212b888efbb40a60bb2a796da
          3. suggestions wrt THD_count::orig_thd

          svoj Sergey Vojtovich added a comment - Awaiting for: 1. review of "Session_sysvars_tracker::session_track_system_variables", rev. 2f1c0ecb86d8727a2d53dcc93aa0f2d25d311cd3 2. review of group commit change, rev. 21fde6b551db705212b888efbb40a60bb2a796da 3. suggestions wrt THD_count::orig_thd
          serg Sergei Golubchik added a comment - - edited

          1 and 2 look good

          serg Sergei Golubchik added a comment - - edited 1 and 2 look good

          People

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