Changing default-storage-engine

Telematica_at

Member
Oct 6, 2015
17
0
51
Austria
cPanel Access Level
Root Administrator
Hello,

i have some questions to the default-storage-engine in cpanel 68 and mariaDB and i hope you can help me out of my questions.. :)

First:
As default mysql has InnoDB as default storage engine but vanilla cPanel installation put "default-storage-engine = MyISAM" into the my.conf file.

Is there any background why cpanel recommends myISAM for mysql?


Second:
I read a lot on internet that InnoDB has more performance like myISAM for shared hosting enviroments, so i am thinking about to change the default-storage-engine value in the my.conf file from MYISAM to InnoDB.. is this safe to do, also if there are still many hundreds of hosting accounts on the cPanel server?


Last:
also if there is set "MyISAM" as default storage engine in my.conf i see that there are 2x more InnoDB tables on my cpanel Server like MyIAM talbes? Why that? i thought if "default storage engine" is set to "myISAM" then every new table will be myisam? If not, for what is this "default-storage-engine" else setting for?


Thanks for your help.
 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,216
463
Hello,

Is there any background why cpanel recommends myISAM for mysql?
Repairing InnoDB tables is often a challenging process and thus it's not the default storage engine. You can search for "InnoDB" to get a better idea of issues users have faced.

I read a lot on internet that InnoDB has more performance like myISAM for shared hosting enviroments, so i am thinking about to change the default-storage-engine value in the my.conf file from MYISAM to InnoDB.. is this safe to do, also if there are still many hundreds of hosting accounts on the cPanel server?
It's supported, but you may want to research to determine if that's the best choice for your server. MariaDB offers a useful document on this topic at:

Choosing the Right Storage Engine

also if there is set "MyISAM" as default storage engine in my.conf i see that there are 2x more InnoDB tables on my cpanel Server like MyIAM talbes? Why that? i thought if "default storage engine" is set to "myISAM" then every new table will be myisam? If not, for what is this "default-storage-engine" else setting for?
The setting configures the default storage engine, but it doesn't prevent the use of InnoDB. Are you sure those tables were not created with InnoDB designated as the storage engine? See:

MySQL :: MySQL 5.5 Reference Manual :: 15.1 Setting the Storage Engine

Thank you.
 

Telematica_at

Member
Oct 6, 2015
17
0
51
Austria
cPanel Access Level
Root Administrator
Hello again, and thank you for your answer:

Hello,

Repairing InnoDB tables is often a challenging process and thus it's not the default storage engine. You can search for "InnoDB" to get a better idea of issues users have faced.

It's supported, but you may want to research to determine if that's the best choice for your server. MariaDB offers a useful document on this topic at:

Choosing the Right Storage Engine
Thank you for your answer. i read this article and yah, also there the prefer for mariaDB the "innoDB" database over the MyISAM one... Also with MariaDB 10.2 it is the default engine there too...