The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

default storage engine is not InnoDB for MySQL 5.5?

Discussion in 'Database Discussions' started by ladydi711, Feb 24, 2016.

  1. ladydi711

    ladydi711 Well-Known Member

    Joined:
    Sep 4, 2001
    Messages:
    120
    Likes Received:
    3
    Trophy Points:
    18
    On the Software page of WHM, I am set to use MySQL 5.5 and it indicates that InnoDB should be the default storage engine.

    However, it seems my setting is using MyISAM

    in /etc/my.cnf:
    default-storage-engine=MyISAM

    I found some references on the forum to cPanel upgrade script having the habit of setting this. Is that possibly what happened?

    Also, I'd like to change to InnoDB as the default engine. Is there a preferred method to do this in cPanel/WHM that will keep the setting?

    Thanks in Advance!
     
  2. syslint

    syslint Well-Known Member

    Joined:
    Oct 9, 2006
    Messages:
    249
    Likes Received:
    6
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    You can set it in /etc/my.cnf . Even if you have MyISAM db's it works fine along with the default innodb settings. You can also convert MyISAM dbs into InnoDb .

    PS: InnoDB is better
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Yes, it's by design that MyISAM is configured as the default storage engine for MySQL on cPanel. Is there any particular reason you prefer to make InnoDB the default storage engine?

    Thank you.
     
  4. ladydi711

    ladydi711 Well-Known Member

    Joined:
    Sep 4, 2001
    Messages:
    120
    Likes Received:
    3
    Trophy Points:
    18
    Hi Michael,

    Thanks for the response.

    That was my original thought that the preferred cPanel default storage engine was MySQL, however, my Software page indicates InnoDB should be the default engine (image attached).

    I have also seen several references here on the forum (including this one) that InnoDB is "better".

    I have at least two customers requesting InnoDB be the default storage engine.
     

    Attached Files:

  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You can make InnoDB the default storage engine for MySQL without an adverse affect on cPanel functionality. Feel free to do so and let us know of any issues you encounter. Here's an older thread where users discuss the advantages/disadvantages of InnoDB that you may find helpful:

    InnoDB keep as default, when the default engine is MyISAM

    It's also good to review your /etc/my.cnf file anytime you plan to upgrade to a newer version of MySQL or to MariaDB.

    Thank you.
     
Loading...

Share This Page