tencent cloud

TDSQL-C for MySQL

DocumentationTDSQL-C for MySQLKernel FeaturesPerformance FeaturesParallel DDL

Parallel DDL

Download
Focus Mode
Font Size
Last updated: 2026-09-09 16:18:37
AI-Translated & Reviewed
TDSQL-C for MySQL (with the TXSQL kernel) provides parallel DDL capabilities. This capability is implemented based on the Parallel Reader framework at the InnoDB layer. It leverages multi-core CPUs and storage I/O bandwidth to significantly reduce data copy time, thereby shortening the overall DDL execution time, preventing the blocking of subsequent related DML operations, and reducing the waiting time for DDL operations.

Supported Versions

TDSQL-C for MySQL 8.0 3.1.16.004 and later versions.

Use Limits

Currently, parallel DDL cannot be used in the following scenarios:
The innodb_txsql_parallel_ddl switch is not enabled.
The table size is relatively small.
Create an index using an AUTO_INCREMENT column.
Create a spatial index.
Create an fts index.
The index contains a multi-value column.
The index contains a virtual column.

Parameter Description

The parallel DDL capability of TDSQL-C for MySQL is implemented through parameter settings:
After the kernel version requirement is met, control the behavior through the innodb_txsql_parallel_ddl, innodb_txsql_ddl_threads, and innodb_txsql_ddl_buffer_size parameters.
Parameter Name
Restart
Global Parameter
Default Value
Modifiable Parameter Values
Description
innodb_txsql_parallel_ddl
Yes
Yes
OFF
OFF | ON
Parallel DDL feature switch.
OFF: Disable the parallel DDL feature.
ON: Enable the parallel DDL feature.
innodb_txsql_ddl_threads
Yes
Yes
4
[1 - 256]
Controls the number of parallel threads for each DDL operation.
A value of 1 indicates that DDL operations are executed in single-threaded mode.
innodb_txsql_ddl_buffer_size
Yes
Yes
10485760
[1048576 - 536870912]
Controls the memory size for storing sampled data during parallel index creation.

Usage Notes

SET innodb_txsql_parallel_ddl = ON;
SET innodb_txsql_ddl_threads = 4; // This setting relates to instance specifications. You can increase the number of parallel threads when the specifications are high.
Previous Topic: Parallel Initialization of InnoDB Buffer PoolNext Topic: Database Audit

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback

Search
    Enter keywords to search documentation