Feature Description
This parameter controls whether to enable the online replication DDL feature.
Limitations
1. Starting from TDSQL Boundless version V21.6.3.0, tables without a primary key also support Online Copy DDL. Set this parameter to ON to enable the feature.
2. The following operations cannot be performed Online even when tdsql_use_online_copy_ddl is ON. To proceed with the DDL, first set this parameter to OFF to downgrade to Offline mode.
Drop Primary Key from a table that has a primary key.
Add Primary Key to a table without a primary key.
Modify partitioning rules (such as the number of partitions and partitioning algorithm) for a partition table without a primary key.
Convert a non-partitioned table without a primary key into a partition table.
Attribute Description
|
Parameter Type | BOOL |
Default Value | ON |
Value Range | OFF ON |
Effective Scope | GLOBAL SESSION |
Restart Required | No |