Database Engine

Hatrix Hoster

• September 19, 2024 19:29

I know that there are two types of datbaase Engine: MYISAM and Innodb.

Heard also that innodb is the default one and modern in cpanel but it doesn't support repair option within it.

 

Whereas MYISAM supppor it. NOw as I web hosting provider serving to the cleints what database engine should I use?

• 

  rbairwell

  • September 19, 2024 20:36

  Only MyISAM, Archive and CSV tables support the MySQL "REPAIR TABLE" option https://dev.mysql.com/doc/refman/8.4/en/repair-table.html#repair-table-support : it isn't a cPanel limitation.

  It is much rarer for Innodb tables to get corrupted (due to the way they handle updates) - it it does develop a corruption, then it's best to stop the database server: set it into InnodbDB recovery mode ( https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html ) and dump the data before recreating the table.

  0

Please sign in to leave a comment.