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

TPC-H parallel query benchmarks

    XMLWordPrintable

Details

    • Q4/2026 Server Development

    Description

      Exploring the current state of the innodb table chunking parallel query project.

      The tree being tested here is in bb-13.2-parallel_query, which is a rebase onto the main mariadb tree at commit 5104ebf86a1 (Date: Wed Aug 19 15:31:10 2026)

      TPC-H queries will initially be tested against a TPROC-H scale 1 database.

      Setup: as root
      echo performance | tee /sys/devices/system/cpu/cpu/cpufreq/energy_performance_preference*
      echo performance | tee /sys/devices/system/cpu/cpu/cpufreq/scaling_governor*

      check output of lscpu -e to review how many of each sorts of cores the CPU has.
      Mine is currently

      root@trr:/home/rj/src/mariadb/bb-13.2-parallel_query# lscpu -e
      CPU NODE SOCKET CORE L1d:L1i:L2:L3 ONLINE    MAXMHZ   MINMHZ       MHZ
        0    0      0    0 0:0:0:0          yes 5100.0000 400.0000  400.0000
        1    0      0    1 4:4:1:0          yes 5100.0000 400.0000  400.0000
        2    0      0    2 16:16:4:0        yes 5100.0000 400.0000  400.0000
        3    0      0    3 20:20:5:0        yes 5100.0000 400.0000  400.0000
        4    0      0    4 24:24:6:0        yes 5100.0000 400.0000  400.0000
        5    0      0    5 28:28:7:0        yes 5100.0000 400.0000  400.0000
        6    0      0    6 2:0              yes 4400.0000 400.0000  400.0000
        7    0      0    7 18:18:2:0        yes 4400.0000 400.0000  400.0000
        8    0      0    8 2:0              yes 4400.0000 400.0000  400.0000
        9    0      0    9 22:22:2:0        yes 4400.0000 400.0000 4288.5391
       10    0      0   10 3:0              yes 4400.0000 400.0000  400.0000
       11    0      0   11 26:26:3:0        yes 4400.0000 400.0000 4401.9058
       12    0      0   12 3:0              yes 4400.0000 400.0000  400.0000
       13    0      0   13 30:30:3:0        yes 4400.0000 400.0000 4401.4521
       14    0      0   14 64:64:8          yes 2500.0000 400.0000 2500.1499
       15    0      0   15 66:66:8          yes 2500.0000 400.0000  400.0000
      

      Attachments

        1. image-2026-11-06-08-10-08-721.png
          118 kB
          Rex Johnston
        2. screenshot-1.png
          45 kB
          Rex Johnston
        3. screenshot-2.png
          36 kB
          Rex Johnston
        4. screenshot-3.png
          109 kB
          Rex Johnston
        5. screenshot-4.png
          113 kB
          Rex Johnston
        6. screenshot-5.png
          113 kB
          Rex Johnston
        7. screenshot-6.png
          113 kB
          Rex Johnston
        8. summary.ods
          73 kB
          Rex Johnston

        Activity

          People

            Johnston Rex Johnston
            Johnston Rex Johnston
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 2d Original Estimate - 2d
                2d
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 2.5d
                2.5d

                Git Integration

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