TIDB_HOT_REGIONS

The TIDB_HOT_REGIONS table provides information about the current hot Regions. For information about history hot Regions, see [TIDB_HOT_REGIONS_HISTORY](/information-schema/information-schema-tidb-hot-regions-history.md).

TIDB_HOT_REGIONS - 图1

Note

This table is only applicable to TiDB Self-Hosted and not available on TiDB Cloud.

  1. USE information_schema;
  2. DESC tidb_hot_regions;
  1. +----------------+-------------+------+------+---------+-------+
  2. | Field          | Type        | Null | Key  | Default | Extra |
  3. +----------------+-------------+------+------+---------+-------+
  4. | TABLE_ID       | bigint(21)  | YES  |      | NULL    |       |
  5. | INDEX_ID       | bigint(21)  | YES  |      | NULL    |       |
  6. | DB_NAME        | varchar(64) | YES  |      | NULL    |       |
  7. | TABLE_NAME     | varchar(64) | YES  |      | NULL    |       |
  8. | INDEX_NAME     | varchar(64) | YES  |      | NULL    |       |
  9. | REGION_ID      | bigint(21)  | YES  |      | NULL    |       |
  10. | TYPE           | varchar(64) | YES  |      | NULL    |       |
  11. | MAX_HOT_DEGREE | bigint(21)  | YES  |      | NULL    |       |
  12. | REGION_COUNT   | bigint(21)  | YES  |      | NULL    |       |
  13. | FLOW_BYTES     | bigint(21)  | YES  |      | NULL    |       |
  14. +----------------+-------------+------+------+---------+-------+
  15. 10 rows in set (0.00 sec)

The description of columns in the TIDB_HOT_REGIONS table is as follows:

  • TABLE_ID: The ID of the table in which the hot Region is located.
  • INDEX_ID: The ID of the index in which the hot Region is located.
  • DB_NAME: The database name of the object in which the hot Region is located.
  • TABLE_NAME: The name of the table in which the hot Region is located.
  • INDEX_NAME: The name of the index in which the hot Region is located.
  • REGION_ID: The ID of the hot Region.
  • TYPE: The type of the hot Region.
  • MAX_HOT_DEGREE: The maximum hot degree of the Region.
  • REGION_COUNT: The number of hot Regions in the instance.
  • FLOW_BYTES: The number of bytes written and read in the Region.