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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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

            Assignee:
            wlad Vladislav Vaintroub
            Reporter:
            brianboatright Brian Boatright (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: