Learn about Centmin Mod LEMP Stack today
Become a Member

Include option to enable InnoDB during setup

Discussion in 'Feature Requests & Suggestions' started by deltahf, Mar 2, 2015.

Tags:
  1. deltahf

    deltahf Active Member

    216
    104
    43
    Jun 8, 2014
    Ratings:
    +161
    Local Time:
    7:23 PM
    I was looking into tuning MySQL, when I suddenly looked at my.cnf and realized that skip-innodb was uncommented (And I've been running my big XenForo board on MyISAM all this time...no wonder DB performance is shaky under load! :banghead:) I immediately realized that I had forgotten to change this setting when I moved to Linode last year, and I suppose that when I moved my InnoDB databases over, it just quietly restored the tables into MyISAM without objection.

    I'm sure InnoDB is disabled for a reason in Centminmod, but this could catch a lot of novice users off guard who may not touch their my.cnf. I think it would be a good idea to mention this somewhere in the setup, and to provide a quick option for whether or not they would like InnoDB enabled by default or not. :)
     
    • Like Like x 2
  2. eva2000

    eva2000 Administrator Staff Member

    30,947
    6,915
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,413
    Local Time:
    10:23 AM
    Nginx 1.13.x
    MariaDB 5.5
    Yeah .07 would have InnoDB disabled by default as it goes back to fact Centmin Mod LEMP stack was originally made for low memory systems 256-512MB VPS and low disk space <20GB VPS. So enabling InnoDB would consume excessive memory and disk space. The other reason is, InnoDB engine enabling or using InnoDB tables doesn't automatically give better performance unless you tune your MySQL InnoDB specific settings and that is different to MyISAM table tuning. If folks aren't aware of this, can get messy with InnoDB tables as InnoDB table repair, backup and maintenance is different to MyISAM. Folks can end up corrupting their data if they do not know what they are doing on InnoDB tables. e.g. backing up and restoring individual InnoDB data files like they would MyISAM data files would corrupt their data etc.

    It's much safer, for folks who need InnoDB to convert tables from MyISAM to InnoDB and have the InnoDB know-how. Then for folks who don't have a clue on differences between MyISAM and InnoDB table management etc to permanently corrupt their databases with no avenue for data recovery :)

    But yes, will figure out where in the initial install process, I can mention this :)

    However, with Centmin Mod .08 beta MariaDB 10 default requires InnoDB enabled. So guess that safeguard doesn't play out :eek:
     
    • Like Like x 1
    • Informative Informative x 1
  3. jeffwidman

    jeffwidman Active Member

    152
    27
    28
    Dec 3, 2014
    Ratings:
    +51
    Local Time:
    4:23 PM
    I would argue the opposite--the biggest problem with MyISAM is that it isn't fully ACID compliant. There's a lot of horror stories of MyISAM tables becoming corrupted and losing data in the course of normal operation... without the admin even touching the db settings at all.
     
  4. eva2000

    eva2000 Administrator Staff Member

    30,947
    6,915
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,413
    Local Time:
    10:23 AM
    Nginx 1.13.x
    MariaDB 5.5
    yeah well hard to say, in 15yrs of using MyISAM i have never had tabe corruption that resulted in loss data. Really comes down to not what you use (myisam or innodb) but who and how you use it :)

     
  5. RoldanLT

    RoldanLT Well-Known Member

    3,978
    965
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,329
    Local Time:
    8:23 AM
    1.11
    10.2
    VB only works with MyIsam? :D
     
  6. eva2000

    eva2000 Administrator Staff Member

    30,947
    6,915
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,413
    Local Time:
    10:23 AM
    Nginx 1.13.x
    MariaDB 5.5
    vB4+ had extended InnoDB support