Adding Index in TiDB is Too Slow

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

Original topic: tidb新增索引太慢

| username: 小于同学

Adding an index in TiDB is too slow.

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

  1. To roughly query the data volume of the table:
select table_name, table_rows from information_schema.tables where table_schema='xx' and table_name='xx';
  1. To check the execution progress of DDL:
admin show ddl jobs;
| username: 啦啦啦啦啦 | Original post link

What version?

| username: TIDB-Learner | Original post link

A table with 15GB and 17 million rows. Creating a single index takes about 15 minutes. Is this considered fast or slow?

| username: Kamner | Original post link

Check the GC latency situation.

| username: 小龙虾爱大龙虾 | Original post link

You’re too slow :joy_cat:

| username: 濱崎悟空 | Original post link

This is considered slow.

| username: 濱崎悟空 | Original post link

What is the specific scenario?