My Oracle Support Banner

Does A Long Running ALTER TABLE DDL Statement Spawn Single Large Transaction in Group Replication? (Doc ID 2699700.1)

Last updated on AUGUST 11, 2020

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Goal

ALTER TABLE operation (e.g. changing the column data type) on a very large table can take very long time. Does it spawn single large transaction in Group Replication which can cause communication issues between nodes?

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
References


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