Friday, May 20, 2011

Effect of changing InnoDB Page Size

Was bored so I started playing with what the performance impact of changing the innodb page size was. Interesting results from XtraDB (which makes it oh so easy to change the page size). I won't go into the gory details but the testing performed was against a machine with 6x146GB SAS drives and a read-only sysbench test (50 million records, 10GB innodb buffer pool):

The graph shows that the good old defaults work quite nicely. I'll have to get my hands on some machines with SSD drives and try this again :)