InnoDB vs MyISAM for small table Wordpress blog

Question

I have moved a WordPress site from a not so good hosting company to one to a host that specializes in WordPress hosting and performance. The old host did not allow InnoDB tables only MyISAM. Would like to take advantage of as many performance enhancements as possible. With that in mind which default WordPress tables which are best converted to InnoDB and which are best left as MyISAM?

Answer 1

• MySQL is moving toward getting rid of MyISAM.
• If you have a "small" site, you will be hard pressed to see a difference in performance.
• Perhaps the best performance boost comes from changing the schema for wp_postmeta: http://mysql.rjweb.org/doc.php/index_cookbook_mysql#speeding_up_wp_postmeta
• More on moving from MyISAM to InnoDB: http://mysql.rjweb.org/doc.php/myisam2innodb