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!
In general, you should not mess with that, as a matter of fact, it was intentional, the shiftto innodb
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
It may be that the advice is old at the hosting where I read it about InnoDB vs MyISAM then, thank you.