Database Question

[Dknelson]

When I go tot he support page in my control panel, I get this recommendation.

InnoDB database tables typically perform more efficiently and reliably than other database engines such as MyISAM on most modern hosts when configured correctly. It is strongly encouraged to ensure all of your database tables are using the InnoDB storage engine, and that your hosting provider has configured MySQL for InnoDB use.

Right now, I have a mix of MySam and InnoDB tables.  I know how to swap them all to InnoDB but when I asked my host about it, this was their response.

You need to convert only tables that benefits greatly from being under InnoDB. Please refer the link to read more on this:

https://www.knownhost.com/kb/what-is-the-difference-between-myisam-and-innodb/

The risk of converting are memory errors as innodb_buffer_pool_size configuration provides the value of buffer pool size and data crash. Pleas make sure to take a sql backup before any changes.
 

So now I'm a bit confused.  Should I just ignore the Invasion recommendation or ignore my hosts recommendation?

[Randy Calvert]

The host recommendation is from like the 90’s. It’s not problematic in modern versions of MySQL anymore.  Generally you won’t find any MODERN app not recommend innodb. 

[Dknelson]

Thanks.  I have swapped them all to Inno.

[Randy Calvert]

I'm glad you were able to get it squared away!  🙂