FAQ about resource usage

This topic describes FAQ about global resource usage.

Resource usage

Q1: How do I view the disk capacity and usage of an OceanBase cluster?

A: In the __all_virtual_disk_stat table, the sum of values of the total_size field is the total disk capacity of the cluster, and the sum of values of the used_size field is the used disk space of the cluster. You can query the values of the total_size and used_size fields by using the following method.

• Versions below V4.0.0:

  # Log on to the OceanBase database of the OceanBase cluster as the root@sys user.
  obclient -hxxx.xxx.xxx.xxx -P2881 -u<username> -p_******_ -Doceanbase -A
  # Query the disk capacity (total_size) and usage (used_size) of each OBServer in the OceanBase cluster.
  select total_size,used_size,svr_ip from __all_virtual_disk_stat;
  

• OceanBase V4.0.0 and above:

  # Log on to the OceanBase database of the OceanBase cluster as the root@sys user.
  obclient -hxxx.xxx.xxx.xxx -P2881 -u<username> -p_******_ -Doceanbase -A
  # Query the disk capacity (total_size) and usage (used_size) of each OBServer in the OceanBase cluster.
  select data_disk_capacity as disk_total, LOG_DISK_IN_USE+DATA_DISK_IN_USE as used_size, svr_ip from GV$OB_SERVERS;