1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MariaDB 10 vs 10.1 - performance gain?

Discussion in 'Server Configuration and Hosting' started by DroidOne, Jul 6, 2016.

  1. DroidOne

    DroidOne Well-Known Member

    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?
     
  2. Sunka

    Sunka Well-Known Member

    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.
     
    SametxChan and DroidOne like this.
  3. Nirjonadda

    Nirjonadda Active Member

    What bug have on 10.1.15 ? I am using MariaDB 10.1.15
     
  4. Sunka

    Sunka Well-Known Member

  5. Anthony Parsons

    Anthony Parsons Well-Known Member

    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).
     
    DroidOne likes this.
  6. Anthony Parsons

    Anthony Parsons Well-Known Member

    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.
    Screen Shot 2016-08-27 at 6.44.55 PM.png

    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.
     
  7. SametxChan

    SametxChan New Member

Share This Page