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

• You can use the ALTER RESOURCE POOL statement to modify only one attribute of a resource pool at a time. To modify two or all of the UNIT, UNIT_NUM, and ZONE_LIST attributes, execute the statement repeatedly.

• 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

Only the root user of the sys tenant (namely the root@sys user) can execute this statement.

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 specify the resource units to be deleted.

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

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

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

References

• View resource pools

• Modify attributes of a resource pool