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.



%d bloggers like this: