There is always a non-existent table in traffic visualization

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

Original topic: 流量可视化一直有一个不存在的表

| username: TiDBer_0h6Z73nx

[TiDB Usage Environment] Production Environment
[TiDB Version] 5.4.0
[Reproduction Path] Recently, TiDB has been experiencing high latency. Upon checking traffic visualization, it was found that a table had a read volume of around 20G per minute. Due to business reasons, this table was backed up and deleted, but the read volume did not decrease. In the traffic visualization, the table name changed to table_3906.
[Encountered Problem: Phenomenon and Impact]
[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]

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

SHOW ANALYZE STATUS; Check if this table exists, it might still be collecting statistics.

| username: TiDBer_0h6Z73nx | Original post link

Just checked, there’s nothing.

| username: Jiawei | Original post link

Is it because the GC time is too long that the data hasn’t been truly deleted?

| username: TiDBer_0h6Z73nx | Original post link

The default configuration should be once every 10 minutes?

| username: TiDBer_0h6Z73nx | Original post link

Has no one encountered this situation?

| username: wzf0072 | Original post link

Can this table find the associated database?
select * from INFORMATION_SCHEMA.tables where table_name=‘table_3906’

| username: TiDBer_0h6Z73nx | Original post link

No, I can’t find it.

| username: 小王同学Plus | Original post link

Hello, you can use the API to grep this table to see if there are any create and delete operations.
curl http://{TiDBIP}:10080/ddl/history

| username: TiDBer_0h6Z73nx | Original post link

The problem is solved. I checked the region where the key is located and then checked the table contained in this region. I found that a business table had appeared in the slow query and did not have an index. After adding an index to this table, the phenomenon disappeared, and the TiDB latency returned to normal. Is this a bug?

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.