Sign InTry Free

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.
Download PDFRequest docs changesAsk questions on TiDB ForumEdit this page
Was this page helpful?
Open Source Ecosystem
TiDB
TiKV
TiSpark
Chaos Mesh
© 2023 PingCAP. All Rights Reserved.