maria-discuss team mailing list archive
Mailing list archive
Re: 5.5 versus 10.0/5.6 performance issues
You can use the Oracle InnoDB instead of XtraDB on MariaDB, it could be
interresting to test if it makes a real difference on your specific usecase.
To do so, you must put that in our my.cnf file :
Le 02/07/2013 16:56, Puff, Werner a écrit :
Because of performance issues with our DBMS we recently decided to
migrate our software to MySQL or one of its forks. We would prefer
We created a performance test suite so that we are sure to make the
Beside other values our test measured the average workflow processing
time including multiple database transactions. The unexpected outcome
was, that we had a big difference in the processing times between 5.5
and 5.6 based databases.
(lower = better)
MySQL 5.6 233
Percona 5.6pre 208
MariaDB 10alpha 194
MariaDB 5.5 1248
MySQL 5.5 993
(Firebird 2.5 9694)
We are bound to very special hardware, the biggest bottleneck there is
USB-stick based storage (cannot be changed for now).
Our interpretation of the results and the research we were doing so
far is, that the changes within InnoDB/XtraDB storage engine in
connection with our "very special" storage solution causes this
Can anybody confirm that the changes had a high impact on storage
mediums with slow access rates?
Or does anybody have an idea if it possible to optimize MariaDB 5.5
(we would like to go with MariaDB) to get the same performance with