Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-30652

Compaction of innodb secondary index leaf page

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            marko Marko Mäkelä
            stephane@skysql.com VAROQUI Stephane
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.