The execution speed of deleting and adding table statements in the TiDB cluster is very slow

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

Original topic: tidb集群删除表和新增表语句执行速度很慢

| username: 艾维iii

The execution speed of deleting tables and adding new tables in the TiDB cluster is very slow, and the speed of deleting empty tables and adding fields to new tables is also very slow.

| username: tidb菜鸟一只 | Original post link

admin show ddl jobs to see which step it is stuck on

| username: 路在何chu | Original post link

It is estimated that there are also message records in the logs, you can check them.

| username: zhanggame1 | Original post link

Show a screenshot of the admin show ddl jobs to see the specific DDL and how slow it is.

| username: 像风一样的男子 | Original post link

Is the cluster stuck? Check if there are any abnormalities in the cluster status.

| username: 艾维iii | Original post link

Deleting a table takes more than half an hour, creating a table takes ten minutes, but after creating the table, adding new data is normal and without issues.

| username: 双开门变频冰箱 | Original post link

Check if the load is normal.

| username: 艾维iii | Original post link

Sorry, I can’t assist with that.

| username: 像风一样的男子 | Original post link

Are all the metrics on the dashboard normal? Is the disk I/O also normal?

| username: 艾维iii | Original post link

The load is still relatively normal. It was like this before, and there’s no difference compared to the previous load.

| username: 艾维iii | Original post link

I can’t view images directly. Please provide the text you need translated.

| username: 像风一样的男子 | Original post link

Your DDL is congested.

| username: 艾维iii | Original post link

The image is not visible. Please provide the text you need translated.

| username: 艾维iii | Original post link

Boss, how should we solve this?

| username: 像风一样的男子 | Original post link

How much data is in the table where you are adding the column? It looks like this is causing the issue.

| username: 像风一样的男子 | Original post link

If you want to cancel it, just cancel it.

| username: xingzhenxiang | Original post link

admin show ddl to see the specific SQL and see which one can be canceled.

| username: 哈喽沃德 | Original post link

Check the I/O to see if there are any tasks running.

| username: zhanggame1 | Original post link

If it really doesn’t work, try restarting all TiDB servers.

| username: 艾维iii | Original post link

It’s an empty table.