Has anyone done any more work on recompiling InnoDB with 4k pages and benchmarking under SSD?
We’re building out a new DB that uses very small records (around 32-64 bytes) so reading a whole 16k for this record should have a performance difference.
I haven’t seen any benchmarks on 16k random read IOPS on the Intel SSD but my hunch is that there will be a 20-30% penalty here.
Though even if it was a 4x penalty that would still be about 9k transactions per second which is pretty good.
On a personal note I just bought a new Mac Book Pro which will be upgraded to the Intel X-25M MLC SSD.
Needless to say I’m very excited!