Adding Index to Large Table, No Data in Monitoring Charts

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

Original topic: 大表添加索引,监控图表没数据

| username: Hacker_6ASfgBFe

[Test Environment for TiDB]
[TiDB Version] 5.4
Table with 120 million rows, partitioned table, added index, checked DDL monitoring chart, no data

| username: 江湖故人 | Original post link

Let’s see if there’s any activity here.

| username: Hacker_6ASfgBFe | Original post link

Which section is this monitoring graph in?

| username: 江湖故人 | Original post link

For DDL in TiDB, I am using version 7.5.

| username: Hacker_6ASfgBFe | Original post link

I’m using version 5.4, and I don’t have this. The command to check the progress has changed, and the monitoring graph still doesn’t have any data.

| username: cassblanca | Original post link

  1. Use tiup cluster display [cluster-name] to check if the Prometheus service is running normally.
  2. Check if the refresh rate in Grafana is too long.
| username: WinterLiu | Original post link

There is probably a delay in the monitoring.

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

You can use admin show ddl jobs to check the progress.

| username: 数据库真NB | Original post link

show ddl jobs, or directly query and insert into this table, and then see if there are any changes.

| username: Hacker_6ASfgBFe | Original post link

There are changes, it’s because the table is large, execution is slow, and the monitoring charts still have no data.

| username: dba远航 | Original post link

The table is too large, and the preparation time is long.

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

Hasn’t started yet, right?

| username: TiDBer_lBAxWjWQ | Original post link

It might be a false positive, let’s wait a bit longer.

| username: oceanzhang | Original post link

Monitoring delay? Or statistical data delay?