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 :)
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 :)
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:
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 !
-Shivani
Post a Comment