Changing default-storage-engine

Telematica_at

• December 02, 2017 09:29

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.

• 

  cPanelMichael

  • December 05, 2017 18:08

  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.

  0
• 

  Telematica_at

  • December 05, 2017 19:09

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

  0

Please sign in to leave a comment.