Tag

Parallel DDL

0 views collected around this technical thread.

Tencent Database Technology

Mar 30, 2023 · Databases

TXSQL Parallel DDL: Design, Implementation, and Performance

This article explains the challenges of slow DDL operations in MySQL, introduces TXSQL’s Parallel DDL framework—including Copy, Inplace, and Instant algorithms—details their design, implementation, code examples, and performance evaluations, and compares them with other database solutions.

DDLDatabase OptimizationMySQL

0 likes · 22 min read

TXSQL Parallel DDL: Design, Implementation, and Performance

Aikesheng Open Source Community

Feb 9, 2022 · Databases

Performance Evaluation of Parallel DDL in MySQL 8.0.27

This article investigates how the innodb_ddl_threads, innodb_ddl_buffer_size, and innodb_parallel_read_threads variables introduced in MySQL 8.0.27 affect parallel DDL execution speed and resource consumption, using a 50‑million‑row test table and presenting detailed benchmark results.

Database OptimizationInnoDBMySQL

0 likes · 7 min read

Performance Evaluation of Parallel DDL in MySQL 8.0.27