MySQL Bugs: #40310: Maria: slower than MyISAM in some 6.0 benchmarks (to be investigated)

Bug #40310	Maria: slower than MyISAM in some 6.0 benchmarks (to be investigated)
Submitted:	24 Oct 2008 14:17	Modified:	4 Jul 2013 7:44
Reporter:	Guilhem Bichot	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Server: Maria storage engine	Severity:	S3 (Non-critical)
Version:	6.0	OS:	Linux
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
The private URL in this bug report shows that Maria is 3-10 times than MyISAM in some internal benchmarks.
This bug stays "Open" and not "Verified" because we will need to look at each subtest of the benchmark to see if the slowdown is expected or not.
For example, a write-only benchmark will always be much slower for Maria because Maria has logging (unless CREATE TABLE TRANSACTIONAL=0), which writes to log for every data/index change and syncs this log to disk at the end of every statement.
That would be a case of "not a bug".
On the other hand, a significant slowdown in read-only benchmark can be a bug in Maria.
We will probably have to pick a few subtests, study them, fix any bugs, and then re-run the entire benchmark for comparison (many tests could have the same cause).

How to repeat:
run benchmarks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".