MySQL Forums :: Performance :: CREATE INDEX Online DDL Not Working


Advanced Search

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
CREATE INDEX Online DDL Not Working 608 Jayanath Dissanayake 06/20/2016 05:02AM
Re: CREATE INDEX Online DDL Not Working 331 Øystein Grøvlen 06/22/2016 12:43AM
Re: CREATE INDEX Online DDL Not Working 299 Rick James 06/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.