Skip to main content
Skip to main content

ALTER-WORKLOAD-GROUP

ALTER-WORKLOAD-GROUP​

Name​

ALTER WORKLOAD GROUP

Description​

This statement is used to modify the workload group.

Syntax:

ALTER WORKLOAD GROUP "rg_name"
PROPERTIES (
property_list
);

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:

    alter workload group g1
    properties (
    "cpu_share"="30",
    "memory_limit"="30%"
    );

Keywords​

ALTER, WORKLOAD, GROUP

Best Practice​