OB 运维 | 计算 OceanBase 可用 CPU 的核心逻辑

select svr_ip, zone, cpu_total, cpu_assigned, cpu_assigned_percent,
   cpu_capacity ,cpu_max_assigned ,
   (cpu_capacity-cpu_assigned) cpu_remained ,
   (cpu_total-cpu_max_assigned) cpu_max_remained
from oceanbase.__all_virtual_server_stat ;

select svr_ip, zone, cpu_capacity_max, cpu_assigned,
   cpu_assigned/cpu_capacity cpu_assigned_percent,
   cpu_capacity ,cpu_assigned_max ,
   (cpu_capacity-cpu_assigned) cpu_remained ,
   (cpu_capacity_max-cpu_assigned_max) cpu_max_remained
from oceanbase.GV$OB_SERVERS ;

-- 查看 resource_hard_limit、cpu_count、cpu_reserved
show parameters where name in ('resource_hard_limit','cpu_count','cpu_reserved') \G
-- 查看允许 OB 使用的总 CPU（cpu_total）
select svr_ip, zone, cpu_total, cpu_assigned, cpu_assigned_percent,
       cpu_capacity ,cpu_max_assigned
from oceanbase.__all_virtual_server_stat ;
-- 设置 cpu_count 为 20（低版本 cpu_count 的修改需要重启 OBServer 进程）
alter system set cpu_count=20 ;
-- 重启 OBServer （略）
-- 查看允许 OB 使用的 CPU（cpu_total）
select svr_ip, zone, cpu_total, cpu_assigned, cpu_assigned_percent,
       cpu_capacity ,cpu_max_assigned ,(cpu_capacity-cpu_assigned) cpu_remained
from oceanbase.__all_virtual_server_stat ;

-- 查看 resource_hard_limit 、cpu_count
show parameters where name in ('resource_hard_limit', 'cpu_count')  \G

-- 查看允许 OB 使用的 CPU
select svr_ip, zone, cpu_capacity_max, cpu_assigned, cpu_assigned/cpu_capacity cpu_assigned_percent,
       cpu_capacity ,cpu_assigned_max ,
       (cpu_capacity-cpu_assigned) cpu_remained ,
       (cpu_capacity_max-cpu_assigned_max) cpu_max_remained
    from oceanbase.GV$OB_SERVERS ;
-- 设置 cpu_count 为 20
alter system set cpu_count=20 ;
-- 查看允许使用的 CPU
select svr_ip, zone, cpu_capacity_max, cpu_assigned, cpu_assigned/cpu_capacity cpu_assigned_percent,
       cpu_capacity ,cpu_assigned_max ,
       (cpu_capacity-cpu_assigned) cpu_remained ,
       (cpu_capacity_max-cpu_assigned_max) cpu_max_remained
    from oceanbase.GV$OB_SERVERS ;

-- 配置设置
alter system set __min_full_resource_pool_memory=1073741824 ;
show parameters where name in ('resource_hard_limit','cpu_count','cpu_reserved') \G
alter system set resource_hard_limit=120 ;
alter system set cpu_count=40 ;
alter system set cpu_reserved=2 ;
show parameters where name in ('resource_hard_limit','cpu_count','cpu_reserved') \G
-- 重启 OB 集群（略）
-- 查看当前的 CPU 限额
select svr_ip, zone, cpu_total, cpu_assigned, cpu_assigned_percent,
    cpu_capacity ,cpu_max_assigned ,
    (cpu_capacity-cpu_assigned) cpu_remained ,
    (cpu_total-cpu_max_assigned) cpu_max_remained
from oceanbase.__all_virtual_server_stat ;

-- 设置一个 min_cpu 为 27.5，max_cpu 为 32.6 的租户（内存配置为 1G）：
   -- 创建 resource unit
      create resource unit mini min_cpu=27.5, max_cpu=32.6, max_memory='1G',min_memory='1G',max_iops=10000,min_iops=1000,max_session_num=1000000,max_disk_size='10G';
   -- 查看 zone 名称（假设只有一个 zone: META_ZONE_1）
      select distinct zone  from oceanbase.__all_zone ;
   -- 创建 resource pool，创建 resource pool 时会校验主机资源规格是否充足
      create resource pool mini_pool_1 unit=mini ,unit_num=1 ,zone_list=('META_ZONE_1');
   -- 创建 tenant
      create tenant t1 charset='utf8mb4',primary_zone='META_ZONE_1',resource_pool_list=('mini_pool_1') set ob_tcp_invited_nodes='%';
   -- 调整 resource unit 的资源规格
      alter resource unit mini  min_cpu=27.6 ;  -- 报错
      alter resource unit mini  max_cpu=32.7 ;  -- 报错
   -- 清理
      drop tenant if exists t1 force ;
      drop resource pool if exists mini_pool_1 ;
      drop resource unit if exists mini ;

-- 配置设置
   alter system set __min_full_resource_pool_memory=1073741824 ;
   show parameters where name in ('resource_hard_limit','cpu_count') \G
   alter system set resource_hard_limit=120 ;
   alter system set cpu_count=40 ;
   show parameters where name in ('resource_hard_limit','cpu_count') \G
-- 查看当前的 CPU 限额
   select svr_ip, zone, cpu_capacity_max, cpu_assigned,
       cpu_assigned/cpu_capacity cpu_assigned_percent,
       cpu_capacity ,cpu_assigned_max ,
       (cpu_capacity-cpu_assigned) cpu_remained ,
       (cpu_capacity_max-cpu_assigned_max) cpu_max_remained
    from oceanbase.GV$OB_SERVERS ;  -- cpu_capacity_max 等于 cpu_count(配置)

-- 设置一个 min_cpu 为 33，max_cpu 为 41 的租户：
   -- 创建 resource unit
      create resource unit mini max_cpu=41,min_cpu=33,memory_size='1G',log_disk_size='2G' ;
   -- 查看 zone 名称（假设只有一个 zone: zone1）
      select distinct zone  from oceanbase.__all_zone ;
   -- 创建 resource pool，创建 resource pool 时会校验主机资源规格是否充足
      create resource pool mini_pool_1 unit=mini ,unit_num=1 ,zone_list=('zone1');
   -- 创建 tenant
      create tenant t1 charset='utf8mb4',primary_zone='zone1',       resource_pool_list=('mini_pool_1') set ob_tcp_invited_nodes='%';
   -- 调整 resource unit 的资源规格
      alter resource unit mini  min_cpu=33.1 ;  -- 报错
      alter resource unit mini  max_cpu=41.1 ;  -- 报错
   -- 清理
      drop tenant if exists t1 force ;
      drop resource pool if exists mini_pool_1 ;
      drop resource unit if exists mini ;