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

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated: