SHOW CREATE RESOURCE GROUP

SHOW CREATE RESOURCE GROUP 语句可用于查看资源组当前的定义。

语法图

ShowCreateResourceGroupStmt

ResourceGroupName

1. ShowCreateResourceGroupStmt ::=
2. "SHOW" "CREATE" "RESOURCE" "GROUP" ResourceGroupName

4. ResourceGroupName ::=
5. Identifier
6. |   "DEFAULT"

示例

查看资源组 rg1 当前的定义：

1. CREATE RESOURCE GROUP rg1 RU_PER_SEC=100;
2. Query OK, 0 rows affected (0.10 sec)

1. SHOW CREATE RESOURCE GROUP rg1;
2. ***************************[ 1. row ]***************************
3. +----------------+------------------------------------------------------------+
4. | Resource_Group | Create Resource Group                                      |
5. +----------------+------------------------------------------------------------+
6. | rg1            | CREATE RESOURCE GROUP `rg1` RU_PER_SEC=100 PRIORITY=MEDIUM |
7. +----------------+------------------------------------------------------------+
8. 1 row in set (0.01 sec)

MySQL 兼容性

该语句是 TiDB 对 MySQL 语法的扩展。

另请参阅

• TiDB RESOURCE CONTROL
• CREATE RESOURCE GROUP
• ALTER RESOURCE GROUP
• DROP RESOURCE GROUP