After restoring data from the old TiDB to the new TiDB, information_schema.tables cannot find the data

Translated
1

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

Original topic: 从老的tidb 还原数据到新的tidb后information_schema.tables查不到数据

| 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】Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
【Attachments: Screenshots / Logs / Monitoring】

select table_schema, table_name, table_rows, truncate(data_length/1024/1024/1024, 2) as ‘table_MB’, truncate(index_length/1024/1024/1024, 2) as ‘index_MB’ from information_schema.tables order by data_length desc, index_length desc limit 50;

2
| username: 像风一样的男子 | Original post link

Did you not perform analyze?

3
| username: TiDB_C罗 | Original post link

show databases;
show tables;
How do they compare?

4
| username: zhaokede | Original post link

Manually analyze it.

5
| username: Kongdom | Original post link

:thinking: Could it be a bug? Are you restoring to the same version?