Table tweak for a faster blog
This is what happens when you’re busy shifting base—you lose track of useful signal. I was out of sync when Mr Wordpress slipped-in this gem last December. I found it while Googling for Matt’s notes from MySQL Camp at Google.
While I have no access to MySQL conf on my host to incorporate all the recommended changes, I could still speed this site up a bit just by setting most of the tables to InnoDB engine (with the exception of wp_posts table, which still needs to be set to MyISAM engine due to lack of FULLTEXT index features in InnoDB). In fact, wp_posts table refuses to be set to InnoDB when you try this—at least on my host:
ALTER TABLE wp_posts ENGINE = INNODB;
(Remember to replace the default wp_ table suffix to whatever you’re using; I don’t use the default by the way.)
Honestly, I would be happy to see MyISAM++ out soon and supported on my host1, now that InnoDB—as a technology—is exclusively Oracle’s baby.
- MyISAM++ is prophesied to have InnoDB’s features and more. [←]