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

10.11-selectivity tree: run TPC-H benchmark

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: N/A
    • Component/s: Optimizer
    • Labels:
      None

      Description

      Results from Axel Schwenke:

      Query Time_before Time_after Slowdown
      1 34.877342 37.3040073333 1.07
      2 0.70996 0.6999416667 0.99
      3 17.534791 17.3803573333 0.99
      4 4.3160256667 4.383789 1.02
      5 15.6127156667 14.284426 0.91
      6 16.6437693333 16.4739456667 0.99
      7 9.648812 9.105951 0.94
      8 4.3772793333 25.3670206667 5.80
      9 63.3513806667 62.9470363333 0.99
      10 16.5304676667 16.6002006667 1.00
      11 2.0004416667 1.9920976667 1.00
      12 21.6412226667 21.4477506667 0.99
      13 53.2589623333 51.8589533333 0.97
      14 4.9125643333 4.8873893333 0.99
      15 16.9550423333 16.7054933333 0.99
      16 2.6014566667 2.6475006667 1.02
      17 0.8848573333 0.8811376667 1.00
      18 56.1752516667 54.935931 0.98
      19 1.3171836667 1.3199926667 1.00
      20 2.5477503333 2.533202 0.99
      21 15.1532053333 14.856619 0.98
      22 1.4554416667 1.4205916667 0.98

      The only difference of more than 10% is:

      8 4.3772793333 25.3670206667 5.80

        Attachments

          Activity

            People

            Assignee:
            psergei Sergei Petrunia
            Reporter:
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

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