RESOURCE_GROUPS

The RESOURCE_GROUPS table shows the information about all resource groups. For more information, see Use Resource Control to Achieve Resource Isolation.

RESOURCE_GROUPS - 图1

Note

This table is not available on TiDB Serverless clusters.

  1. USE information_schema;
  2. DESC resource_groups;
  1. +------------+-------------+------+------+---------+-------+
  2. | Field      | Type        | Null | Key  | Default | Extra |
  3. +------------+-------------+------+------+---------+-------+
  4. | NAME       | varchar(32) | NO   |      | NULL    |       |
  5. | RU_PER_SEC | bigint(21)  | YES  |      | NULL    |       |
  6. | PRIORITY   | varchar(6)  | YES  |      | NULL    |       |
  7. | BURSTABLE  | varchar(3)  | YES  |      | NULL    |       |
  8. +------------+-------------+------+------+---------+-------+
  9. 3 rows in set (0.00 sec)

Examples

  1. SELECT * FROM information_schema.resource_groups; -- View all resource groups. TiDB has a `default` resource group.
  1. +---------+------------+----------+-----------+
  2. | NAME    | RU_PER_SEC | PRIORITY | BURSTABLE |
  3. +---------+------------+----------+-----------+
  4. | default | UNLIMITED  | MEDIUM   | YES       |
  5. +---------+------------+----------+-----------+
  1. CREATE RESOURCE GROUP rg1 RU_PER_SEC=1000; -- Create a resource group `rg1`
  1. Query OK, 0 rows affected (0.34 sec)
  1. SHOW CREATE RESOURCE GROUP rg1; -- Show the definition of the `rg1` resource group
  1. +----------------+---------------------------------------------------------------+
  2. | Resource_Group | Create Resource Group                                         |
  3. +----------------+---------------------------------------------------------------+
  4. | rg1            | CREATE RESOURCE GROUP `rg1` RU_PER_SEC=1000 PRIORITY="MEDIUM" |
  5. +----------------+---------------------------------------------------------------+
  6. 1 row in set (0.00 sec)
  1. SELECT * FROM information_schema.resource_groups WHERE NAME = 'rg1'; -- View the resource groups `rg1`
  1. +------+------------+----------+-----------+-------------+
  2. | NAME | RU_PER_SEC | PRIORITY | BURSTABLE | QUERY_LIMIT |
  3. +------+------------+----------+-----------+-------------+
  4. | rg1  | 1000       | MEDIUM   | NO        | NULL        |
  5. +------+------------+----------+-----------+-------------+
  6. 1 row in set (0.00 sec)

The descriptions of the columns in the RESOURCE_GROUPS table are as follows:

  • NAME: the name of the resource group.
  • RU_PER_SEC: the backfilling speed of the resource group. The unit is RU/second, in which RU means Request Unit.
  • PRIORITY: the absolute priority of tasks to be processed on TiKV. Different resources are scheduled according to the PRIORITY setting. Tasks with high PRIORITY are scheduled first. For resource groups with the same PRIORITY, tasks will be scheduled proportionally according to the RU_PER_SEC configuration. If PRIORITY is not specified, the default priority is MEDIUM.
  • BURSTABLE: whether to allow the resource group to overuse the available system resources.

RESOURCE_GROUPS - 图2

Note

TiDB automatically creates a default resource group during cluster initialization. For this resource group, the default value of RU_PER_SEC is UNLIMITED (equivalent to the maximum value of the INT type, that is, 2147483647) and it is in BURSTABLE mode. All requests that are not bound to any resource group are automatically bound to this default resource group. When you create a new configuration for another resource group, it is recommended to modify the default resource group configuration as needed.