obclient(root@sys)[oceanbase]> show variables like 'version_comment'; +-----------------+------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +-----------------+------------------------------------------------------------------------------------------------------------------+ | version_comment | OceanBase_CE 4.3.5.3 (r103000092025080818-e8da5f0afb288ed0add0613740c6ccf2a3c6830b) (Built Aug 8 2025 18:43:02) | +-----------------+------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.003 sec) obclient(root@sys)[oceanbase]> obclient(root@sys)[oceanbase]> show parameters where name in ('memory_limit','memory_limit_percentage','system_memory','log_disk_size','log_disk_percentage','datafile_size','datafile_disk_percentage'); +-------+----------+----------------+----------+--------------------------+-----------+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+---------+---------+-------------------+---------------+-----------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | default_value | isdefault | +-------+----------+----------------+----------+--------------------------+-----------+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+---------+---------+-------------------+---------------+-----------+ | zone1 | observer | 10.235.172.113 | 2882 | log_disk_percentage | INT | 0 | the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | | zone1 | observer | 10.235.172.113 | 2882 | log_disk_size | CAPACITY | 900G | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone1 | observer | 10.235.172.113 | 2882 | memory_limit_percentage | INT | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 80 | 1 | | zone1 | observer | 10.235.172.113 | 2882 | system_memory | CAPACITY | 20G | the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone1 | observer | 10.235.172.113 | 2882 | memory_limit | CAPACITY | 170G | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone1 | observer | 10.235.172.113 | 2882 | datafile_disk_percentage | INT | 0 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | | zone1 | observer | 10.235.172.113 | 2882 | datafile_size | CAPACITY | 200G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone6 | observer | 10.235.172.118 | 2882 | log_disk_percentage | INT | 0 | the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | | zone6 | observer | 10.235.172.118 | 2882 | log_disk_size | CAPACITY | 900G | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone6 | observer | 10.235.172.118 | 2882 | memory_limit_percentage | INT | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 80 | 1 | | zone6 | observer | 10.235.172.118 | 2882 | system_memory | CAPACITY | 20G | the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone6 | observer | 10.235.172.118 | 2882 | memory_limit | CAPACITY | 170G | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone6 | observer | 10.235.172.118 | 2882 | datafile_disk_percentage | INT | 0 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | | zone6 | observer | 10.235.172.118 | 2882 | datafile_size | CAPACITY | 200G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone5 | observer | 10.235.172.117 | 2882 | log_disk_percentage | INT | 0 | the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | | zone5 | observer | 10.235.172.117 | 2882 | log_disk_size | CAPACITY | 900G | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone5 | observer | 10.235.172.117 | 2882 | memory_limit_percentage | INT | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 80 | 1 | | zone5 | observer | 10.235.172.117 | 2882 | system_memory | CAPACITY | 20G | the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone5 | observer | 10.235.172.117 | 2882 | memory_limit | CAPACITY | 170G | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone5 | observer | 10.235.172.117 | 2882 | datafile_disk_percentage | INT | 0 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | | zone5 | observer | 10.235.172.117 | 2882 | datafile_size | CAPACITY | 200G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone3 | observer | 10.235.172.115 | 2882 | log_disk_percentage | INT | 0 | the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | | zone3 | observer | 10.235.172.115 | 2882 | log_disk_size | CAPACITY | 900G | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone3 | observer | 10.235.172.115 | 2882 | memory_limit_percentage | INT | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 80 | 1 | | zone3 | observer | 10.235.172.115 | 2882 | system_memory | CAPACITY | 20G | the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone3 | observer | 10.235.172.115 | 2882 | memory_limit | CAPACITY | 170G | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone3 | observer | 10.235.172.115 | 2882 | datafile_disk_percentage | INT | 0 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | | zone3 | observer | 10.235.172.115 | 2882 | datafile_size | CAPACITY | 200G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone4 | observer | 10.235.172.116 | 2882 | log_disk_percentage | INT | 0 | the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | | zone4 | observer | 10.235.172.116 | 2882 | log_disk_size | CAPACITY | 900G | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone4 | observer | 10.235.172.116 | 2882 | memory_limit_percentage | INT | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 80 | 1 | | zone4 | observer | 10.235.172.116 | 2882 | system_memory | CAPACITY | 20G | the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone4 | observer | 10.235.172.116 | 2882 | memory_limit | CAPACITY | 170G | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone4 | observer | 10.235.172.116 | 2882 | datafile_disk_percentage | INT | 0 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | | zone4 | observer | 10.235.172.116 | 2882 | datafile_size | CAPACITY | 200G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone2 | observer | 10.235.172.114 | 2882 | log_disk_percentage | INT | 0 | the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | | zone2 | observer | 10.235.172.114 | 2882 | log_disk_size | CAPACITY | 900G | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone2 | observer | 10.235.172.114 | 2882 | memory_limit_percentage | INT | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 80 | 1 | | zone2 | observer | 10.235.172.114 | 2882 | system_memory | CAPACITY | 20G | the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone2 | observer | 10.235.172.114 | 2882 | memory_limit | CAPACITY | 170G | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | | zone2 | observer | 10.235.172.114 | 2882 | datafile_disk_percentage | INT | 0 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | | zone2 | observer | 10.235.172.114 | 2882 | datafile_size | CAPACITY | 200G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | +-------+----------+----------------+----------+--------------------------+-----------+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+---------+---------+-------------------+---------------+-----------+ 42 rows in set (0.034 sec) obclient(root@sys)[oceanbase]> obclient(root@sys)[oceanbase]> select zone,concat(SVR_IP,':',SVR_PORT) observer, -> cpu_capacity_max cpu_total,cpu_assigned_max cpu_assigned, -> cpu_capacity-cpu_assigned_max as cpu_free, -> round(memory_limit/1024/1024/1024,2) as memory_total, -> round((memory_limit-mem_capacity)/1024/1024/1024,2) as system_memory, -> round(mem_assigned/1024/1024/1024,2) as mem_assigned, -> round((mem_capacity-mem_assigned)/1024/1024/1024,2) as memory_free, -> round(log_disk_capacity/1024/1024/1024,2) as log_disk_capacity, -> round(log_disk_assigned/1024/1024/1024,2) as log_disk_assigned, -> round((log_disk_capacity-log_disk_assigned)/1024/1024/1024,2) as log_disk_free, -> round((data_disk_capacity/1024/1024/1024),2) as data_disk, -> round((data_disk_in_use/1024/1024/1024),2) as data_disk_used, -> round((data_disk_capacity-data_disk_in_use)/1024/1024/1024,2) as data_disk_free -> from oceanbase.gv$ob_servers; +-------+---------------------+-----------+--------------+----------+--------------+---------------+--------------+-------------+-------------------+-------------------+---------------+-----------+----------------+----------------+ | zone | observer | cpu_total | cpu_assigned | cpu_free | memory_total | system_memory | mem_assigned | memory_free | log_disk_capacity | log_disk_assigned | log_disk_free | data_disk | data_disk_used | data_disk_free | +-------+---------------------+-----------+--------------+----------+--------------+---------------+--------------+-------------+-------------------+-------------------+---------------+-----------+----------------+----------------+ | zone2 | 10.235.172.114:2882 | 36 | 33 | 3 | 170.00 | 20.00 | 145.00 | 5.00 | 900.00 | 37.00 | 863.00 | 35840.00 | 103.36 | 35736.64 | | zone3 | 10.235.172.115:2882 | 36 | 33 | 3 | 170.00 | 20.00 | 145.00 | 5.00 | 900.00 | 37.00 | 863.00 | 35840.00 | 103.99 | 35736.01 | | zone4 | 10.235.172.116:2882 | 36 | 33 | 3 | 170.00 | 20.00 | 145.00 | 5.00 | 900.00 | 37.00 | 863.00 | 35840.00 | 41.27 | 35798.73 | | zone5 | 10.235.172.117:2882 | 36 | 33 | 3 | 170.00 | 20.00 | 145.00 | 5.00 | 900.00 | 37.00 | 863.00 | 35840.00 | 40.97 | 35799.03 | | zone6 | 10.235.172.118:2882 | 36 | 33 | 3 | 170.00 | 20.00 | 145.00 | 5.00 | 900.00 | 37.00 | 863.00 | 35840.00 | 41.30 | 35798.70 | | zone1 | 10.235.172.113:2882 | 36 | 33 | 3 | 170.00 | 20.00 | 145.00 | 5.00 | 900.00 | 37.00 | 863.00 | 35840.00 | 103.21 | 35736.79 | +-------+---------------------+-----------+--------------+----------+--------------+---------------+--------------+-------------+-------------------+-------------------+---------------+-----------+----------------+----------------+ 6 rows in set (0.011 sec) obclient(root@sys)[oceanbase]> obclient(root@sys)[oceanbase]> 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; +-------+----------------+-------------+-------------+---------+---------+----------------+---------------+-----------------+------------------+ | zone | svr_ip | tenant_name | tenant_type | max_cpu | min_cpu | memory_size_gb | log_disk_size | log_disk_in_use | data_disk_in_use | +-------+----------------+-------------+-------------+---------+---------+----------------+---------------+-----------------+------------------+ | zone1 | 10.235.172.113 | META$1002 | META | NULL | NULL | 2.50 | 0.75 | 0.54 | 0.20 | | zone3 | 10.235.172.115 | META$1002 | META | NULL | NULL | 2.50 | 0.75 | 0.54 | 0.24 | | zone6 | 10.235.172.118 | META$1002 | META | NULL | NULL | 2.50 | 0.75 | 0.54 | 0.24 | | zone4 | 10.235.172.116 | META$1002 | META | NULL | NULL | 2.50 | 0.75 | 0.54 | 0.24 | | zone5 | 10.235.172.117 | META$1002 | META | NULL | NULL | 2.50 | 0.75 | 0.54 | 0.21 | | zone2 | 10.235.172.114 | META$1002 | META | NULL | NULL | 2.50 | 0.75 | 0.54 | 0.24 | | zone2 | 10.235.172.114 | META$1004 | META | NULL | NULL | 10.00 | 2.00 | 1.55 | 0.15 | | zone1 | 10.235.172.113 | META$1004 | META | NULL | NULL | 10.00 | 2.00 | 1.55 | 0.15 | | zone3 | 10.235.172.115 | META$1004 | META | NULL | NULL | 10.00 | 2.00 | 1.55 | 0.15 | | zone5 | 10.235.172.117 | META$1006 | META | NULL | NULL | 10.00 | 2.00 | 1.55 | 0.13 | | zone4 | 10.235.172.116 | META$1006 | META | NULL | NULL | 10.00 | 2.00 | 1.55 | 0.14 | | zone6 | 10.235.172.118 | META$1006 | META | NULL | NULL | 10.00 | 2.00 | 1.55 | 0.14 | | zone5 | 10.235.172.117 | ocp | USER | 1 | 1 | 22.50 | 6.75 | 5.35 | 0.49 | | zone2 | 10.235.172.114 | ocp | USER | 1 | 1 | 22.50 | 6.75 | 5.35 | 0.46 | | zone4 | 10.235.172.116 | ocp | USER | 1 | 1 | 22.50 | 6.75 | 5.35 | 0.47 | | zone3 | 10.235.172.115 | ocp | USER | 1 | 1 | 22.50 | 6.75 | 5.35 | 0.47 | | zone1 | 10.235.172.113 | ocp | USER | 1 | 1 | 22.50 | 6.75 | 5.35 | 0.45 | | zone6 | 10.235.172.118 | ocp | USER | 1 | 1 | 22.50 | 6.75 | 5.35 | 0.52 | | zone5 | 10.235.172.117 | sys | SYS | 4 | 4 | 20.00 | 9.50 | 2.66 | 0.48 | | zone6 | 10.235.172.118 | sys | SYS | 4 | 4 | 20.00 | 9.50 | 2.66 | 0.48 | | zone3 | 10.235.172.115 | sys | SYS | 4 | 4 | 20.00 | 9.50 | 2.66 | 0.48 | | zone1 | 10.235.172.113 | sys | SYS | 4 | 4 | 20.00 | 9.50 | 2.66 | 0.48 | | zone4 | 10.235.172.116 | sys | SYS | 4 | 4 | 20.00 | 9.50 | 2.66 | 0.48 | | zone2 | 10.235.172.114 | sys | SYS | 4 | 4 | 20.00 | 9.50 | 2.66 | 0.48 | | zone6 | 10.235.172.118 | zctt | USER | 28 | 25 | 90.00 | 18.00 | 14.38 | 39.76 | | zone4 | 10.235.172.116 | zctt | USER | 28 | 25 | 90.00 | 18.00 | 14.38 | 39.76 | | zone5 | 10.235.172.117 | zctt | USER | 28 | 25 | 90.00 | 18.00 | 14.38 | 39.47 | | zone3 | 10.235.172.115 | zcxc | USER | 28 | 25 | 90.00 | 18.00 | 14.34 | 102.45 | | zone2 | 10.235.172.114 | zcxc | USER | 28 | 25 | 90.00 | 18.00 | 14.34 | 101.83 | | zone1 | 10.235.172.113 | zcxc | USER | 28 | 25 | 90.00 | 18.00 | 14.34 | 101.67 | +-------+----------------+-------------+-------------+---------+---------+----------------+---------------+-----------------+------------------+ 30 rows in set (0.019 sec) obclient(root@sys)[oceanbase]>