Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: tidb中统计表的大小，数据大小，索引大小，全为0
[TiDB Usage Environment] Production Environment
[TiDB Version] V5.3.3
[Reproduction Path] What operations were performed when the problem occurred
[Encountered Problem: Problem Phenomenon and Impact]
Using the command line to count the number of rows in the table, data size, and index size, all statistics are 0
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Log/Monitoring]
Collected already, it’s the same.
Are all the tables like this?
Delete the table statistics that are zero, and then collect them again to see.
Did you get any results from querying all the table information?
There is a part that is all zeros.
The image you provided is not visible. Please provide the text you need translated.
Let’s check if there really is no data. Normally, the number of rows shouldn’t be 0.
Yes, if you go directly to count, there are values.
It is also possible that your table data volume is too small, and when counted in bytes, it is ignored as 0.
No, some tables have over 100 million records when counted, and the table size is several tens of gigabytes.
Try restarting the TiDB server, one by one.
It feels like a bug, I think I saw it somewhere before.
Collect statistics or try restarting.
I think you can delete the statistics and then try collecting them again. 
DROP STATS TableName;
ANALYZE TABLE TableName
The analysis cannot be completed, and the connection times out as soon as the analysis starts.
mysql> analyze table oms_online.orders;
ERROR 2013 (HY000): Lost connection to MySQL server during query
The storage structure of TiDB is different from MySQL. Are you using MySQL statements?
The sentence is the same as analyze.
|
username: TiDBer_OB4kHrS7
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: