My Oracle Support Banner

InnoDB DDL Algorithm Comparison on Large Tables in High Availability (GR) Scenarios (Doc ID 3028913.1)

Last updated on JULY 22, 2024

Applies to:

HeatWave - Version N/A and later
MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Goal

Comparison of INSTANT vs INPLACE vs COPY algorithms that are used within InnoDB DDL statements

Solution

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
Goal
Solution
 Instant
 Inplace
 Rebuild Table
 Concurrent DML
 Metadata Only
 Other DDL Operations
References

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