Modifying Workload Queues

You can modify the parameters of a workload queue.

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. In the Workload Queue area on the left, click the name of the queue to be modified. The following configuration areas are displayed, including Short Query Configuration, Resource Configuration, Exception Rule, and Associated User.

   

5. Modify the short query configuration. Set the parameters as required and click Save on the right.

   Parameter	Description	Value
   Short Query Acceleration	Whether to enable short query acceleration. This function is enabled by default.	Enable
   Concurrent Short Queries	A short query is a job whose estimated memory used for execution is less than 32 MB. The default value -1 indicates that the job is not controlled.	10

6. Modify the resource configuration.
   1. Click Edit on the right and modify the parameters according to Table 1.

      Table 1 Workload queue parameters

      Parameter	Description	Value
      Name	Name of a workload queue.	queue_test
      CPU Resource (%)	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

   2. Click OK.

7. Modify the exception rules.
   1. Modify the parameters according to Table 2.
      

      Exception rules allow you to control exceptions of jobs executed by users in a queue. Currently, you can configure the parameters listed in Table 2.

      • If you select Terminate, you need to set the corresponding time or percentage.
      • If you select No restriction, the corresponding execution rule does not take effect.

      Table 2 Exception rule parameters

      Parameter	Description	Value
      Blocking Time	Job blocking duration, in seconds. The duration includes the total time spent in global and local concurrent queuing. For example, if the blocking time is set to 300s, a job executed by a user in the queue will be terminated after being blocked for 300 seconds.	1200
      Execution Time	Execution duration of a job, in seconds. The time indicates the duration from the start point of execution to the current time point. For example, if Time required for execution is set to 100s, a job executed by a user in the queue will be terminated after being executed for more than 100 seconds.	2400
      Total CPU time on all DNs	Total CPU time spent in executing a job on all DNs, in seconds.	100
      Interval for Checking CPU Skew Rate	Interval for checking the CPU skew, in seconds. This parameter must be set together with Total CPU Time on All DNs.	2400
      Total CPU Time Skew Rate on All DNs	CPU time skew rate of a job executed on DNs. The value depends on the setting of Interval for Checking CPU Skew Rate.	90

   2. Click Save.

8. Associate users.
   

   • The resources used by a user to run jobs can be controlled only after the user is added to a queue.
   • A database user can be added to only one queue. Users removed from a queue can be added to another queue.
   • The administrator cannot be associated.
   1. Click Add on the right.
   2. Select the users to be added from the current user list. You can select multiple users at a time.

      

   3. Click OK.
   4. To delete a user, click Delete in the Operation column of the user.