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

Instant Add Column Documentation Clarification

    XMLWordPrintable

Details

    Description

      https://mariadb.com/kb/en/library/instant-add-column-for-innodb/ states in the Limitations section:

      "If the table becomes empty (either via TRUNCATE or DELETE), the table will be converted to the old "non-instant" format."

      The fact that this is listed as a limitation, and the fact that it makes reference to 'the old "non-instant" format' both imply some sort of limitation. This leads users to understand that the instant add column ability is being lost in cases where the documentation states the table is being converted to "the old format".

      Explaining that columns added 'instantly' are stored in separate structures associated with the table like BLOB columns, and operations like emptying the table take the opportunity to flatten out the table definition, incorporating the instantly added columns into the main table structure, without referring to it as "the old non-instant format", would avoid the misunderstanding.

      Attachments

        Activity

          People

            KennethDyer Kenneth Dyer (Inactive)
            juan.vera Juan
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.