OceanBase 数据库支持通过视图查看租户的资源分配情况。
通过视图查看资源的分配情况
-
使用
root用户登录数据库的sys租户。 -
进入
oceanbase数据库。obclient>USE oceanbase;
-
执行以下命令，查看集群内各 Server 的资源分配情况。
obclient> SELECT * FROM oceanbase.GV$OB_SERVERS\G *************************** 1. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 ZONE: zone1 SQL_PORT: 2881 CPU_CAPACITY: 62 CPU_CAPACITY_MAX: 62 CPU_ASSIGNED: 4.5 CPU_ASSIGNED_MAX: 4.5 MEM_CAPACITY: 75161927680 MEM_ASSIGNED: 30064771072 LOG_DISK_CAPACITY: 179583320064 LOG_DISK_ASSIGNED: 55834574848 LOG_DISK_IN_USE: 9395240960 DATA_DISK_CAPACITY: 107374182400 DATA_DISK_IN_USE: 4724883456 DATA_DISK_HEALTH_STATUS: NORMAL DATA_DISK_ABNORMAL_TIME: NULL *************************** 2. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 ZONE: zone2 SQL_PORT: 2881 CPU_CAPACITY: 62 CPU_CAPACITY_MAX: 62 CPU_ASSIGNED: 4.5 CPU_ASSIGNED_MAX: 4.5 MEM_CAPACITY: 75161927680 MEM_ASSIGNED: 30064771072 LOG_DISK_CAPACITY: 179583320064 LOG_DISK_ASSIGNED: 55834574848 LOG_DISK_IN_USE: 9395240960 DATA_DISK_CAPACITY: 107374182400 DATA_DISK_IN_USE: 4724883456 DATA_DISK_HEALTH_STATUS: NORMAL DATA_DISK_ABNORMAL_TIME: NULL *************************** 3. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 ZONE: zone3 SQL_PORT: 2881 CPU_CAPACITY: 62 CPU_CAPACITY_MAX: 62 CPU_ASSIGNED: 4.5 CPU_ASSIGNED_MAX: 4.5 MEM_CAPACITY: 75161927680 M EM_ASSIGNED: 30064771072 LOG_DISK_CAPACITY: 179583320064 LOG_DISK_ASSIGNED: 55834574848 LOG_DISK_IN_USE: 9395240960 DATA_DISK_CAPACITY: 107374182400 DATA_DISK_IN_USE: 4724883456 DATA_DISK_HEALTH_STATUS: NORMAL DATA_DISK_ABNORMAL_TIME: NULL 3 row in set
更多视图
oceanbase.GV$OB_SERVERS的说明信息请参见 GV$OB_SERVERS。 -
执行以下命令，查看集群内所有租户的资源分配情况。
obclient> SELECT * FROM oceanbase.GV$OB_UNITS\G *************************** 1. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 UNIT_ID: 1 TENANT_ID: 1 ZONE: zone1 MAX_CPU: 2.5 MIN_CPU: 2.5 MEMORY_SIZE: 17179869184 MAX_IOPS: 25000 MIN_IOPS: 25000 IOPS_WEIGHT: 2 LOG_DISK_SIZE: 17179869184 LOG_DISK_IN_USE: 191441460 DATA_DISK_IN_USE: 406847488 STATUS: NORMAL CREATE_TIME: 2022-07-19 11:04:39.226231 *************************** 2. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 UNIT_ID: 1001 TENANT_ID: 1001 ZONE: zone1 MAX_CPU: NULL MIN_CPU: NULL MEMORY_SIZE: 644245094 MAX_IOPS: NULL MIN_IOPS: NULL IOPS_WEIGHT: NULL LOG_DISK_SIZE: 1932735283 LOG_DISK_IN_USE: 155042605 DATA_DISK_IN_USE: 211812352 STATUS: NORMAL CREATE_TIME: 2022-07-19 13:48:36.308843 *************************** 3. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 UNIT_ID: 1001 TENANT_ID: 1002 ZONE: zone1 MAX_CPU: 1 MIN_CPU: 1 MEMORY_SIZE: 5798205850 MAX_IOPS: 10000 MIN_IOPS: 10000 IOPS_WEIGHT: 1 LOG_DISK_SIZE: 17394617549 LOG_DISK_IN_USE: 154632504 DATA_DISK_IN_USE: 121634816 STATUS: NORMAL C REATE_TIME: 2022-07-19 13:48:36.308843 *************************** 4. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 UNIT_ID: 1002 TENANT_ID: 1005 ZONE: zone1 MAX_CPU: NULL MIN_CPU: NULL MEMORY_SIZE: 644245094 MAX_IOPS: NULL MIN_IOPS: NULL I OPS_WEIGHT: NULL LOG_DISK_SIZE: 1932735283 LOG_DISK_IN_USE: 152132563 DATA_DISK_IN_USE: 211812352 STATUS: NORMAL CREATE_TIME: 2022-07-19 13:51:56.627867 *************************** 5. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 UNIT_ID: 1002 TENANT_ID: 1006 ZONE: zone1 MAX_CPU: 1 MIN_CPU: 1 MEMORY_SIZE: 5798205850 MAX_IOPS: 10000 MIN_IOPS: 10000 IOPS_WEIGHT: 1 LOG_DISK_SIZE: 17394617549 LOG_DISK_IN_USE: 158023991 DATA_DISK_IN_USE: 134217728 STATUS: NORMAL CREATE_TIME: 2022-07-19 13:51:56.627867 5 rows in set
更多视图
oceanbase.GV$OB_UNITS的说明信息请参见 GV$OB_UNITS。