[MDEV-30652] Compaction of innodb secondary index leaf page Created: 2023-02-14  Updated: 2023-07-03

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Fix Version/s: None

Type: Task Priority: Major
Reporter: VAROQUI Stephane Assignee: Marko Mäkelä
Resolution: Unresolved Votes: 0
Labels: performance


 Description   

This is somewhat related to MySQL Bug #68546. In non-leaf InnoDB index pages, the "node pointer" records are currently constucted from child page records. This makes the keys unnecessarily large.

A non-leaf page pointer could have a one-character key that would be sufficient to distinguish longer VARCHAR columns in the child or leaf pages. For example, if the maximum and minimum keys on two sibling pages are "Jones" and "Smith", any single-character key between "K" and "S" would distinguish those child pages in the parent page.

In case of a multi-column key, we could store the last columns as empty strings or NULL when the columns are not declared NOT NULL.



 Comments   
Comment by Elena Stepanova [ 2023-03-27 ]

Please fill affected/fix versions.

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