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

DBT-3 Q1 benchmark: Benchmark + profile a patch

Details

    Description

      I need a benchmark and a profiling run: mariadb-5.5-latest vs mariadb-5.5-latest with attached patch.

      DBT-3, MyISAM.

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-4150 Benchmark *execution* speed of simple DBT-3 query: MariaDB vs MySQL-it-merged-from

          • Major - Major loss of function.
          • Closed

          Activity

            Descending order - Click to sort in ascending order
            psergei Sergei Petrunia added a comment -

            Data from my 'pylon' machine. DBT3 sf=1, compile-pentium-max, Q1 as defined by Q1_virtfun_patch2-edited.ods. The patch is 201402181003_sanja_copy_calls_patch.diff.

            mariadb-5.5 vanilla - 4.81 sec (+/-0.02 sec)
            mariadb-5.5 + patch - 4.58 sec (+/- 0.02 sec) – The patch gives ~ 5% speedup.

            mariadb-10.0 vanilla - 5.30 (+/0 0.01 sec)
            mariadb-10.0 + patch - 5.28 (+/- 0.02 sec) – The patch 0.4% speedup, a barely noticeable difference.

            That is, there is speedup on 5.5 but not on 10.0, for some reason.

            psergei Sergei Petrunia added a comment - Data from my 'pylon' machine. DBT3 sf=1, compile-pentium-max, Q1 as defined by Q1_virtfun_patch2-edited.ods. The patch is 201402181003_sanja_copy_calls_patch.diff. mariadb-5.5 vanilla - 4.81 sec (+/-0.02 sec) mariadb-5.5 + patch - 4.58 sec (+/- 0.02 sec) – The patch gives ~ 5% speedup. mariadb-10.0 vanilla - 5.30 (+/0 0.01 sec) mariadb-10.0 + patch - 5.28 (+/- 0.02 sec) – The patch 0.4% speedup, a barely noticeable difference. That is, there is speedup on 5.5 but not on 10.0, for some reason.
            psergei Sergei Petrunia added a comment -

            Review feedback provided for patch #2 over email.

            psergei Sergei Petrunia added a comment - Review feedback provided for patch #2 over email.
            sanja Oleksandr Byelkin added a comment -

            Polished patch.

            sanja Oleksandr Byelkin added a comment - Polished patch.
            psergei Sergei Petrunia added a comment -

            Benchmark results for 201303260107_sanja_copy_calls_patch.diff

            psergei Sergei Petrunia added a comment - Benchmark results for 201303260107_sanja_copy_calls_patch.diff
            sanja Oleksandr Byelkin added a comment -

            Next step in attempt to make tmp table grouping faster.

            sanja Oleksandr Byelkin added a comment - Next step in attempt to make tmp table grouping faster.
            View 4 older comments

            People

              sanja Oleksandr Byelkin
              psergei Sergei Petrunia
              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.