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.
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: