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

Adding Workload Queues

  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.
  4. Click the plus sign (+) next to Workload Queue.

    You can create a maximum of 63 workload queues.

  5. Enter the name and configure related resources for a new workload queue by referring to Table 1.

    Table 1 Configuring workload queue parameters

    Parameter

    Description

    Value

    Name

    Name of a workload queue.

    queue_test

    CPU Usage (%)

    Percentage of the CPU time slice that can be used by database users in a queue for job execution.

    20

    Memory Resource (%)

    Percentage of the memory usage by a queue.

    CAUTION:

    You can manage memory and query concurrency separately or jointly. Under joint management, jobs can be delivered only when both the memory and concurrency conditions are met.

    20

    Storage Resource (MB)

    Size of the available space for permanent tables.

    CAUTION:

    This parameter indicates the total tablespace of all DNs in a queue. Available space of a single DN = Configured value/Number of DNs.

    1024

    Query Concurrency

    Maximum number of concurrent queries in a queue.

    CAUTION:

    You can manage memory and query concurrency separately or jointly. Under joint management, jobs can be delivered only when both the memory and concurrency conditions are met.

    10

  6. Confirm the information and click OK.