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

Benchmark *execution* speed of simple DBT-3 query: MariaDB vs MySQL-it-merged-from

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      quote from the email:

      Date: Wed, 06 Feb 2013 20:03:00 -0800
      From: Igor Babaev <igor@askmonty.org>
      To: dev@lists.askmonty.org
      Subject: Re: DBT3 next round

      If we have a lower performance for MariaDB 10.0.1 for the same queries
      with the same execution plans we need all possible data to analyze the
      problem. To have the results of a profiling of the underperformed query
      would be perfect.
      Bare in mind only that MariaDB 10.0.1 is based on MySQL 5.6.5. So a
      worse performance of MariaDB 10.0.1 in comparison with MySQL 5.6.5 on a
      query indicates that we have probably a bug in our code.

      Please focus first on simple queries like Q1 and see why the numbers are
      worse there (if they are really worse) than for MySQL 5.6.5.


      Message-ID: <512AE0AD.9060406@askmonty.org>
      Date: Sun, 24 Feb 2013 19:55:25 -0800
      From: Igor Babaev <igor@askmonty.org>
      To: Sergei Petrunia <psergey@askmonty.org>, Axel Schwenke <axel@askmonty.org>
      CC: dev@lists.askmonty.org

      Axel,
      Sergey's idea to factor out InnoDB seems to be quite productive.
      Could you please to get the same profiles for the MyISAM DBT3
      as you got for InnoDB DBT3?

      Attachments

        1. dbt3-q1-profiles-mar19.ods
          26 kB
        2. tags
          4 kB
        3. test-image-1.png
          test-image-1.png
          11 kB

        Issue Links

          Activity

            People

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