Benchmark Query 4x Faster on MySQL 5.5
Bug #1008334 reported by
Brian Boatright
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Undecided
|
Vladislav Vaintroub |
Bug Description
Running this query is almost four times faster on MySQL than the same version of MariaDB.
SELECT BENCHMARK(
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?
Changed in maria: | |
status: | New → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
I've got similar difference on my machine on the latest releases (all release tarball packages):
MariaDB 5.5.24: ~25 sec
MariaDB 5.3.7: ~25 sec
MariaDB 5.2.12: ~8 sec
MySQL 5.5.25: ~8 sec
MySQL 5.6.5: ~20 sec