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?