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

LP:1008334 - Benchmark Query 4x Faster on MySQL 5.5

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      Running this query is almost four times faster on MySQL than the same version of MariaDB.

      SELECT BENCHMARK(10000000,DATE_SUB(FROM_UNIXTIME(RAND() * 2147483648), INTERVAL (FLOOR(1 + RAND() * 365)) DAY));

      Results on Workstation Win7 x64 16gb i7 3ghz

      • MariaDB 5.3.3 - 17.05 secs
      • MySQL 5.5.17 - 4.09 secs

      Results on Server Win2k8 R2 x64 8gb Xeon 1270 3.4ghz

      • MariaDB 5.5.24 - 22.09 secs
      • MySQL 5.5.24 - 5.90 secs

      Results on older server running Win2k3 x32 4gb Xeon 5050 3ghz

      • MySQL 5.0.27 - 22.00 secs

      Is there any reason this query would be running so much slower on MariaDB vs MySQL?

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            brianboatright Brian Boatright (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.