ALTER RESOURCE POOL

Purpose

You can use the ALTER RESOURCE POOL statement to modify the attributes of a resource pool, including the UNIT, UNIT_NUM, and ZONE_LIST attributes.

Limitations and considerations

• When you use the ALTER RESOURCE POOL statement to modify the attributes of a resource pool, you can modify only one attribute at a time. If you want to modify two or more attributes, execute the statement repeatedly.

• If you want to modify the UNIT_NUM attribute of a resource pool that has been allocated to a tenant, you must use the ALTER RESOURCE TENANT statement instead of the ALTER RESOURCE POOL statement. For more information about the ALTER RESOURCE TENANT statement, see ALTER RESOURCE TENANT.

Required privileges

You can modify the attributes of a tenant only as the root user of the sys tenant (namely root@sys).

Syntax

ALTER RESOURCE POOL

ALTER RESOURCE POOL pool_name
      UNIT [=] unit_name
    | UNIT_NUM [=] unit_num [DELETE UNIT = (unit_id_list)]
    | ZONE_LIST [=] ('zone_name' [, 'zone_name' ...]);

Parameters

Examples

• You can modify only one attribute of resource pool pool1 at a time. For example, the following statement attempts to modify the UNIT, UNIT_NUM, and ZONE_LIST attributes at a time, and an error will occur during its execution.

  obclient [oceanbase]> ALTER RESOURCE POOL pool1 UNIT='unit2', UNIT_NUM=1, ZONE_LIST=('zone1');
  ERROR 1235 (0A000): alter unit_num, resource_unit, zone_list in one cmd not supported
  

  When you decrease the value of UNIT_NUM, you can delete specified units.

  obclient [oceanbase]> ALTER RESOURCE POOL pool1 UNIT_NUM=1 DELETE UNIT = (1002);
  

• Change the unit config of the resource pool pool1 to unit2.

  obclient [oceanbase]> ALTER RESOURCE POOL pool1 UNIT='unit2';
  

References

• View resource pools

• Modify attributes of a resource pool