Important

You are viewing the documentation of TiDB v6.0 (DMR). PingCAP does not provide bug fixes for v6.0. Any bugs will be fixed in future releases.

For general purposes, please use the latest LTS version of the TiDB database.

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).

USE information_schema;
DESC tidb_hot_regions;
+----------------+-------------+------+------+---------+-------+
| Field          | Type        | Null | Key  | Default | Extra |
+----------------+-------------+------+------+---------+-------+
| TABLE_ID       | bigint(21)  | YES  |      | NULL    |       |
| INDEX_ID       | bigint(21)  | YES  |      | NULL    |       |
| DB_NAME        | varchar(64) | YES  |      | NULL    |       |
| TABLE_NAME     | varchar(64) | YES  |      | NULL    |       |
| INDEX_NAME     | varchar(64) | YES  |      | NULL    |       |
| REGION_ID      | bigint(21)  | YES  |      | NULL    |       |
| TYPE           | varchar(64) | YES  |      | NULL    |       |
| MAX_HOT_DEGREE | bigint(21)  | YES  |      | NULL    |       |
| REGION_COUNT   | bigint(21)  | YES  |      | NULL    |       |
| FLOW_BYTES     | bigint(21)  | YES  |      | NULL    |       |
+----------------+-------------+------+------+---------+-------+
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.
Was this page helpful?