Page Overview

Overview

On the resource management page, you can modify global resource management configurations; add, create, and modify resource queues; add database users to a resource pool; and remove a database user from a resource pool. After a cluster is converted into a logical cluster, you can create, modify, or delete a resource pool in the logical cluster.

The page consists of the following modules:

• Enabling or Disabling Resource Management
• Short Query Configuration
• Resource Configuration
• Associated Exception Rules
• User Association

Enabling or Disabling Resource Management

You can enable or disable resource management, and configure the maximum global concurrency. Max. Concurrent Queries refers to the maximum concurrent queries on a single CN. If you disable Resource Management, all resource management functions will be unavailable.

Short Query Configuration

In the Short Query Configuration area, you can enable or disable the short query acceleration function. To change the number of simple statements (-1 by default. 0 or -1 indicates that the concurrent short queries are not controlled), you can enable short query acceleration.

Resource Configuration

In the Resource Configuration area, you can view the resource configuration of the current workload queue. For example:

Only clusters of the version 8.2.1 and later support the network bandwidth weight.

Associated Exception Rules

In the Associated Exception Rules area, you can view the exception rules associated to the current resource pool, associate new exception rules, and disassociate exception rules. For more information, see Exception parameters.

Only clusters of 8.2.0 and later versions support associating exception rules. GaussDB(DWS) 3.0 does not support this function. For cluster versions earlier than 8.2.0, see 7.c.

User Association

In the Associated User list, you can view the associated users of the current resource pool, and the memory and disk usage of each user at the current time, as shown in the following figure.

If no resource pools are associated with a user, the user will be associated with default_pool by default, and its resource usage will be restricted by default_pool. The default_pool will be automatically created after resource management is enabled.