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

Use InnoDB's fast index creation to rebuild secondary indexes during OPTIMIZE TABLE

    XMLWordPrintable

Details

    Description

      This is related to the following upstream feature request:

      https://bugs.mysql.com/bug.php?id=57583

      I want rebuild all secondary indexes on a table without specifying DDL for each index. It is much easier to run "alter table foo engine=innodb" for each table than to drop/add each index. However when I run "alter table foo engine=innodb" it does not appear to use fast index creation based on the space used by the table and reported in SHOW TABLE STATUS for the index.

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              10 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.