gbase数据、南大通用产品文档：GBase8a

0 */2 * * * /opt/192.168.146.20/gnode/server/bin/gc_syncpacklog.sh /opt/192.168.

操作步骤

GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953（2022-09-15）
南大通用数据技术股份有限公司
274
步骤1：确认当前的distribution id，在当前示例中新的Distribution ID 为4，旧的
Distribution ID 为3：
$ gcadmin showdistribution vc vc1
Distribution ID: 4 | State: new | Total segment num: 3
Primary Segment Node IP
Segment ID
Duplicate Segment node IP
==========================================================================
====
|

步骤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;