Skip to content

Latest commit

 

History

History
59 lines (42 loc) · 1.65 KB

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

File metadata and controls

59 lines (42 loc) · 1.65 KB
Raw
title summary
SHOW CREATE RESOURCE GROUP
Learn the usage of SHOW CREATE RESOURCE GROUP in TiDB.

SHOW CREATE RESOURCE GROUP

Note:

This feature is not available on TiDB Serverless clusters.

You can use the SHOW CREATE RESOURCE GROUP statement to view the current definition of a resource group.

Synopsis

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

ResourceGroupName ::=
    Identifier

Examples

Create a resource group rg1.

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

View the definition of rg1.

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 compatibility

This statement is a TiDB extension for MySQL.

See also