Re: CREATE INDEX Online DDL Not Working
Hi,
Online DDL does not imply that it is necessarily faster than before. The point of online DDL is that it will be possible to read and write to the table while the DDL is ongoing.
There is no way to create an index without actually writing the pages of the index to disk. That said, InnoDB secondary index creation should be faster in MySQL 5.7 since an improved algorithm is used.
Regards,
Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway
Subject
Views
Written By
Posted
1803
June 20, 2016 05:02AM
Re: CREATE INDEX Online DDL Not Working
989
June 22, 2016 12:43AM
911
June 23, 2016 07:07PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.