步骤1 创建资源消费组并关联用户
create consumer group group_process
comment = 'users for process';
create consumer group group_select
comment = 'users for select';
create consumer group group_check
comment = 'users for check';
alter consumer group group_check
add user usercheck;
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 创建资源池
create resource pool static_pool0(
cpu_percent=100,
max_memory=10000,
max_temp_diskspace= 10000,
max_disk_space= 10000,
max_disk_writeio=1000,
max_disk_readio=1000) TYPE static;
create resource pool pool_check(
priority=1,
cpu_percent=99,
max_memory=4000,
max_temp_diskspace=50000,
max_disk_space=50000,
max_disk_writeio=600,
max_disk_readio=600,
max_activetask=200,
task_max_parallel_degree=100,
task_waiting_timeout=100000,
GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953（2022-09-15）
南大通用数据技术股份有限公司
513
task_running_timeout=100000)
type dynamic base on static_pool0;
create resource pool pool_select(
priority=3,
cpu_percent=70,
max_memory=4000,
max_temp_diskspace=5000,
max_disk_space=5000,
max_disk_writeio=200,
max_disk_readio=200,
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=3,
cpu_percent=30,
max_memory=2000,
max_temp_diskspace=5000,
max_disk_space=5000,
max_disk_writeio=200,
max_disk_readio=200,
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 创建资源指令计划
create resource directive directive1
GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953（2022-09-15）
南大通用数据技术股份有限公司
514
(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_check',
group_name = 'group_check',
comment ='check user resource usage ');
create resource directive directive4
(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;