InnoDB, Page Size, and SSD
I finally figured out how to run with a custom page size on InnoDB. It looks like there’s a bug with innodb_file_per_table and 8k pages in MySQL 4.1 through 5.1. On a whim I just decided to try a very basic configuration and it worked.
Now comes the real fun. It turns out that on InnoDB you’re basically a fool to attempt using a custom page size.
It turns out that InnoDB is highly inefficient when it comes to running with a custom page size and becomes CPU bound immediately.
The good news is that during one run InnoDB was able to best MyISAM with an 8k page size.
I haven’t yet been able to duplicate it as InnoDB is now using 100% of the CPU doing about 4 queries per second.