default storage engine is not InnoDB for MySQL 5.5?

ladydi711

Well-Known Member
Sep 4, 2001
140
6
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!
 

syslint

Well-Known Member
Verifed Vendor
Oct 9, 2006
268
7
168
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
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.
 

ladydi711

Well-Known Member
Sep 4, 2001
140
6
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.
 

Attachments

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
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.