default storage engine is not InnoDB for MySQL 5.5?
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!
-
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 0 -
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. 0 -
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. 0 -
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. 0
Please sign in to leave a comment.
Comments
4 comments