Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

default storage engine is not InnoDB for MySQL 5.5?

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

  1. ladydi711

    ladydi711 Well-Known Member

    Joined:
    Sep 4, 2001
    Messages:
    139
    Likes Received:
    6
    Trophy Points:
    318
    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:
    262
    Likes Received:
    6
    Trophy Points:
    168
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,704
    Likes Received:
    1,883
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. ladydi711

    ladydi711 Well-Known Member

    Joined:
    Sep 4, 2001
    Messages:
    139
    Likes Received:
    6
    Trophy Points:
    318
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,704
    Likes Received:
    1,883
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice