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

Instant add column for InnoDB

    XMLWordPrintable

Details

    • 10.2.4-5, 10.3.1-2

    Description

      Add support for instant add column for InnoDB when adding a new column with a default value last.

      We have got patches from Alibaba and TenCent for doing this. We should choose either one or merge them.

      The idea in both patches is to add a new row type to InnoDB where the number of columns
      are stored in each row in 1-2 bytes. When creating a row we store the current number of columns. This allows us to fill any extra columns with default values on read.

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              monty Michael Widenius
              Votes:
              1 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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