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.