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 :)
Showing entries 1 to 1
May
20
2011
Showing entries 1 to 1