MySQL Forums
Forum List  »  Performance

Re: CREATE INDEX Online DDL Not Working
Posted by: Øystein Grøvlen
Date: June 22, 2016 12:43AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: CREATE INDEX Online DDL Not Working
875
June 22, 2016 12:43AM


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.