Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
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
- relates to
-
MDEV-10453 Allow ONLINE or ALGORITHM=INPLACE with OPTIMIZE TABLE
-
- Open
-
aadant, I was confused by the mention of secondary indexes in the description. A table rebuild (rebuilding the clustered index) can happen online, but it will obviously consume more space than merely dropping and creating the secondary indexes, because a new copy of all data will be made. Actually, if the desire is to save disk space, then rebuilding the secondary indexes could have an undesired effect of causing the data files to contain lots of freed pages.
If we ignore the request about secondary indexes, this sounds like a duplicate of MDEV-10453.