Can TiDB DDL JOBs be executed concurrently?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TiDB DDL JOB可以同时执行多个吗

| username: alfred

【TiDB Usage Environment】Production, Testing, Research
【TiDB Version】
【Encountered Problem】
【Reproduction Path】Operations performed that led to the problem
【Problem Phenomenon and Impact】

【Attachments】

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

| username: ddhe9527 | Original post link

There are a total of 2 queues for DDL JOB: one is the job queue, and the other is the add index queue. Jobs in these two queues can be executed simultaneously, but jobs within each queue are executed serially. However, I heard that support for multiple DDLs to be executed in parallel is coming soon.

| username: forever | Original post link

The topic was just discussed a couple of days ago, you can check it out at 多个表并行加索引,只能串行一个一个在running状态,其它都在排队 - TiDB 的问答社区

| username: DBAhank | Original post link

The PTCA V6 course mentions multiple times that regular DDL and index-adding DDL belong to two different job queues and can be executed in parallel.

| username: Raymond | Original post link

It should be possible to execute multiple DDLs starting from version 6.2.

| username: alfred | Original post link

Indeed, support is needed, otherwise changes will be too slow.

| username: system | Original post link

This topic will be automatically closed 60 days after the last reply. No new replies are allowed.