sql-statement-show-create-resource-group.md

title	summary
SHOW CREATE RESOURCE GROUP	TiDB 数据库中 SHOW CREATE RESOURCE GROUP 的使用概况。

SHOW CREATE RESOURCE GROUP

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

语法图

ShowCreateResourceGroupStmt ::=
    "SHOW" "CREATE" "RESOURCE" "GROUP" ResourceGroupName

ResourceGroupName ::=
    Identifier
|   "DEFAULT"

示例

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

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

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

MySQL 兼容性

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

另请参阅

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