InnoDB vs MyISAM

[CesarManara]

Hi there! I have a SMF 2.1 forum installed and all its tables are running InnoDB. I have been wondering if it'd be okay to change them all to MyISAM, as even though they are slower, MyISAM seems a bit more robust in terms of data loss and crashes repair.

Are there any tables I should keep as InnoDB? What is the recommendation on that?

How could I go about updating all the tables to MyISAM? Is there a SQL Query that will do it all?

Cheers!

[Kindred]

In general, you should not mess with that, as a matter of fact, it was intentional, the shiftto innodb

[albertlast]

MyIsam is the direct opposite of what you say,
it's mostly faster because is less crash safe.

And in the commone mysql/mariadb version is innodb or somthing similiar the default db engine,
which mean it's in focus of database development and myisam is dead. http://dev.mysql.com/doc/refman/5.7/en/storage-engines.html

[CesarManara]

It may be that the advice is old at the hosting where I read it about InnoDB vs MyISAM then, thank you.