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 :)

1 comment:

Anonymous said...

Hi Partha,

Could you please share more on innodb pages? I have been looking into increasing the page size to 32K/64K for BLOB columns.
What kind of adverse effect do you supect with this?

Thanks !