ALTER-WORKLOAD-GROUP

Name

ALTER WORKLOAD GROUP

SinceVersion dev

Description

This statement is used to modify the workload group.

Syntax:

1. ALTER WORKLOAD GROUP "rg_name"
2. PROPERTIES (
3. property_list
4. );

NOTE:

  • Modify the memory_limit property in such a way that the sum of all memory_limit values does not exceed 100%;
  • Support modifying some properties, for example, if only cpu_share is modified, just fill in cpu_share in properties.

Example

  1. Modify the workload group named g1:

1. alter workload group g1 2. properties ( 3. "cpu_share"="30", 4. "memory_limit"="30%" 5. );

Keywords

1. ALTER, WORKLOAD, GROUP

Best Practice