obclient [oceanbase]> show parameters LIKE '%log_disk_size%' \G; *************************** 1. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: log_disk_size data_type: CAPACITY value: 14336M info: the size of disk space used by the log files. Range: [0, +∞) section: LOGSERVICE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0M isdefault: 0 *************************** 2. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: syslog_disk_size data_type: CAPACITY value: 0M info: the size of disk space used by the syslog files. Range: [0, +∞) section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0M isdefault: 1 2 rows in set (0.004 sec) ERROR: No query specified obclient [oceanbase]> show parameters like '%datafile%' \G; *************************** 1. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: datafile_disk_percentage data_type: INT value: 0 info: the percentage of disk space used by the data files. Range: [0,99] in integer section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0 isdefault: 1 *************************** 2. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: datafile_maxsize data_type: CAPACITY value: 8192M info: the auto extend max size. Range: [0, +∞) section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0 isdefault: 0 *************************** 3. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: datafile_next data_type: CAPACITY value: 2048M info: the auto extend step. Range: [0, +∞) section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0 isdefault: 0 *************************** 4. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: datafile_size data_type: CAPACITY value: 2048M info: size of the data file. Range: [0, +∞) section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0M isdefault: 0 4 rows in set (0.004 sec) ERROR: No query specified obclient [oceanbase]> show parameters LIKE '%memory%' \G; *************************** 1. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: __min_full_resource_pool_memory data_type: INT value: 1073741824 info: the min memory value which is specified for a full resource pool. section: LOAD_BALANCE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 5368709120 isdefault: 0 *************************** 2. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: memory_chunk_cache_size data_type: CAPACITY value: 0M info: the maximum size of memory cached by memory chunk cache. Range: [0M,], 0 stands for adaptive section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0M isdefault: 1 *************************** 3. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: memory_limit_percentage data_type: INT value: 80 info: the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 80 isdefault: 1 *************************** 4. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: system_memory data_type: CAPACITY value: 5000M info: 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,) section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0M isdefault: 0 *************************** 5. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: memory_limit data_type: CAPACITY value: 10240M info: the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0M isdefault: 0 *************************** 6. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: memory_reserved data_type: CAPACITY value: 500M info: the size of the system memory reserved for emergency internal use. Range: [10M, total size of memory] section: SSTABLE scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 500M isdefault: 1 *************************** 7. row *************************** zone: zone1 svr_type: observer svr_ip: 127.0.0.1 svr_port: 2882 name: rpc_memory_limit_percentage data_type: INT value: 0 info: maximum memory for rpc in a tenant, as a percentage of total tenant memory, and 0 means no limit to rpc memory section: RPC scope: TENANT source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0 isdefault: 1 7 rows in set (0.004 sec) ERROR: No query specified obclient [oceanbase]> select a.zone, a.SVR_IP,a.SVR_PORT, b.status,cpu_capacity,cpu_assigned_max,cpu_capacity-cpu_assigned_max as cpu_free,round(memory_limit /1024/1024/1024 ,2) as memory_total_gb,round((memory_limit-mem_capacity) /1024/1024/1024 ,2) as system_memory_gb,round(mem_assigned /1024/1024/1024 ,2) as mem_assigned_gb,round((mem_capacity-mem_assigned) /1024/1024/1024 ,2) as memory_free_gb,round(log_disk_capacity /1024/1024/1024 ,2) as log_disk_capacity_gb,round(log_disk_assigned /1024/1024/1024 ,2) as log_disk_assigned_gb,round((log_disk_capacity-log_disk_assigned) /1024/1024/1024 ,2) as log_disk_free_gb,round((data_disk_capacity /1024/1024/1024 ),2) as data_disk_gb,round((data_disk_in_use /1024/1024/1024 ),2) as data_disk_used_gb,round((data_disk_capacity-data_disk_in_use) /1024/1024/1024 ,2) as data_disk_free_gb from gv$ob_servers a join oceanbase.DBA_OB_SERVERS b on a.zone=b.zone\G; *************************** 1. row *************************** zone: zone1 SVR_IP: 127.0.0.1 SVR_PORT: 2882 status: ACTIVE cpu_capacity: 16 cpu_assigned_max: 4 cpu_free: 12 memory_total_gb: 10.00 system_memory_gb: 4.88 mem_assigned_gb: 4.00 memory_free_gb: 1.12 log_disk_capacity_gb: 14.00 log_disk_assigned_gb: 2.00 log_disk_free_gb: 12.00 data_disk_gb: 8.00 data_disk_used_gb: 0.48 data_disk_free_gb: 7.52 1 row in set (0.001 sec) ERROR: No query specified