TiDBTiDB Docs Dash 2024

Jan 9 - Jan 12 (UTC)
Join us to improve docs and win a prize!
Sign InTry Free

SHOW CREATE RESOURCE GROUP

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

Synopsis

ShowCreateResourceGroupStmt
SHOWCREATERESOURCEGROUPResourceGroupName
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

Was this page helpful?

Download PDFRequest docs changesAsk questions on Discord
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.