brotherhood_of_LAN - 1:22 am on Mar 17, 2013 (gmt 0)
Good thread... it's worth mentioning that MyISAM relies on the OS cache but InnoDB will take care of its own cacheing, and that WP will use whichever storage engine is the default for your particular MySQL version (AFAIK).
InnoDB became the default in MySQL 5.5
If any WP tables do not have sequential inserts then they will become fragmented and will perform at less than optimal speed. [mysqlperformanceblog.com...]