SHOW CREATE RESOURCE GROUP

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

语法图

ShowCreateResourceGroupStmt
SHOWCREATERESOURCEGROUPResourceGroupName
ResourceGroupName
IdentifierDEFAULT

示例

查看资源组 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 语法的扩展。

另请参阅

文档内容是否有帮助?