步骤1 创建资源消费组并关联用户
create consumer group group_process
comment = 'users for process’;
create consumer group group_select
comment = 'users for select';
alter consumer group group_process
add user usera;
alter consumer group group_process
add user userb;
alter consumer group group_select
add user userc;
alter consumer group group_select
add user userd;
alter consumer group group_select
add user usere;
步骤2 创建资源池
1.
静态资源池
create resource pool static_pool0(
cpu_percent=100,
max_memory=10000,
max_temp_diskspace=10000,
max_disk_space=10000,
GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953（2022-09-15）
南大通用数据技术股份有限公司
510
max_disk_writeio=1000,
max_disk_readio=1000) type static;
2.
动态资源池
create resource pool pool_select(
priority=1,
cpu_percent=80,
max_memory=6000,
max_temp_diskspace=5000,
max_disk_space=5000,
max_disk_writeio=600,
max_disk_readio=600,
max_activetask=200,
task_max_parallel_degree=100,
task_waiting_timeout=100000,
task_running_timeout=100000)
type dynamic base on static_pool0;
create resource pool pool_process(
priority=1,
cpu_percent=20,
max_memory=4000,
max_temp_diskspace=5000,
max_disk_space=5000,
max_disk_writeio=400,
max_disk_readio=400,
max_activetask=200,
task_max_parallel_degree=100,
task_waiting_timeout=100000,
task_running_timeout=100000)
type dynamic base on static_pool0;
步骤3 创建资源计划
create resource plan
resource_plan
comment = 'resource plan';
步骤4 创建资源指令计划
GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953（2022-09-15）
南大通用数据技术股份有限公司
511
create resource directive directive1
(plan_name = 'resource_plan' ,
pool_name = 'pool_select',
group_name = 'group_select',
comment = 'select user resource usage ');
create resource directive directive2
(plan_name = 'resource_plan',
pool_name = 'pool_process',
group_name = 'group_process',
comment = 'process user resource usage ');
create resource directive directive3
(plan_name = 'resource_plan',
pool_name = ' pool_process ',
group_name = 'default_consumer_group',
comment = 'other user resource usage ');
步骤5 激活计划
active resource plan resource_plan on vc vc1;