Help Center/ GaussDB(DWS)/ More Documents/ User Guide (Kuala Lumpur Region)/ Clusters/ Managing Cluster Workloads/ Workload Management Overview
Updated on 2022-08-16 GMT+08:00
View PDF
Share

Workload Management Overview

Overview

When multiple database users query jobs at the same time, some complex queries may occupy cluster resources for a long time, affecting the performance of other queries. For example, a group of database users continuously submit complex and time-consuming queries, while another group of users frequently submit short queries. In this case, short queries may have to wait in the queue for the time-consuming queries to complete.

To improve efficiency, you can use the GaussDB(DWS) workload management function to handle such problems. GaussDB(DWS) workload management uses workload queues as resource bearers. You can create different workload queues for different service types and configure different resource ratios for these queues. Then, add database users to the corresponding queues to restrict their resource usages. For example, classify database users who frequently submit complex query jobs into one type, create a workload queue for these users, allocate more resources to the queue, and then add these users to the queue. In this case, the complex jobs submitted by these users can use only the resources of the created queue. Also, create a queue that occupies fewer resources and allocate it to users who submit short queries. In this way, the two types of jobs can be executed at the same time without affecting each other.

  • If a resource pool has been created on the backend in the database of the earlier version, delete it and create a new one on the frontend. For details, contact technical support.
  • This feature is supported only in 8.0 or later.

Page Overview

On the Workload Management page, you can modify the global configurations of workload management, add, create, and modify workload queues, add database users to queues, and remove database users from queues.

Short Query Configuration

In the Short Query Configuration area, you can enable or disable the short query acceleration function. To change the number of concurrent short queries (-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, including the CPU resource (%), memory resource (%), storage resource (MB), and query concurrency.

Exception Rule

In the Exception Rule area, you can view the exception rule settings of the current workload queue. Exception rules allow you to control exceptions of jobs executed by associated users in the queue.

Associated User

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

Entering Workload Management Page

  1. Log in to the GaussDB(DWS) management console.
  2. On the displayed Clusters page, click the name of the target cluster.
  3. Switch to the Workload Management tab page.

Enabling/Disabling Workload Management

The Workload Management Configuration area includes the Workload Switch and Maximum Concurrency parameters. Maximum Concurrency refers to the maximum concurrent queries on a single CN. If you disable Workload Switch, all workload management functions will be unavailable.