Important

You are viewing the documentation of an older version of the TiDB database (TiDB v5.3).

It is recommended that you use the latest LTS version of the TiDB database.

TIDB_HOT_REGIONS

The TIDB_HOT_REGIONS table provides information about hotspot Regions.

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: ID of located.
  • INDEX_ID: ID of the table in which the hot Region is 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: 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 Regions in the instance.
  • FLOW_BYTES: The number of bytes written and read in the Region.
Was this page helpful?