My Oracle Support Banner

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.

Symptoms

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.

Changes

Server was upgraded to 5.7.23, 5.7.24, 5.7.25, or 5.7.26.

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.