Unexpected Table Rebuilds In 5.7.23 To 5.7.26 For "Inplace" DDL
(Doc ID 2524820.1)
Last updated on FEBRUARY 27, 2020
Applies to:MySQL Server - Version 5.7 and later
Information in this document applies to any platform.
For versions such as 5.7.22, a ALTER TABLE .... ADD INDEX ... would complete quickly without table rebuild.
In 5.7.23 full table may be rebuilt, which takes a long time and consumes disk i/o and space.
Server was upgraded to 5.7.23, 5.7.24, 5.7.25, or 5.7.26.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document