SHOW CREATE RESOURCE GROUP

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

SHOW CREATE RESOURCE GROUP - 图1

Note

This feature is not available on TiDB Serverless clusters.

Synopsis

ShowCreateResourceGroupStmt

SHOW CREATE RESOURCE GROUP - 图2

ResourceGroupName

SHOW CREATE RESOURCE GROUP - 图3

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

Examples

Create a resource group rg1.

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

View the definition of rg1.

  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 compatibility

This statement is a TiDB extension for MySQL.

See also