RESOURCE_GROUPS

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

USE information_schema; DESC resource_groups;
+------------+-------------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+------+---------+-------+ | NAME | varchar(32) | NO | | NULL | | | RU_PER_SEC | bigint(21) | YES | | NULL | | | BURSTABLE | varchar(3) | YES | | NULL | | +------------+-------------+------+------+---------+-------+ 3 rows in set (0.00 sec)

Examples

mysql> CREATE RESOURCE GROUP rg1 RU_PER_SEC=1000; -- Create the resource group rg1 Query OK, 0 rows affected (0.34 sec) mysql> SHOW CREATE RESOURCE GROUP rg1; -- Display the definition of the rg1 resource group +----------------+---------------------------------------------+ | Resource_Group | Create Resource Group | +----------------+---------------------------------------------+ | rg1 | CREATE RESOURCE GROUP `rg1` RU_PER_SEC=1000 | +----------------+---------------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT * FROM information_schema.resource_groups WHERE NAME = 'rg1'; +------+------------+-----------+ | NAME | RU_PER_SEC | BURSTABLE | +------+------------+-----------+ | rg1 | 1000 | NO | +------+------------+-----------+ 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.
  • BURSTABLE: whether to allow the resource group to overuse the available system resources.