Skip to content

Latest commit

 

History

History
56 lines (41 loc) · 1.62 KB

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

File metadata and controls

56 lines (41 loc) · 1.62 KB
Raw
title summary
SHOW CREATE RESOURCE GROUP
Learn the usage of SHOW CREATE RESOURCE GROUP in TiDB.

SHOW CREATE RESOURCE GROUP

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

Note:

This feature is not available on TiDB Cloud Serverless clusters.

Synopsis

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

ResourceGroupName ::=
    Identifier
|   "DEFAULT"

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