sysbench压测报错，帮找出原因

AntTech_KVBSHP · 2024 年4 月 18 日 15:43

云深月隐 · 2024 年4 月 18 日 16:21

ob clog disk hang，检查一下是不是clog所在文件系统出问题了或者是io过大

秃蛙 · 2024 年4 月 18 日 16:41

看下磁盘的使用情况

select a.zone,concat(a.svr_ip,':',a.svr_port) observer,a.CPU_CAPACITY cpu_total, (CPU_CAPACITY-cpu_assigned) cpu_free,  round(a.memory_limit/1024/1024/1024 ) mem_total_gb,  round((memory_limit-mem_assigned)/1024/1024/1024) mem_free_gb, round(a.LOG_DISK_CAPACITY/1024/1024/1024) logdisk_total, round((a.LOG_DISK_CAPACITY-a.LOG_DISK_ASSIGNED)/1024/1024/1024) logdisk_free ,
round(a.DATA_DISK_CAPACITY/1024/1024/1024) data_total ,round((DATA_DISK_CAPACITY-a.DATA_DISK_IN_USE)/1024/1024/1024) data_free ,b.status,usec_to_time(b.start_service_time) start_service_time, usec_to_time(b.stop_time) stop_time   ,b.build_version from GV$OB_SERVERS  a join __all_server b on (a.svr_ip=b.svr_ip and a.svr_port=b.svr_port) order by a.zone, a.svr_ip;

select a.zone,a.svr_ip,b.tenant_name,b.tenant_type, 
       a.max_cpu, a.min_cpu,
       round(a.memory_size/1024/1024/1024,2) memory_size_gb, 
       round(a.log_disk_size/1024/1024/1024,2) log_disk_size,
       round(a.log_disk_in_use/1024/1024/1024,2) log_disk_in_use,
       round(a.data_disk_in_use/1024/1024/1024,2) data_disk_in_use
  from oceanbase.gv$ob_units a join oceanbase.dba_ob_tenants b on a.tenant_id=b.tenant_id 
  order by b.tenant_name;