[MDEV-6075] Allow > 16K pages on InnoDB Created: 2014-04-11  Updated: 2019-03-22  Resolved: 2014-05-13

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: 10.1.0

Type: Task Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: innodb

Issue Links:
Problem/Incident
causes MDEV-11828 innodb_page_size=64k must reject ROW_... Closed
causes MDEV-19016 Table in InnoDB data dictionary conta... Closed

 Description   

Currently maximum page size inside InnoDB is 16K. This is problematic especially if you have a lot of blob objects because at least part of the blob is always stored on single page and only ther remainder externally stored. This leads to situation where you can have only limited amount of columns as blobs.

Therefore, plan is

1) Increase the supported page size to 64K for COMPACT row format
2) Research if same can be supported for DYNAMIC row format

Currently, I do not have plans to support > 16K pages on COMPRESSED row format.

 Comments   
Comment by Jan Lindström (Inactive) [ 2014-05-13 ]

revno: 3987
committer: Jan Lindström <jplindst@mariadb.org>
branch nick: 10.1
timestamp: Tue 2014-05-13 13:28:57 +0300
message:
MDEV-6075: Allow > 16K pages on InnoDB

This patch allows up to 64K pages for tables with DYNAMIC, COMPACT
and REDUNDANT row types. Tables with COMPRESSED row type allows
still only <= 16K page size. Note that single row size must be
still <= 16K and max key length is not affected.

Generated at Thu Feb 08 07:09:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.