TABLE_STORAGE_STATS

The TABLE_STORAGE_STATS table provides information about table sizes as stored by the storage engine (TiKV).

  1. USE INFORMATION_SCHEMA;
  2. DESC TABLE_STORAGE_STATS;

The output is as follows:

  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

The output is as follows:

  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)

Fields in the TABLE_STORAGE_STATS table are described as follows:

  • TABLE_SCHEMA: The name of the schema to which the table belongs.
  • TABLE_NAME: The name of the table.
  • TABLE_ID: The ID of the table.
  • PEER_COUNT: The number of replicas of the table.
  • REGION_COUNT: The number of Regions.
  • EMPTY_REGION_COUNT: The number of Regions that do not contain data in this table.
  • TABLE_SIZE: The total size of the table, in the unit of MiB.
  • TABLE_KEYS: The total number of records in the table.