codinon
Reputation: 43
InnoDB vs MyISAM for small table Wordpress blog
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?
Upvotes: 2
Views: 956
Answers (1)
Rick James
Reputation: 142278
- 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
Upvotes: 4
Related Questions
- InnoDB or MyISAM - Why not both?
- Should I use MyISAM or InnoDB Tables for my MySQL Database?
- InnoDB or MyISAM?
- MyISAM vs InnoDB in a very large table
- Should I always prefer MySQL InnoDB over MyISAM?
- MyISAM vs Innodb and Innodb related tables
- MYSQL innodb or myisam? Which one is best for this case?
- Should I be using MyISAM or InnoDB (or something else)?
- InnoDB vs MyISAM for large table Wordpress blog
- MySQL: In which case should I choose MyIsam over innoDB?