TABLE_STORAGE_STATS

TABLE_STORAGE_STATS 表提供有关由存储引擎 (TiKV) 存储的表大小的信息。

1. USE information_schema;
2. DESC table_storage_stats;

1. +--------------------+-------------+------+------+---------+-------+
2. | Field              | Type        | Null | Key  | Default | Extra |
3. +--------------------+-------------+------+------+---------+-------+
4. | TABLE_SCHEMA       | varchar(64) | YES  |      | NULL    |       |
5. | TABLE_NAME         | varchar(64) | YES  |      | NULL    |       |
6. | TABLE_ID           | bigint(21)  | YES  |      | NULL    |       |
7. | PEER_COUNT         | bigint(21)  | YES  |      | NULL    |       |
8. | REGION_COUNT       | bigint(21)  | YES  |      | NULL    |       |
9. | EMPTY_REGION_COUNT | bigint(21)  | YES  |      | NULL    |       |
10. | TABLE_SIZE         | bigint(64)  | YES  |      | NULL    |       |
11. | TABLE_KEYS         | bigint(64)  | YES  |      | NULL    |       |
12. +--------------------+-------------+------+------+---------+-------+
13. 8 rows in set (0.00 sec)

1. CREATE TABLE test.t1 (id INT);
2. INSERT INTO test.t1 VALUES (1);
3. SELECT * FROM table_storage_stats WHERE table_schema = 'test' AND table_name = 't1'\G

1. *************************** 1. row ***************************
2. TABLE_SCHEMA: test
3. TABLE_NAME: t1
4. TABLE_ID: 56
5. PEER_COUNT: 1
6. REGION_COUNT: 1
7. EMPTY_REGION_COUNT: 1
8. TABLE_SIZE: 1
9. TABLE_KEYS: 0
10. 1 row in set (0.00 sec)