obclient > show variables like 'version_comment'; +-----------------+------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +=================+==================================================================================================================+ | version_comment | OceanBase_CE 4.3.5.4 (r104000042025090916-5cf5b925a25bf888aebaa288e251b85b1924e98a) (Built Sep 9 2025 17:07:42) | +-----------------+------------------------------------------------------------------------------------------------------------------+ obclient > SELECT * FROM oceanbase.DBA_OB_ZONES ORDER BY ZONE; +--------+----------------------------+----------------------------+----------+-------------+---------------+-----------+ | ZONE | CREATE_TIME | MODIFY_TIME | STATUS | IDC | REGION | TYPE | +========+============================+============================+==========+=============+===============+===========+ | zone1 | 2025-10-23 16:21:40.922740 | 2025-12-21 19:58:52.860240 | ACTIVE | default_idc | deault_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------------+---------------+-----------+ | zone2 | 2025-10-23 16:21:40.923849 | 2025-12-21 19:58:52.868683 | ACTIVE | default_idc | deault_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------------+---------------+-----------+ | zone3 | 2025-10-23 16:21:40.923849 | 2025-12-21 19:58:52.883468 | ACTIVE | default_idc | deault_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------------+---------------+-----------+ obclient > SELECT * FROM oceanbase.DBA_OB_SERVERS ORDER BY ZONE; +-------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+---------------------+ | SVR_IP | SVR_PORT | ID | ZONE | SQL_PORT | WITH_ROOTSERVER | STATUS | START_SERVICE_TIME | STOP_TIME | BLOCK_MIGRATE_IN_TIME | CREATE_TIME | MODIFY_TIME | BUILD_VERSION | LAST_OFFLINE_TIME | +=============+============+======+========+============+===================+==========+============================+=============+=========================+============================+============================+===========================================================================================+=====================+ | 10.1.224.53 | 2882 | 1 | zone1 | 2881 | YES | ACTIVE | 2025-12-16 11:00:46.622721 | | | 2025-10-23 16:21:42.064789 | 2025-12-16 11:00:47.674982 | 4.3.5.4_104000042025090916-5cf5b925a25bf888aebaa288e251b85b1924e98a(Sep 9 2025 17:07:42) | | +-------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+---------------------+ | 10.1.224.54 | 2882 | 2 | zone2 | 2881 | NO | ACTIVE | 2025-12-16 11:00:47.443127 | | | 2025-10-23 16:21:42.081416 | 2025-12-16 11:00:49.735487 | 4.3.5.4_104000042025090916-5cf5b925a25bf888aebaa288e251b85b1924e98a(Sep 9 2025 17:07:42) | | +-------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+---------------------+ | 10.1.224.55 | 2882 | 3 | zone3 | 2881 | NO | ACTIVE | 2025-12-16 11:00:50.139579 | | | 2025-10-23 16:21:42.100414 | 2025-12-16 11:00:51.855880 | 4.3.5.4_104000042025090916-5cf5b925a25bf888aebaa288e251b85b1924e98a(Sep 9 2025 17:07:42) | | +-------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+---------------------+ obclient > SELECT SVR_IP,SVR_PORT,ZONE,SQL_PORT,CPU_CAPACITY,CPU_CAPACITY_MAX,CPU_ASSIGNED,CPU_ASSIGNED_MAX, concat(ROUND(MEM_CAPACITY/1024/1024/1024,0), 'G') as MEM_CAPACITY, concat(ROUND(MEM_ASSIGNED/1024/1024/1024,0), 'G') as MEM_ASSIGNED, concat(ROUND(LOG_DISK_CAPACITY/1024/1024/1024,0), 'G') as LOG_DISK_CAPACITY, concat(ROUND(LOG_DISK_ASSIGNED/1024/1024/1024,0), 'G') as LOG_DISK_ASSIGNED, concat(ROUND(LOG_DISK_IN_USE/1024/1024/1024,0), 'G') as LOG_DISK_IN_USE, concat(ROUND(DATA_DISK_CAPACITY/1024/1024/1024,0), 'G') as DATA_DISK_CAPACITY,concat(ROUND(DATA_DISK_IN_USE/1024/1024/1024,0), 'G') as DATA_DISK_IN_USE,concat(ROUND(MEMORY_LIMIT/1024/1024/1024,0), 'G') as MEMORY_LIMIT FROM oceanbase.GV$OB_SERVERS; +-------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+----------------+ | SVR_IP | SVR_PORT | ZONE | SQL_PORT | CPU_CAPACITY | CPU_CAPACITY_MAX | CPU_ASSIGNED | CPU_ASSIGNED_MAX | MEM_CAPACITY | MEM_ASSIGNED | LOG_DISK_CAPACITY | LOG_DISK_ASSIGNED | LOG_DISK_IN_USE | DATA_DISK_CAPACITY | DATA_DISK_IN_USE | MEMORY_LIMIT | +=============+============+========+============+================+====================+================+====================+================+================+=====================+=====================+===================+======================+====================+================+ | 10.1.224.53 | 2882 | zone1 | 2881 | 38 | 38 | 13 | 13 | 27G | 18G | 60G | 54G | 36G | 46G | 10G | 30G | +-------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+----------------+ | 10.1.224.54 | 2882 | zone2 | 2881 | 38 | 38 | 13 | 13 | 27G | 18G | 60G | 54G | 36G | 46G | 10G | 30G | +-------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+----------------+ | 10.1.224.55 | 2882 | zone3 | 2881 | 38 | 38 | 13 | 13 | 27G | 18G | 60G | 54G | 36G | 46G | 10G | 30G | +-------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+----------------+ obclient > SELECT * FROM oceanbase.DBA_OB_UNIT_CONFIGS; +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | UNIT_CONFIG_ID | NAME | CREATE_TIME | MODIFY_TIME | MAX_CPU | MIN_CPU | MEMORY_SIZE | LOG_DISK_SIZE | DATA_DISK_SIZE | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT | MAX_NET_BANDWIDTH | NET_BANDWIDTH_WEIGHT | +==================+=====================================+============================+============================+===========+===========+===============+=================+==================+=====================+=====================+===============+=====================+========================+ | 1002 | ocp_meta_unit | 2025-10-23 17:19:10.333958 | 2025-10-23 17:19:10.333958 | 2 | 2 | 3221225472 | 3221225472 | | 10000 | 10000 | 2 | 9223372036854775807 | 2 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1005 | config_ocp_meta_zone1_S2_jxc | 2025-11-12 09:10:14.932597 | 2025-11-12 09:10:14.932597 | 3 | 3 | 12884901888 | 38654705664 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1006 | config_ocp_meta_zone3_S2_ovc | 2025-11-12 09:10:15.039064 | 2025-11-12 09:10:15.039064 | 3 | 3 | 12884901888 | 38654705664 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1007 | config_ocp_meta_zone2_S2_wlz | 2025-11-12 09:10:15.050659 | 2025-11-12 09:10:15.050659 | 3 | 3 | 12884901888 | 38654705664 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1008 | config_ocp_meta_zone1_S2_rru | 2025-11-12 09:14:02.117281 | 2025-11-12 09:14:02.117281 | 3 | 3 | 12884901888 | 38654705664 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1009 | config_ocp_meta_zone3_S2_wzi | 2025-11-12 09:14:02.125642 | 2025-11-12 09:14:02.125642 | 3 | 3 | 12884901888 | 38654705664 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1010 | config_ocp_meta_zone2_S2_lmw | 2025-11-12 09:14:02.140322 | 2025-11-12 09:14:02.140322 | 3 | 3 | 12884901888 | 38654705664 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1011 | config_ocp_meta_zone1_s_3c5g_gba | 2025-11-20 18:24:39.356042 | 2025-11-20 18:24:39.356042 | 3 | 3 | 5368709120 | 16106127360 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1012 | config_ocp_meta_zone3_s_3c5g_upx | 2025-11-20 18:24:39.363865 | 2025-11-20 18:24:39.363865 | 3 | 3 | 5368709120 | 16106127360 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1013 | config_ocp_meta_zone2_s_3c5g_duv | 2025-11-20 18:24:39.376597 | 2025-11-20 18:24:39.376597 | 3 | 3 | 5368709120 | 16106127360 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1014 | config_ocp_meta_zone2_s_3c5g_ykx | 2025-11-20 18:28:13.197265 | 2025-11-20 18:28:13.197265 | 3 | 3 | 5368709120 | 16106127360 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1015 | config_ocp_meta_zone1_s_3c5g_hao | 2025-11-20 18:28:13.204209 | 2025-11-20 18:28:13.204209 | 3 | 3 | 5368709120 | 16106127360 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1016 | config_ocp_meta_zone3_s_3c5g_owf | 2025-11-20 18:28:13.209527 | 2025-11-20 18:28:13.209527 | 3 | 3 | 5368709120 | 16106127360 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1026 | config_andy_zone3_s1_1c1g_ieb | 2025-12-05 15:20:35.274993 | 2025-12-05 15:20:35.274993 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1027 | config_andy_zone1_s1_1c1g_jxd | 2025-12-05 15:20:35.294022 | 2025-12-05 15:20:35.294022 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1028 | config_andy_zone2_s1_1c1g_gqk | 2025-12-05 15:20:35.303485 | 2025-12-05 15:20:35.303485 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1029 | config_andy_zone1_s_1c1g_jih | 2025-12-05 15:28:14.911332 | 2025-12-05 15:28:14.911332 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1030 | config_andy_zone3_s_1c1g_ucf | 2025-12-05 15:28:14.921120 | 2025-12-05 15:28:14.921120 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1031 | config_andy_zone2_s_1c1g_gpx | 2025-12-05 15:28:14.936920 | 2025-12-05 15:28:14.936920 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1032 | config_andy_zone1_s_1c1g_gby | 2025-12-05 15:33:10.390507 | 2025-12-05 15:33:10.390507 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1033 | config_andy_zone3_s_1c1g_aor | 2025-12-05 15:33:10.403162 | 2025-12-05 15:33:10.403162 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1034 | config_andy_zone2_s_1c1g_sng | 2025-12-05 15:33:10.434957 | 2025-12-05 15:33:10.434957 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1035 | config_andy_zone3_s11_iha | 2025-12-05 15:49:20.519300 | 2025-12-05 15:49:20.519300 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1036 | config_andy_zone1_s11_syq | 2025-12-05 15:49:20.530156 | 2025-12-05 15:49:20.530156 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1037 | config_andy_zone2_s11_vms | 2025-12-05 15:49:20.546035 | 2025-12-05 15:49:20.546035 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1038 | config_andy2_zone3_s11_pkv | 2025-12-05 15:58:57.852009 | 2025-12-05 15:58:57.852009 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1039 | config_andy2_zone1_s11_azs | 2025-12-05 15:58:57.860079 | 2025-12-05 15:58:57.860079 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1040 | config_andy2_zone2_s11_mek | 2025-12-05 15:58:57.873842 | 2025-12-05 15:58:57.873842 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1047 | config_andy3_zone1_s11_pbo | 2025-12-05 16:48:12.123669 | 2025-12-05 16:48:12.123669 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1048 | config_andy3_zone3_s11_vaj | 2025-12-05 16:48:12.143888 | 2025-12-05 16:48:12.143888 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1049 | config_andy3_zone2_s11_yym | 2025-12-05 16:48:12.157611 | 2025-12-05 16:48:12.157611 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1050 | config_andy4_zone3_s11_qux | 2025-12-05 16:59:05.756686 | 2025-12-05 16:59:05.756686 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1051 | config_andy4_zone1_s11_ipl | 2025-12-05 16:59:05.821262 | 2025-12-05 16:59:05.821262 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1052 | config_andy4_zone2_s11_wqb | 2025-12-05 16:59:05.828658 | 2025-12-05 16:59:05.828658 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1053 | config_andy5_zone1_s11_wwd | 2025-12-08 10:20:08.222155 | 2025-12-08 10:20:08.222155 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1054 | config_andy5_zone3_s11_cmg | 2025-12-08 10:20:08.230797 | 2025-12-08 10:20:08.230797 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1055 | config_andy5_zone2_s11_jkj | 2025-12-08 10:20:08.244549 | 2025-12-08 10:20:08.244549 | 1 | 1 | 1073741824 | 3221225472 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1065 | config_ocp_monitor_zone1_s_3c5g_wqx | 2025-12-15 16:12:50.304226 | 2025-12-15 16:12:50.304226 | 3 | 3 | 5368709120 | 16106127360 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1069 | config_ocp_meta_zone1_s_3c4g_har | 2025-12-19 15:35:05.125952 | 2025-12-19 15:35:05.125952 | 3 | 3 | 4294967296 | 12884901888 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1070 | config_ocp_meta_zone2_s_3c4g_ceu | 2025-12-19 15:35:37.338110 | 2025-12-19 15:35:37.338110 | 3 | 3 | 4294967296 | 12884901888 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1071 | config_ocp_meta_zone3_s_3c4g_kdb | 2025-12-19 15:35:49.478902 | 2025-12-19 15:35:49.478902 | 3 | 3 | 4294967296 | 12884901888 | | 9223372036854775807 | 9223372036854775807 | 3 | 9223372036854775807 | 3 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1072 | config_ocp_monitor_zone1_c46g_gvp | 2025-12-19 16:20:20.429595 | 2025-12-19 16:20:20.429595 | 4 | 4 | 6442450944 | 19327352832 | | 9223372036854775807 | 9223372036854775807 | 4 | 9223372036854775807 | 4 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1073 | config_ocp_monitor_zone1_c46g_dub | 2025-12-19 16:23:09.030099 | 2025-12-19 16:23:09.030099 | 4 | 4 | 6442450944 | 19327352832 | | 9223372036854775807 | 9223372036854775807 | 4 | 9223372036854775807 | 4 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1074 | config_ocp_monitor_zone2_c46g_omw | 2025-12-19 16:23:44.305685 | 2025-12-19 16:23:44.305685 | 4 | 4 | 6442450944 | 19327352832 | | 9223372036854775807 | 9223372036854775807 | 4 | 9223372036854775807 | 4 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1075 | config_ocp_monitor_zone3_c46g_kxk | 2025-12-19 16:23:57.458356 | 2025-12-19 16:23:57.458356 | 4 | 4 | 6442450944 | 19327352832 | | 9223372036854775807 | 9223372036854775807 | 4 | 9223372036854775807 | 4 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1076 | config_sys_zone1_c46g_vop | 2025-12-19 16:50:53.141319 | 2025-12-19 16:50:53.141319 | 4 | 4 | 6442450944 | 19327352832 | | 9223372036854775807 | 9223372036854775807 | 4 | 9223372036854775807 | 4 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1077 | config_sys_zone2_c46g_gmv | 2025-12-19 16:51:16.270749 | 2025-12-19 16:51:16.270749 | 4 | 4 | 6442450944 | 19327352832 | | 9223372036854775807 | 9223372036854775807 | 4 | 9223372036854775807 | 4 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1078 | config_sys_zone3_c46g_mfw | 2025-12-19 16:51:30.425530 | 2025-12-19 16:51:30.425530 | 4 | 4 | 6442450944 | 19327352832 | | 9223372036854775807 | 9223372036854775807 | 4 | 9223372036854775807 | 4 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1082 | config_binlog_zone3_s22_tqd | 2025-12-21 19:57:21.972243 | 2025-12-21 19:57:21.972243 | 2 | 2 | 2147483648 | 6442450944 | | 9223372036854775807 | 9223372036854775807 | 2 | 9223372036854775807 | 2 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1083 | config_binlog_zone1_s22_wao | 2025-12-21 19:57:21.985988 | 2025-12-21 19:57:21.985988 | 2 | 2 | 2147483648 | 6442450944 | | 9223372036854775807 | 9223372036854775807 | 2 | 9223372036854775807 | 2 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1084 | config_binlog_zone2_s22_uul | 2025-12-21 19:57:21.993361 | 2025-12-21 19:57:21.993361 | 2 | 2 | 2147483648 | 6442450944 | | 9223372036854775807 | 9223372036854775807 | 2 | 9223372036854775807 | 2 | +------------------+-------------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ obclient > SELECT * FROM oceanbase.DBA_OB_RESOURCE_POOLS; +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | RESOURCE_POOL_ID | NAME | TENANT_ID | CREATE_TIME | MODIFY_TIME | UNIT_COUNT | UNIT_CONFIG_ID | ZONE_LIST | REPLICA_TYPE | +====================+============================+=============+============================+============================+==============+==================+=============+================+ | 1005 | pool_ocp_meta_zone1_zir | 1006 | 2025-11-12 09:10:13.928695 | 2025-12-19 15:35:05.389568 | 1 | 1069 | zone1 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1006 | pool_ocp_meta_zone2_jzi | 1006 | 2025-11-12 09:10:14.074008 | 2025-12-19 15:35:37.405055 | 1 | 1070 | zone2 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1007 | pool_ocp_meta_zone3_lha | 1006 | 2025-11-12 09:10:14.078233 | 2025-12-19 15:35:49.536046 | 1 | 1071 | zone3 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1008 | pool_ocp_monitor_zone1_ubi | 1008 | 2025-12-01 09:32:26.404122 | 2025-12-19 16:23:09.056483 | 1 | 1073 | zone1 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1009 | pool_ocp_monitor_zone2_pfr | 1008 | 2025-12-01 09:32:26.409360 | 2025-12-19 16:23:44.329942 | 1 | 1074 | zone2 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1010 | pool_ocp_monitor_zone3_olu | 1008 | 2025-12-01 09:32:26.409360 | 2025-12-19 16:23:57.486928 | 1 | 1075 | zone3 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1023 | pool_andy_zone3_iha | | 2025-12-05 15:49:20.555272 | 2025-12-05 15:58:02.296114 | 1 | 1035 | zone3 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1024 | pool_andy_zone1_syq | | 2025-12-05 15:49:20.572509 | 2025-12-05 15:58:02.301150 | 1 | 1036 | zone1 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1025 | pool_andy_zone2_vms | | 2025-12-05 15:49:20.584176 | 2025-12-05 15:58:02.302205 | 1 | 1037 | zone2 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1035 | pool_andy5_zone1_wwd | | 2025-12-08 10:20:08.922999 | 2025-12-08 14:47:30.091444 | 1 | 1053 | zone1 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1036 | pool_andy5_zone3_cmg | | 2025-12-08 10:20:09.081295 | 2025-12-08 14:47:30.097598 | 1 | 1054 | zone3 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1037 | pool_andy5_zone2_jkj | | 2025-12-08 10:20:09.117118 | 2025-12-08 14:47:30.098652 | 1 | 1055 | zone2 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1038 | pool_sys_zone1_jhx | 1 | 2025-12-12 14:37:02.530888 | 2025-12-19 16:50:53.172057 | 1 | 1076 | zone1 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1039 | pool_sys_zone2_tes | 1 | 2025-12-12 14:37:02.534819 | 2025-12-19 16:51:16.304452 | 1 | 1077 | zone2 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1040 | pool_sys_zone3_yqi | 1 | 2025-12-12 14:37:02.535875 | 2025-12-19 16:51:30.453063 | 1 | 1078 | zone3 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1044 | pool_binlog_zone3_tqd | 1024 | 2025-12-21 19:57:22.007036 | 2025-12-21 19:57:22.584984 | 1 | 1082 | zone3 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1045 | pool_binlog_zone1_wao | 1024 | 2025-12-21 19:57:22.029202 | 2025-12-21 19:57:22.399103 | 1 | 1083 | zone1 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1046 | pool_binlog_zone2_uul | 1024 | 2025-12-21 19:57:22.046139 | 2025-12-21 19:57:22.583910 | 1 | 1084 | zone2 | FULL | +--------------------+----------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ obclient > SELECT * FROM oceanbase.DBA_OB_TENANTS; +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+---------------+ | TENANT_ID | TENANT_NAME | TENANT_TYPE | CREATE_TIME | MODIFY_TIME | PRIMARY_ZONE | LOCALITY | PREVIOUS_LOCALITY | COMPATIBILITY_MODE | STATUS | IN_RECYCLEBIN | LOCKED | TENANT_ROLE | SWITCHOVER_STATUS | SWITCHOVER_EPOCH | SYNC_SCN | REPLAYABLE_SCN | READABLE_SCN | RECOVERY_UNTIL_SCN | LOG_MODE | ARBITRATION_SERVICE_STATUS | UNIT_NUM | COMPATIBLE | MAX_LS_ID | RESTORE_DATA_MODE | COMMENT | +=============+===============+===============+============================+============================+================+=============================================+=====================+======================+==========+=================+==========+===============+=====================+====================+=====================+=====================+=====================+======================+==============+==============================+============+==============+=============+=====================+===============+ | 1 | sys | SYS | 2025-10-23 16:21:40.645540 | 2025-10-23 16:21:40.645540 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.3.5.4 | 1 | NORMAL | system tenant | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+---------------+ | 1005 | META$1006 | META | 2025-10-24 09:55:44.983065 | 2025-10-24 09:55:59.908361 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.3.5.4 | 1 | NORMAL | | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+---------------+ | 1006 | ocp_meta | USER | 2025-10-24 09:55:44.993689 | 2025-10-24 09:56:00.213226 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | 1766372460629393003 | 1766372460629393003 | 1766372460629393002 | 4611686018427387903 | NOARCHIVELOG | DISABLED | 1 | 4.3.5.4 | 1003 | NORMAL | | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+---------------+ | 1007 | META$1008 | META | 2025-10-24 09:56:04.793354 | 2025-10-24 09:56:18.055008 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.3.5.4 | 1 | NORMAL | | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+---------------+ | 1008 | ocp_monitor | USER | 2025-10-24 09:56:04.801597 | 2025-10-24 09:56:18.196473 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | 1766372460629393002 | 1766372460629393002 | 1766372460562745004 | 4611686018427387903 | NOARCHIVELOG | DISABLED | 1 | 4.3.5.4 | 1003 | NORMAL | | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+---------------+ | 1023 | META$1024 | META | 2025-12-21 19:57:22.349853 | 2025-12-21 19:57:43.499204 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.3.5.4 | 1 | NORMAL | | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+---------------+ | 1024 | binlog | USER | 2025-12-21 19:57:22.393807 | 2025-12-21 19:57:43.609992 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | 1766372460630450002 | 1766372460630450002 | 1766372460630450002 | 4611686018427387903 | NOARCHIVELOG | DISABLED | 1 | 4.3.5.4 | 1003 | NORMAL | | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+---------------+ obclient > SELECT c.TENANT_ID, e.TENANT_NAME, concat(c.NAME, ': ', d.NAME) `pool:conf`,concat(c.UNIT_COUNT, ' unit: ', d.min_cpu, 'C/', ROUND(d.MEMORY_SIZE/1024/1024/1024,0), 'G') unit_info FROM oceanbase.DBA_OB_RESOURCE_POOLS c, oceanbase.DBA_OB_UNIT_CONFIGS d, oceanbase.DBA_OB_TENANTS e WHERE c.UNIT_CONFIG_ID=d.UNIT_CONFIG_ID AND c.TENANT_ID=e.TENANT_ID AND c.TENANT_ID>1000 ORDER BY c.TENANT_ID; +-------------+---------------+---------------------------------------------------------------+---------------+ | TENANT_ID | TENANT_NAME | pool:conf | unit_info | +=============+===============+===============================================================+===============+ | 1006 | ocp_meta | pool_ocp_meta_zone1_zir: config_ocp_meta_zone1_s_3c4g_har | 1 unit: 3C/4G | +-------------+---------------+---------------------------------------------------------------+---------------+ | 1006 | ocp_meta | pool_ocp_meta_zone2_jzi: config_ocp_meta_zone2_s_3c4g_ceu | 1 unit: 3C/4G | +-------------+---------------+---------------------------------------------------------------+---------------+ | 1006 | ocp_meta | pool_ocp_meta_zone3_lha: config_ocp_meta_zone3_s_3c4g_kdb | 1 unit: 3C/4G | +-------------+---------------+---------------------------------------------------------------+---------------+ | 1008 | ocp_monitor | pool_ocp_monitor_zone1_ubi: config_ocp_monitor_zone1_c46g_dub | 1 unit: 4C/6G | +-------------+---------------+---------------------------------------------------------------+---------------+ | 1008 | ocp_monitor | pool_ocp_monitor_zone2_pfr: config_ocp_monitor_zone2_c46g_omw | 1 unit: 4C/6G | +-------------+---------------+---------------------------------------------------------------+---------------+ | 1008 | ocp_monitor | pool_ocp_monitor_zone3_olu: config_ocp_monitor_zone3_c46g_kxk | 1 unit: 4C/6G | +-------------+---------------+---------------------------------------------------------------+---------------+ | 1024 | binlog | pool_binlog_zone3_tqd: config_binlog_zone3_s22_tqd | 1 unit: 2C/2G | +-------------+---------------+---------------------------------------------------------------+---------------+ | 1024 | binlog | pool_binlog_zone1_wao: config_binlog_zone1_s22_wao | 1 unit: 2C/2G | +-------------+---------------+---------------------------------------------------------------+---------------+ | 1024 | binlog | pool_binlog_zone2_uul: config_binlog_zone2_s22_uul | 1 unit: 2C/2G | +-------------+---------------+---------------------------------------------------------------+---------------+ obclient > SELECT a.TENANT_NAME,a.TENANT_ID,b.SVR_IP FROM oceanbase.DBA_OB_TENANTS a, oceanbase.GV$OB_UNITS b WHERE a.TENANT_ID=b.TENANT_ID; +---------------+-------------+-------------+ | TENANT_NAME | TENANT_ID | SVR_IP | +===============+=============+=============+ | sys | 1 | 10.1.224.53 | +---------------+-------------+-------------+ | META$1006 | 1005 | 10.1.224.53 | +---------------+-------------+-------------+ | ocp_meta | 1006 | 10.1.224.53 | +---------------+-------------+-------------+ | META$1008 | 1007 | 10.1.224.53 | +---------------+-------------+-------------+ | ocp_monitor | 1008 | 10.1.224.53 | +---------------+-------------+-------------+ | META$1024 | 1023 | 10.1.224.53 | +---------------+-------------+-------------+ | binlog | 1024 | 10.1.224.53 | +---------------+-------------+-------------+ | sys | 1 | 10.1.224.55 | +---------------+-------------+-------------+ | META$1006 | 1005 | 10.1.224.55 | +---------------+-------------+-------------+ | ocp_meta | 1006 | 10.1.224.55 | +---------------+-------------+-------------+ | META$1008 | 1007 | 10.1.224.55 | +---------------+-------------+-------------+ | ocp_monitor | 1008 | 10.1.224.55 | +---------------+-------------+-------------+ | META$1024 | 1023 | 10.1.224.55 | +---------------+-------------+-------------+ | binlog | 1024 | 10.1.224.55 | +---------------+-------------+-------------+ | sys | 1 | 10.1.224.54 | +---------------+-------------+-------------+ | META$1006 | 1005 | 10.1.224.54 | +---------------+-------------+-------------+ | ocp_meta | 1006 | 10.1.224.54 | +---------------+-------------+-------------+ | META$1008 | 1007 | 10.1.224.54 | +---------------+-------------+-------------+ | ocp_monitor | 1008 | 10.1.224.54 | +---------------+-------------+-------------+ | META$1024 | 1023 | 10.1.224.54 | +---------------+-------------+-------------+ | binlog | 1024 | 10.1.224.54 | +---------------+-------------+-------------+ obclient > show parameters like '%syslog_level%'; +--------+------------+-------------+------------+--------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | default_value | isdefault | +========+============+=============+============+==============+=============+=========+==============================================================================================================================+===========+=========+==========+===================+=================+=============+ | zone1 | observer | 10.1.224.53 | 2882 | syslog_level | STRING | WDIAG | specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | WDIAG | 1 | +--------+------------+-------------+------------+--------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone2 | observer | 10.1.224.54 | 2882 | syslog_level | STRING | WDIAG | specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | WDIAG | 1 | +--------+------------+-------------+------------+--------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone3 | observer | 10.1.224.55 | 2882 | syslog_level | STRING | WDIAG | specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | WDIAG | 1 | +--------+------------+-------------+------------+--------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ obclient > show parameters like '%syslog_io_bandwidth_limit%'; +--------+------------+-------------+------------+---------------------------+-------------+---------+--------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | default_value | isdefault | +========+============+=============+============+===========================+=============+=========+==================================================================================================+===========+=========+==========+===================+=================+=============+ | zone1 | observer | 10.1.224.53 | 2882 | syslog_io_bandwidth_limit | CAPACITY | 30MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 30MB | 1 | +--------+------------+-------------+------------+---------------------------+-------------+---------+--------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone2 | observer | 10.1.224.54 | 2882 | syslog_io_bandwidth_limit | CAPACITY | 30MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 30MB | 1 | +--------+------------+-------------+------------+---------------------------+-------------+---------+--------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone3 | observer | 10.1.224.55 | 2882 | syslog_io_bandwidth_limit | CAPACITY | 30MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 30MB | 1 | +--------+------------+-------------+------------+---------------------------+-------------+---------+--------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ obclient > show parameters like '%merge%'; +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | default_value | isdefault | +========+============+=============+============+================================+=============+================+======================================================================================================================================================================================================================================================================================================================================================================================================================+=============+=========+==========+===================+=================+=============+ | zone3 | observer | 10.1.224.55 | 2882 | micro_block_merge_verify_level | INT | 2 | specify what kind of verification should be done when merging micro block. 0 : no verification will be done 1 : verify encoding algorithm, encoded micro block will be read to ensure data is correct 2 : verify encoding and compression algorithm, besides encoding verification, compressed block will be decompressed to ensure data is correct3 : verify encoding, compression algorithm and lost write protect | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2 | 1 | +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ | zone3 | observer | 10.1.224.55 | 2882 | default_table_merge_engine | STRING | PARTIAL_UPDATE | Specify the default merge_engine when creating table: partial_update, delete_insert. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | PARTIAL_UPDATE | 1 | +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ | zone3 | observer | 10.1.224.55 | 2882 | merger_check_interval | TIME | 10m | the time interval between the schedules of the task that checks on the progress of MERGE for each zone. Range: [10s, 60m] | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 10m | 1 | +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ | zone3 | observer | 10.1.224.55 | 2882 | default_progressive_merge_num | INT | 0 | default progressive_merge_num when tenant create tableRange:[0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ | zone2 | observer | 10.1.224.54 | 2882 | micro_block_merge_verify_level | INT | 2 | specify what kind of verification should be done when merging micro block. 0 : no verification will be done 1 : verify encoding algorithm, encoded micro block will be read to ensure data is correct 2 : verify encoding and compression algorithm, besides encoding verification, compressed block will be decompressed to ensure data is correct3 : verify encoding, compression algorithm and lost write protect | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2 | 1 | +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ | zone2 | observer | 10.1.224.54 | 2882 | default_table_merge_engine | STRING | PARTIAL_UPDATE | Specify the default merge_engine when creating table: partial_update, delete_insert. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | PARTIAL_UPDATE | 1 | +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ | zone2 | observer | 10.1.224.54 | 2882 | merger_check_interval | TIME | 10m | the time interval between the schedules of the task that checks on the progress of MERGE for each zone. Range: [10s, 60m] | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 10m | 1 | +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ | zone2 | observer | 10.1.224.54 | 2882 | default_progressive_merge_num | INT | 0 | default progressive_merge_num when tenant create tableRange:[0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ | zone1 | observer | 10.1.224.53 | 2882 | micro_block_merge_verify_level | INT | 2 | specify what kind of verification should be done when merging micro block. 0 : no verification will be done 1 : verify encoding algorithm, encoded micro block will be read to ensure data is correct 2 : verify encoding and compression algorithm, besides encoding verification, compressed block will be decompressed to ensure data is correct3 : verify encoding, compression algorithm and lost write protect | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2 | 1 | +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ | zone1 | observer | 10.1.224.53 | 2882 | default_table_merge_engine | STRING | PARTIAL_UPDATE | Specify the default merge_engine when creating table: partial_update, delete_insert. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | PARTIAL_UPDATE | 1 | +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ | zone1 | observer | 10.1.224.53 | 2882 | merger_check_interval | TIME | 10m | the time interval between the schedules of the task that checks on the progress of MERGE for each zone. Range: [10s, 60m] | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 10m | 1 | +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ | zone1 | observer | 10.1.224.53 | 2882 | default_progressive_merge_num | INT | 0 | default progressive_merge_num when tenant create tableRange:[0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+-------------+------------+--------------------------------+-------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------+-------------------+-----------------+-------------+ obclient > show parameters like 'memstore_limit_percentage'; +--------+------------+-------------+------------+---------------------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | default_value | isdefault | +========+============+=============+============+===========================+=============+=========+======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================+===========+=========+==========+===================+=================+=============+ | zone2 | observer | 10.1.224.54 | 2882 | memstore_limit_percentage | INT | 0 | used in calculating the value of MEMSTORE_LIMIT parameter: memstore_limit_percentage = memstore_limit / memory_size, where MEMORY_SIZE is determined when the tenant is created. Range: [0, 100). 1. the system will use memstore_limit_percentage if only memstore_limit_percentage is set.2. the system will use _memstore_limit_percentage if both memstore_limit_percentage and _memstore_limit_percentage is set.3. the system will adjust automatically if both memstore_limit_percentage and _memstore_limit_percentage set to 0(by default). | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+-------------+------------+---------------------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone3 | observer | 10.1.224.55 | 2882 | memstore_limit_percentage | INT | 0 | used in calculating the value of MEMSTORE_LIMIT parameter: memstore_limit_percentage = memstore_limit / memory_size, where MEMORY_SIZE is determined when the tenant is created. Range: [0, 100). 1. the system will use memstore_limit_percentage if only memstore_limit_percentage is set.2. the system will use _memstore_limit_percentage if both memstore_limit_percentage and _memstore_limit_percentage is set.3. the system will adjust automatically if both memstore_limit_percentage and _memstore_limit_percentage set to 0(by default). | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+-------------+------------+---------------------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone1 | observer | 10.1.224.53 | 2882 | memstore_limit_percentage | INT | 0 | used in calculating the value of MEMSTORE_LIMIT parameter: memstore_limit_percentage = memstore_limit / memory_size, where MEMORY_SIZE is determined when the tenant is created. Range: [0, 100). 1. the system will use memstore_limit_percentage if only memstore_limit_percentage is set.2. the system will use _memstore_limit_percentage if both memstore_limit_percentage and _memstore_limit_percentage is set.3. the system will adjust automatically if both memstore_limit_percentage and _memstore_limit_percentage set to 0(by default). | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+-------------+------------+---------------------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ obclient > show parameters like 'freeze_trigger_percentage'; +--------+------------+-------------+------------+---------------------------+-------------+---------+----------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | default_value | isdefault | +========+============+=============+============+===========================+=============+=========+========================================================================================+===========+=========+==========+===================+=================+=============+ | zone2 | observer | 10.1.224.54 | 2882 | freeze_trigger_percentage | INT | 20 | the threshold of the size of the mem store when freeze will be triggered. Rang:(0,100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 20 | 1 | +--------+------------+-------------+------------+---------------------------+-------------+---------+----------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone3 | observer | 10.1.224.55 | 2882 | freeze_trigger_percentage | INT | 20 | the threshold of the size of the mem store when freeze will be triggered. Rang:(0,100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 20 | 1 | +--------+------------+-------------+------------+---------------------------+-------------+---------+----------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone1 | observer | 10.1.224.53 | 2882 | freeze_trigger_percentage | INT | 20 | the threshold of the size of the mem store when freeze will be triggered. Rang:(0,100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 20 | 1 | +--------+------------+-------------+------------+---------------------------+-------------+---------+----------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ obclient > select t.tenant_name, t1.database_name, round(sum(t2.data_size)/1024/1024/1024,2) as data_size_gb, round(sum(t2.required_size)/1024/1024/1024,2) as required_size_gb from oceanbase.dba_ob_tenants t, oceanbase.cdb_ob_table_locations t1, oceanbase.cdb_ob_tablet_replicas t2 where t.tenant_id=t1.tenant_id and t1.svr_ip=t2.svr_ip and t1.tenant_id=t2.tenant_id and t1.ls_id=t2.ls_id and t1.tablet_id=t2.tablet_id and t1.role='leader' group by t.tenant_name, t1.database_name order by data_size_gb desc; +---------------+------------------+----------------+--------------------+ | tenant_name | database_name | data_size_gb | required_size_gb | +===============+==================+================+====================+ | ocp_meta | meta_database | 3.58 | 3.58 | +---------------+------------------+----------------+--------------------+ | ocp_monitor | monitor_database | 1.89 | 1.89 | +---------------+------------------+----------------+--------------------+ | META$1008 | oceanbase | 0.39 | 0.39 | +---------------+------------------+----------------+--------------------+ | sys | oceanbase | 0.36 | 0.36 | +---------------+------------------+----------------+--------------------+ | META$1006 | oceanbase | 0.22 | 0.22 | +---------------+------------------+----------------+--------------------+ | ocp_monitor | oceanbase | 0.06 | 0.06 | +---------------+------------------+----------------+--------------------+ | sys | ocs | 0.02 | 0.02 | +---------------+------------------+----------------+--------------------+ | binlog | oceanbase | 0.01 | 0.01 | +---------------+------------------+----------------+--------------------+ | ocp_meta | oceanbase | 0.01 | 0.01 | +---------------+------------------+----------------+--------------------+ | META$1024 | oceanbase | 0.01 | 0.01 | +---------------+------------------+----------------+--------------------+ | ocp_meta | backup21 | 0 | 0 | +---------------+------------------+----------------+--------------------+ | binlog | binlog_database | 0 | 0 | +---------------+------------------+----------------+--------------------+ | binlog | mysql | 0 | 0 | +---------------+------------------+----------------+--------------------+ | META$1024 | mysql | 0 | 0 | +---------------+------------------+----------------+--------------------+ | ocp_monitor | mysql | 0 | 0 | +---------------+------------------+----------------+--------------------+ | META$1008 | mysql | 0 | 0 | +---------------+------------------+----------------+--------------------+ | ocp_meta | backup2230 | 0 | 0 | +---------------+------------------+----------------+--------------------+ | ocp_meta | backup147x | 0 | 0 | +---------------+------------------+----------------+--------------------+ | ocp_meta | backup1472 | 0 | 0 | +---------------+------------------+----------------+--------------------+ | ocp_meta | mysql | 0 | 0 | +---------------+------------------+----------------+--------------------+ | META$1006 | mysql | 0 | 0 | +---------------+------------------+----------------+--------------------+ | sys | andy | 0 | 0 | +---------------+------------------+----------------+--------------------+ | sys | ocp | 0 | 0 | +---------------+------------------+----------------+--------------------+ | sys | mysql | 0 | 0 | +---------------+------------------+----------------+--------------------+ obclient > select b.zone, a.svr_ip,a.svr_port,b.with_rootserver, round(a.total_size/1024/1024/1024,0) as total_GB,round(a.free_size/1024/1024/1024,0) as free_GB, round((a.total_size-a.free_size)/1024/1024/1024,0) as used_GB,(a.total_size-a.free_size)/a.total_size as used_percent from oceanbase.__all_virtual_disk_stat a, oceanbase.DBA_OB_SERVERS b where a.svr_ip=b.svr_ip and a.svr_port=b.svr_port order by b.zone,used_percent desc; +--------+-------------+------------+-------------------+------------+-----------+-----------+----------------+ | zone | svr_ip | svr_port | with_rootserver | total_GB | free_GB | used_GB | used_percent | +========+=============+============+===================+============+===========+===========+================+ | zone1 | 10.1.224.53 | 2882 | YES | 46 | 22 | 24 | 0.5144 | +--------+-------------+------------+-------------------+------------+-----------+-----------+----------------+ | zone2 | 10.1.224.54 | 2882 | NO | 46 | 14 | 32 | 0.6852 | +--------+-------------+------------+-------------------+------------+-----------+-----------+----------------+ | zone3 | 10.1.224.55 | 2882 | NO | 46 | 12 | 34 | 0.7297 | +--------+-------------+------------+-------------------+------------+-----------+-----------+----------------+ obclient > select tenant_name, svr_ip, memstore_limit /(1024 * 1024 * 1024) as memstore_limit_GB, freeze_trigger /(1024 * 1024 * 1024) as freeze_trigger_GB, memstore_used /(1024 * 1024 * 1024) as memstore_used_GB, concat((memstore_used * 100 / memstore_limit), '%') as memstore_used_percent, active_span /(1024 * 1024 * 1024) as active_span_GB, freeze_cnt from oceanbase.GV$OB_MEMSTORE memstore_info inner join oceanbase.DBA_OB_TENANTS tenant on memstore_info.tenant_id = tenant.tenant_id ORDER BY tenant.tenant_name,svr_ip; +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | tenant_name | svr_ip | memstore_limit_GB | freeze_trigger_GB | memstore_used_GB | memstore_used_percent | active_span_GB | freeze_cnt | +===============+=============+=====================+=====================+====================+=========================+==================+==============+ | binlog | 10.1.224.53 | 0.4 | 0.1011 | 0.084 | 20.9961% | 0.0859 | 4 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | binlog | 10.1.224.54 | 0.4 | 0.1055 | 0.0723 | 18.0664% | 0.0723 | 4 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | binlog | 10.1.224.55 | 0.4 | 0.1038 | 0.0703 | 17.5781% | 0.0703 | 4 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1006 | 10.1.224.53 | 0.4 | 0.0776 | 0.0684 | 17.0898% | 0.0684 | 6 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1006 | 10.1.224.54 | 0.4 | 0.0839 | 0.0547 | 13.6719% | 0.0547 | 5 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1006 | 10.1.224.55 | 0.4 | 0.0843 | 0.0508 | 12.6953% | 0.0508 | 5 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1008 | 10.1.224.53 | 0.4 | 0.0749 | 0.0508 | 12.6953% | 0.0508 | 12 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1008 | 10.1.224.54 | 0.4 | 0.0825 | 0.0625 | 15.6250% | 0.0625 | 9 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1008 | 10.1.224.55 | 0.4 | 0.0825 | 0.0527 | 13.1836% | 0.0527 | 9 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1024 | 10.1.224.53 | 0.4 | 0.0881 | 0.0781 | 19.5313% | 0.0781 | 3 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1024 | 10.1.224.54 | 0.4 | 0.0907 | 0.0566 | 14.1602% | 0.0566 | 3 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1024 | 10.1.224.55 | 0.4 | 0.0938 | 0.0801 | 20.0195% | 0.082 | 3 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | ocp_meta | 10.1.224.53 | 1.2 | 0.3271 | 0.2891 | 24.0885% | 0.291 | 0 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | ocp_meta | 10.1.224.54 | 1.2 | 0.3288 | 0.2637 | 21.9727% | 0.2637 | 0 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | ocp_meta | 10.1.224.55 | 1.2 | 0.3251 | 0.3047 | 25.3906% | 0.3086 | 0 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | ocp_monitor | 10.1.224.53 | 2 | 0.525 | 0.4863 | 24.3164% | 0.4863 | 17 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | ocp_monitor | 10.1.224.54 | 2 | 0.525 | 0.5 | 25.0000% | 0.5 | 19 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | ocp_monitor | 10.1.224.55 | 2 | 0.4966 | 0.1465 | 7.3242% | 0.1465 | 18 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | sys | 10.1.224.53 | 2.8 | 0.685 | 0.1758 | 6.2779% | 0.1758 | 1 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | sys | 10.1.224.54 | 2.8 | 0.685 | 0.6406 | 22.8795% | 0.6406 | 0 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | sys | 10.1.224.55 | 2.8 | 0.685 | 0.6309 | 22.5307% | 0.6523 | 0 | +---------------+-------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ obclient > select svr_ip, svr_port, ls_id, count(*) from oceanbase.CDB_OB_TABLE_LOCATIONS group by svr_ip, svr_port, ls_id; +-------------+------------+---------+------------+ | svr_ip | svr_port | ls_id | count(*) | +=============+============+=========+============+ | 10.1.224.55 | 2882 | 1 | 6673 | +-------------+------------+---------+------------+ | 10.1.224.54 | 2882 | 1 | 6673 | +-------------+------------+---------+------------+ | 10.1.224.53 | 2882 | 1 | 6673 | +-------------+------------+---------+------------+ | 10.1.224.55 | 2882 | 1001 | 3686 | +-------------+------------+---------+------------+ | 10.1.224.54 | 2882 | 1001 | 3686 | +-------------+------------+---------+------------+ | 10.1.224.53 | 2882 | 1001 | 3686 | +-------------+------------+---------+------------+ | 10.1.224.55 | 2882 | 1002 | 3620 | +-------------+------------+---------+------------+ | 10.1.224.54 | 2882 | 1002 | 3620 | +-------------+------------+---------+------------+ | 10.1.224.53 | 2882 | 1002 | 3620 | +-------------+------------+---------+------------+ | 10.1.224.55 | 2882 | 1003 | 3617 | +-------------+------------+---------+------------+ | 10.1.224.54 | 2882 | 1003 | 3617 | +-------------+------------+---------+------------+ | 10.1.224.53 | 2882 | 1003 | 3617 | +-------------+------------+---------+------------+