What to do if the newly created index in TiDB is not taking effect? Urgently waiting online

Translated
1

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

Original topic: tidb 新建的索引迟迟无法生效 怎么办？着急在线等

| username: tidb狂热爱好者

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version]
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration]
[Attachments: Screenshots / Logs / Monitoring]

Please help, unable to create an index.

2
| username: tidb狂热爱好者 | Original post link

Enter the TiDB server of the cluster
Run the following commands on all TiDB servers:
service tidb stop
service tidb start

3
| username: WalterWj | Original post link

Please provide the result of admin show ddl jobs 50;.

4
| username: xfworld | Original post link

Useless~ Just wait patiently for the job to finish executing.

5
| username: xingzhenxiang | Original post link

The large index is just slow, sometimes it takes me 12 hours.

6
| username: BraveChen | Original post link

Creating an index essentially involves organizing another data structure. The larger the amount of data, the more time it takes.

7
| username: h5n1 | Original post link

This is not a question post, it’s a demonstration post.

8
| username: Running | Original post link

Disable DDL operations related to this table, or reduce read and write operations on the index fields to increase the speed of index creation. Also, check the disk space.

9
| username: liuis | Original post link

Wait patiently.

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

TiDB can create indexes concurrently now, right? Enable some concurrency.