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.

# Log on to the OceanBase database of the OceanBase cluster as the root@sys user. 
obclient -h192.168.0.1 -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;