[MDEV-7060] Increase UNIV_PAGE_SIZE_MAX to 64KB for row_format=compressed Created: 2014-11-10 Updated: 2019-03-22 Resolved: 2019-03-22 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB, Storage Engine - XtraDB |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Minor |
| Reporter: | Jan Lindström (Inactive) | Assignee: | Jan Lindström (Inactive) |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Description |
|
https://github.com/facebook/mysql-5.6/commit/df321e63c8743b1610d416628c20f4699e448d7e MySQL 5.6 already has support for configurable page size so bumping up Unlike the other allowable page sizes, the extent size was increased to Also, at page sizes above 16KB, the offset stored in the dense directory Because UNIV_PAGE_SIZE has a type now ((ulint) srv__page_size) some precompile assertions This task will allow > 16K pages also for row_format=compressed |
| Comments |
| Comment by Marko Mäkelä [ 2019-03-22 ] |
|
I think that we should deprecate InnoDB’s ROW_FORMAT=COMPRESSED rather than extend it in any way. I designed and implemented it based on Heikki Tuuri’s high level ideas. It may have been a good idea in the early 2000s when SSDs were not yet in widespread use. |