[MDEV-28469] Option to increase InnoDB page size to 128K Created: 2022-05-04 Updated: 2022-05-04 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Dik | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | innodb | ||
| Description |
|
Currently the InnoDB page size can be adjusted by setting for example innodb_page_size = 64K. 64K is the current limit, but 128K would be a welcome option for some use cases. |
| Comments |
| Comment by Marko Mäkelä [ 2022-05-04 ] |
|
This would be equivalent to designing and implementing a new storage engine. There are numerous persistent data structures that store at most a 16-bit byte offset within a page. Within ROW_FORMAT=COMPRESSED pages, I chose 14-bit offsets, because at the time I implemented it, the InnoDB page size was hard-coded to 16KiB at compilation time. That is the reason why we only support ROW_FORMAT=COMPRESSED for up to innodb_page_size=16k. |