How much data can be added to TiDB indexes normally?

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

Original topic: 多大数据量可以正常增加tidb索引

| username: 小于同学

How much data can be added to a TiDB index normally?

| username: 迪迦奥特曼 | Original post link

You can add it normally, and the impact on online business is controllable.

DDL related principles

| username: ziptoam | Original post link

There shouldn’t be any strict limitations. After all, this is a distributed database, and you can add indexes during off-peak business hours.

| username: 濱崎悟空 | Original post link

There are no specific regulations.

| username: zhaokede | Original post link

As long as there is space, it can be added. Online DDL has very little impact on the business.

| username: lemonade010 | Original post link

In what scenario, theoretically, adding an index will not lock the table?