Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Employee MySQL Performance: MySQL 5.6 -vs- MySQL 5.5 -vs- MariaDB 5.5
+14 Vote Up -4 Vote Down

Finalizing my series of MySQL 5.6 -vs- MySQL 5.5 benchmarks (best-to-best results and config settings (1), scalability (2), tuning details and yet more test results (3)), I've realized that it just needs a one point more - MariaDB results..

One of my friends called me to tell a story about an article in one of computer magazines saying that "If you're having performance issues with MySQL 5.5, you should try MariaDB 5.5 and you'll be surprised!"..

It waked up my curiosity. MariaDB-10 seems to be only in alpha stage for the moment, and the latest stable MariaDB version in 5.5. So I've installed the latest for today MariaDB-5.5.29, and executed exactly the same Sysbench workloads on MariaDB too.

However, the results I've observed reminded me the old heavy days in the past years while we were fighting agains all the bottlenecks in MySQL 5.5.. Situation is greatly improved now in MySQL 5.6, and from the following you'll see why you need to upgrade to MySQL 5.6 asap! ;-)

I will not spend more time on it, but just sharing here my results.

Note:

  • I've used the same "original" Sysbench
  • same test cases
  • same MySQL 5.6 Community Edition (GPL) and same MySQL 5.5 Community Edition (GPL)
  • same config settings as in previous posts
  • so, exactly the same conditions for everything..
  • just added MariaDB 5.5 into a game..

As before, best-to-best obtained results are presented in TPS and QPS. As well, I'm also including here corresponding "scalability" graphs to confirm you that on 16cores MySQL 5.6 is still same or faster than 5.5, but, of course, on a bigger server with 24, 32 or more cores you'll see a real MySQL 5.6 power in action! ;-))

Sysbench OLTP_RO :



Sysbench OLTP_RO-trx :



Sysbench OLTP_RO 8-tables :



Sysbench OLTP_RO-trx 8-tables :



Sysbench OLTP_RO Point-Selects :



Sysbench OLTP_RO Point-Selects 8-tables :



Sysbench OLTP_RO Simple-Ranges :



Sysbench OLTP_RW 10M :



Sysbench OLTP_RW 10M 8-tables :



SUMMARY :

  • as you can see, MySQL 5.6 GA has the best performance, followed by MySQL 5.5, and MariaDB 5.5 comes in last..
  • so, if you're getting performance problems with MySQL 5.5, then upgrade to MySQL 5.6 asap and you'll be really surprised!!! ;-)
  • and it's not only about performance.. - get a look on a full list of all new MySQL 5.6 features presented by RobY and PeterZ, as well a very good DBA & developer guide with many other details..

Rgds,
-Dimitri

Votes:

You must be logged in with a MySQL account to vote on Planet MySQL entries. More information on PlanetMySQL voting.

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.