MariaDB 10 vs 10.1 - performance gain?

[DroidOne]

I'm thinking of upgrading from Maria DB 10 to 10.1.

Has anyone here tried that? Was the upgrade problem free? Did you notice any improvements in performance?

 

[Sunka]

I have upgraded without problems.
Install 10.1.14 version, do not update to 10.1.15 couse have two bugs and it is deleted from download section. new version 10.1.16 will fix that 2 bugs.

 

[Nirjonadda]

I have upgraded without problems.
Install 10.1.14 version, do not update to 10.1.15 couse have two bugs and it is deleted from download section. new version 10.1.16 will fix that 2 bugs.

What bug have on 10.1.15 ? I am using MariaDB 10.1.15

 

[Sunka]

I am using too
https://jira.mariadb.org/browse/MDEV-10324
https://jira.mariadb.org/browse/MDEV-10333

They will release 10.1.16 sooner
MariaDB Jira fixed issues for 10.1.16

 

[Anthony Parsons]

Well... I just went from mysql 5.6 to mariadb 10.1, and just wow... amazing how much that small amount of performance makes with a couple hundred people active online at once (not cookie session, actual live - huge gain).

 

[Anthony Parsons]

For those who are graphical people... here is a 12hr snapshot of 5.6 - dip where I upgraded taking backup of server first - mariadb 10.1. Basically, my load issues where coming from the DB waiting on requests, and with six cores, I was getting annoyed at the waiting that was bottling up. As you can see to the right, my users were all there when I went live again, except this time with mariadb. Amazing difference. 5.6 was just horrible... especially when 5.5 looked more like the load after changing to mariadb. I expect upgrades to be better, not worse, for something like SQL DB's.

I normally hum along at a 2.5 - 3 load average when running mysql 5.5. It was getting ridiculous running 5.6. Mariadb is very nice once again.


My advice, stay on 5.5 or change to mariadb, but stay clear of mysql 5.6. Just horrible. And this is all with SSD cloud... 5.6 should be binned and never allowed on a production server.

 

[SametxChan]

@DroidOne ,

mariaDB 10.1.15 was bug, was no longer release download.

You can see more for changelog fixed: https://mariadb.com/kb/en/mariadb/mariadb-10116-changelog