page size
For releases up to and including MariaDB 5.5, the size of each InnoDB page is fixed at 16 kilobytes. This value represents a balance: large enough to hold the data for most rows, yet small enough to minimize the performance overhead of transferring unneeded data to memory. Other values are not tested or supported.
Starting in MariaDB 5.6, the page size for an InnoDB instance can be either 4KB, 8KB, or 16KB, controlled by the innodb-page-size configuration option. You set the size when creating the MariaDB instance, and it remains constant afterwards. The same page size applies to all InnoDB tablespaces, both the system tablespace and any separate tablespaces created in file-per-table mode.
Smaller page sizes can help performance with storage devices that use small block sizes, particularly for SSD devices in disk-bound workloads, such as for OLTP applications. As individual rows are updated, less data is copied into memory, written to disk, reorganized, locked, and so on.
See also disk-bound.
See also file-per-table.
See also instance.
See also OLTP.
See also page.
See also SSD.
See also system tablespace.
See also tablespace.