In this blog post, we’ll discuss how a small innodb_page_size can create a performance boost for SSD.
In my previous post Testing Samsung storage in tpcc-mysql benchmark of
Percona Server I compared different Samsung devices.
Most solid state drives (SSDs) use 4KiB as an internal page size,
and the InnoDB default page size is 16KiB. I wondered how using a
different innodb_page_size might affect the
overall performance.
Fortunately, MySQL 5.7 comes with the option
innodb_page_size, so you can set different
InnoDB page sizes than the standard 16KiB. This option is still
quite inconvenient to use, however. You can’t
change innodb_page_size for the existing
database. Instead, you need to create a brand new database with a …