Quote:
Originally Posted by Sembroidery
On a store updated from older versions some (a few) tables show InnoDB while others are MyISAM. Would it be recommended to switch all tables to InnoDB?
|
Hello,
It is definitely recommended in 3 cases.
1) You are using the newest MySQL/MariaDB version.
or
2) You are experiencing the loss of productivity due to the Meltdown Fix.
https://forums.mysql.com/read.php?21,664350,664350#msg-664350
or
3) You are experiencing the MySQL error 'MySQL table is marked as crashed and should be repaired'
https://confluence.atlassian.com/confkb/mysql-table-is-marked-as-crashed-and-should-be-repaired-151519802.html
In other cases, it is recommended to measure the BEFORE/AFTER performance on a dev server.
Thank you.