obclient > show variables like 'version_comment'; +-----------------+------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +=================+==================================================================================================================+ | version_comment | OceanBase_CE 4.3.5.6 (r106000012026040916-560923b02bdb9ed88dbd7940ac97a2e183c09b29) (Built Apr 9 2026 17:11:14) | +-----------------+------------------------------------------------------------------------------------------------------------------+ obclient > SELECT * FROM oceanbase.DBA_OB_ZONES ORDER BY ZONE; +--------+----------------------------+----------------------------+----------+-------------+---------------+-----------+ | ZONE | CREATE_TIME | MODIFY_TIME | STATUS | IDC | REGION | TYPE | +========+============================+============================+==========+=============+===============+===========+ | zone1 | 2026-05-13 16:47:46.091104 | 2026-05-13 16:47:52.382920 | ACTIVE | default_idc | deault_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------------+---------------+-----------+ | zone2 | 2026-05-13 16:47:46.091104 | 2026-05-13 16:47:52.387123 | ACTIVE | default_idc | deault_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------------+---------------+-----------+ | zone3 | 2026-05-13 16:47:46.092161 | 2026-05-13 16:47:52.390306 | 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.19.50.6 | 2882 | 1 | zone1 | 2881 | YES | ACTIVE | 2026-08-24 18:47:54.406133 | | | 2026-05-13 16:47:46.746162 | 2026-08-24 18:47:55.774261 | 4.3.5.6_106000012026040916-560923b02bdb9ed88dbd7940ac97a2e183c09b29(Apr 9 2026 17:11:14) | | +------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+---------------------+ | 10.19.50.7 | 2882 | 2 | zone2 | 2881 | NO | ACTIVE | 2026-08-24 18:47:57.494700 | | | 2026-05-13 16:47:46.759793 | 2026-08-24 18:47:59.907531 | 4.3.5.6_106000012026040916-560923b02bdb9ed88dbd7940ac97a2e183c09b29(Apr 9 2026 17:11:14) | | +------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+---------------------+ | 10.19.50.8 | 2882 | 3 | zone3 | 2881 | NO | ACTIVE | 2026-08-24 18:47:56.502670 | | | 2026-05-13 16:47:46.773542 | 2026-08-24 18:47:57.866209 | 4.3.5.6_106000012026040916-560923b02bdb9ed88dbd7940ac97a2e183c09b29(Apr 9 2026 17:11:14) | | +------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+---------------------+ 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.19.50.8 | 2882 | zone3 | 2881 | 8 | 8 | 8 | 8 | 15G | 15G | 52G | 43G | 35G | 218G | 34G | 21G | +------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+----------------+ | 10.19.50.7 | 2882 | zone2 | 2881 | 8 | 8 | 8 | 8 | 15G | 15G | 52G | 43G | 35G | 218G | 34G | 21G | +------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+----------------+ | 10.19.50.6 | 2882 | zone1 | 2881 | 8 | 8 | 8 | 8 | 15G | 15G | 52G | 43G | 35G | 218G | 34G | 21G | +------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+----------------+ 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 | +==================+==============================+============================+============================+===========+===========+===============+=================+==================+=====================+=====================+===============+=====================+========================+ | 1 | sys_unit_config | 2026-05-13 16:47:45.845139 | 2026-05-13 16:47:45.845139 | 2 | 2 | 2147483648 | 4294967296 | | 9223372036854775807 | 9223372036854775807 | 2 | 9223372036854775807 | 2 | +------------------+------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1001 | tenant_unit_1778662320267_2 | 2026-05-13 16:52:00.335468 | 2026-05-13 16:52:00.335468 | 4 | 4 | 8589934592 | 25769803776 | | 9223372036854775807 | 9223372036854775807 | 4 | 9223372036854775807 | 4 | +------------------+------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1002 | tenant_unit_1779795929902_2 | 2026-05-26 19:45:30.062989 | 2026-05-26 19:45:30.062989 | 2 | 2 | 5368709120 | 16106127360 | | 9223372036854775807 | 9223372036854775807 | 2 | 9223372036854775807 | 2 | +------------------+------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1003 | tenant_unit_1782874795680_4 | 2026-07-01 10:59:56.062612 | 2026-07-01 10:59:56.062612 | 1 | 1 | 2147483648 | 6442450944 | | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | +------------------+------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1004 | tenant_unit_1782874868700_44 | 2026-07-01 11:01:09.023649 | 2026-07-01 11:01:09.023649 | 5 | 5 | 6442450944 | 19327352832 | | 9223372036854775807 | 9223372036854775807 | 5 | 9223372036854775807 | 5 | +------------------+------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1005 | tenant_unit_1782874921135_51 | 2026-07-01 11:02:01.453810 | 2026-07-01 11:02:01.453810 | 5 | 5 | 8589934592 | 25769803776 | | 9223372036854775807 | 9223372036854775807 | 5 | 9223372036854775807 | 5 | +------------------+------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1006 | tenant_unit_1782959991882_58 | 2026-07-02 10:39:52.147947 | 2026-07-02 10:39:52.147947 | 5 | 5 | 10737418240 | 32212254720 | | 9223372036854775807 | 9223372036854775807 | 5 | 9223372036854775807 | 5 | +------------------+------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1007 | tenant_unit_1787561247167_16 | 2026-08-24 16:47:28.041965 | 2026-08-24 16:47:28.041965 | 5 | 5 | 11811160064 | 35433480192 | | 9223372036854775807 | 9223372036854775807 | 5 | 9223372036854775807 | 5 | +------------------+------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1008 | tenant_unit_1787561260044_26 | 2026-08-24 16:47:40.852767 | 2026-08-24 16:47:40.852767 | 5 | 5 | 11811160064 | 35433480192 | | 9223372036854775807 | 9223372036854775807 | 5 | 9223372036854775807 | 5 | +------------------+------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ | 1009 | tenant_unit_1787561273822_36 | 2026-08-24 16:47:54.633095 | 2026-08-24 16:47:54.633095 | 5 | 5 | 11811160064 | 35433480192 | | 9223372036854775807 | 9223372036854775807 | 5 | 9223372036854775807 | 5 | +------------------+------------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+------------------+---------------------+---------------------+---------------+---------------------+------------------------+ 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 | +====================+==========================+=============+============================+============================+==============+==================+===================+================+ | 1 | sys_pool | 1 | 2026-05-13 16:47:45.849578 | 2026-05-13 16:47:45.862158 | 1 | 1 | zone1;zone2;zone3 | FULL | +--------------------+--------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------------+----------------+ | 1001 | patswp_zone1_1778662320 | 1002 | 2026-05-13 16:52:01.581543 | 2026-07-01 10:59:57.124091 | 1 | 1003 | zone1 | FULL | +--------------------+--------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------------+----------------+ | 1002 | patswp_zone2_1778662320 | 1002 | 2026-05-13 16:52:01.606444 | 2026-07-01 10:59:57.151335 | 1 | 1003 | zone2 | FULL | +--------------------+--------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------------+----------------+ | 1003 | patswp_zone3_1778662320 | 1002 | 2026-05-13 16:52:01.629740 | 2026-07-01 10:59:57.171457 | 1 | 1003 | zone3 | FULL | +--------------------+--------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------------+----------------+ | 1004 | patswp2_zone1_1779795930 | 1004 | 2026-05-26 19:45:31.721110 | 2026-08-24 16:47:28.937549 | 1 | 1007 | zone1 | FULL | +--------------------+--------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------------+----------------+ | 1005 | patswp2_zone2_1779795930 | 1004 | 2026-05-26 19:45:31.795246 | 2026-08-24 16:47:41.190804 | 1 | 1008 | zone2 | FULL | +--------------------+--------------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------------+----------------+ | 1006 | patswp2_zone3_1779795930 | 1004 | 2026-05-26 19:45:31.818508 | 2026-08-24 16:47:55.342905 | 1 | 1009 | zone3 | 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 | 2026-05-13 16:47:45.877386 | 2026-05-13 16:47:45.877386 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.3.5.6 | 1 | NORMAL | system tenant | +-------------+---------------+---------------+----------------------------+----------------------------+-------------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+---------------+ | 1001 | META$1002 | META | 2026-05-13 16:52:01.667666 | 2026-05-13 16:52:11.931065 | zone1,zone2,zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.3.5.6 | 1 | NORMAL | | +-------------+---------------+---------------+----------------------------+----------------------------+-------------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+---------------+ | 1002 | patswp | USER | 2026-05-13 16:52:01.670958 | 2026-05-13 16:52:12.012594 | zone1,zone2,zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | 1787622709908355002 | 1787622709908355002 | 1787622709908355001 | 4611686018427387903 | NOARCHIVELOG | DISABLED | 1 | 4.3.5.6 | 1003 | NORMAL | | +-------------+---------------+---------------+----------------------------+----------------------------+-------------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+---------------+ | 1003 | META$1004 | META | 2026-05-26 19:45:31.876391 | 2026-05-26 19:45:43.079285 | zone1,zone2,zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.3.5.6 | 1 | NORMAL | | +-------------+---------------+---------------+----------------------------+----------------------------+-------------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+---------------+ | 1004 | patswp2 | USER | 2026-05-26 19:45:31.880838 | 2026-05-26 19:45:43.190607 | zone1,zone2,zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | 1787622710024505003 | 1787622710024505003 | 1787622710024505003 | 4611686018427387903 | NOARCHIVELOG | DISABLED | 1 | 4.3.5.6 | 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 | +=============+===============+========================================================+================+ | 1002 | patswp | patswp_zone3_1778662320: tenant_unit_1782874795680_4 | 1 unit: 1C/2G | +-------------+---------------+--------------------------------------------------------+----------------+ | 1002 | patswp | patswp_zone2_1778662320: tenant_unit_1782874795680_4 | 1 unit: 1C/2G | +-------------+---------------+--------------------------------------------------------+----------------+ | 1002 | patswp | patswp_zone1_1778662320: tenant_unit_1782874795680_4 | 1 unit: 1C/2G | +-------------+---------------+--------------------------------------------------------+----------------+ | 1004 | patswp2 | patswp2_zone1_1779795930: tenant_unit_1787561247167_16 | 1 unit: 5C/11G | +-------------+---------------+--------------------------------------------------------+----------------+ | 1004 | patswp2 | patswp2_zone2_1779795930: tenant_unit_1787561260044_26 | 1 unit: 5C/11G | +-------------+---------------+--------------------------------------------------------+----------------+ | 1004 | patswp2 | patswp2_zone3_1779795930: tenant_unit_1787561273822_36 | 1 unit: 5C/11G | +-------------+---------------+--------------------------------------------------------+----------------+ 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.19.50.8 | +---------------+-------------+------------+ | META$1002 | 1001 | 10.19.50.8 | +---------------+-------------+------------+ | patswp | 1002 | 10.19.50.8 | +---------------+-------------+------------+ | META$1004 | 1003 | 10.19.50.8 | +---------------+-------------+------------+ | patswp2 | 1004 | 10.19.50.8 | +---------------+-------------+------------+ | sys | 1 | 10.19.50.6 | +---------------+-------------+------------+ | META$1002 | 1001 | 10.19.50.6 | +---------------+-------------+------------+ | patswp | 1002 | 10.19.50.6 | +---------------+-------------+------------+ | META$1004 | 1003 | 10.19.50.6 | +---------------+-------------+------------+ | patswp2 | 1004 | 10.19.50.6 | +---------------+-------------+------------+ | sys | 1 | 10.19.50.7 | +---------------+-------------+------------+ | META$1002 | 1001 | 10.19.50.7 | +---------------+-------------+------------+ | patswp | 1002 | 10.19.50.7 | +---------------+-------------+------------+ | META$1004 | 1003 | 10.19.50.7 | +---------------+-------------+------------+ | patswp2 | 1004 | 10.19.50.7 | +---------------+-------------+------------+ 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 | +========+============+============+============+==============+=============+=========+==============================================================================================================================+===========+=========+==========+===================+=================+=============+ | zone3 | observer | 10.19.50.8 | 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.19.50.7 | 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 | +--------+------------+------------+------------+--------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone1 | observer | 10.19.50.6 | 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 | +========+============+============+============+===========================+=============+=========+==================================================================================================+===========+=========+==========+===================+=================+=============+ | zone3 | observer | 10.19.50.8 | 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 | +--------+------------+------------+------------+---------------------------+-------------+---------+--------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+-----------------+-------------+ | zone1 | observer | 10.19.50.6 | 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.19.50.7 | 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 > 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 | +===============+============+=====================+=====================+====================+=========================+==================+==============+ | META$1002 | 10.19.50.6 | 0.4 | 0.0809 | 0.0547 | 13.6719% | 0.0547 | 5 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1002 | 10.19.50.7 | 0.4 | 0.094 | 0.082 | 20.5078% | 0.082 | 3 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1002 | 10.19.50.8 | 0.4 | 0.0883 | 0.0313 | 7.8125% | 0.0313 | 4 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1004 | 10.19.50.6 | 0.44 | 0.0817 | 0.0313 | 7.1023% | 0.0313 | 5 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1004 | 10.19.50.7 | 0.44 | 0.1081 | 0.0898 | 20.4190% | 0.0898 | 3 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1004 | 10.19.50.8 | 0.44 | 0.0975 | 0.082 | 18.6435% | 0.0938 | 3 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | patswp | 10.19.50.6 | 0.4 | 0.0623 | 0.0449 | 11.2305% | 0.0449 | 2 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | patswp | 10.19.50.7 | 0.4 | 0.0704 | 0.0664 | 16.6016% | 0.0664 | 0 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | patswp | 10.19.50.8 | 0.4 | 0.0678 | 0.0605 | 15.1367% | 0.0625 | 0 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | patswp2 | 10.19.50.6 | 4.95 | 0.7672 | 0.3301 | 6.6682% | 0.332 | 2 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | patswp2 | 10.19.50.7 | 4.95 | 0.3087 | 0.1699 | 3.4328% | 0.1699 | 6 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | patswp2 | 10.19.50.8 | 4.95 | 0.8289 | 0.4375 | 8.8384% | 0.4375 | 1 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | sys | 10.19.50.6 | 1.6 | 0.3816 | 0.1934 | 12.0850% | 0.1934 | 4 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | sys | 10.19.50.7 | 1.6 | 0.3825 | 0.1523 | 9.5215% | 0.1523 | 4 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | sys | 10.19.50.8 | 1.6 | 0.3825 | 0.1543 | 9.6436% | 0.1543 | 4 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ obclient > SELECT CASE WHEN tenant_name IS NULL THEN TENANT_ID ELSE tenant_name END tenant_name, host,ctx_name, mod_name, hold, used, count FROM ( SELECT tenant_name,tenant_id,HOST,ctx_name,mod_name,hold,used,COUNT, ROW_NUMBER () OVER ( PARTITION BY tenant_name, HOST ORDER BY hold desc) rnum FROM (SELECT b.tenant_name, a.tenant_id, concat(a.svr_ip, ':', a.svr_port) HOST, a.ctx_name, a.mod_name, round(a.hold / 1024 / 1024 / 1024) hold, round(a.used / 1024 / 1024 / 1024) used, a.COUNT FROM oceanbase.__all_virtual_memory_info a LEFT JOIN oceanbase.__all_tenant b ON a.TENANT_ID = b.TENANT_ID WHERE a.hold > 1024 * 1024 * 1024 )); +---------------+-----------------+------------------+---------------+--------+--------+---------+ | tenant_name | host | ctx_name | mod_name | hold | used | count | +===============+=================+==================+===============+========+========+=========+ | patswp2 | 10.19.50.7:2882 | DEFAULT_CTX_ID | SqlExecutor | 4 | 3 | 14825 | +---------------+-----------------+------------------+---------------+--------+--------+---------+ | patswp2 | 10.19.50.7:2882 | VECTOR_CTX_ID | VIndexVsagADP | 3 | 3 | 95478 | +---------------+-----------------+------------------+---------------+--------+--------+---------+ | patswp2 | 10.19.50.8:2882 | KVSTORE_CACHE_ID | KvstorCacheMb | 4 | 0 | 2104 | +---------------+-----------------+------------------+---------------+--------+--------+---------+ | patswp2 | 10.19.50.8:2882 | VECTOR_CTX_ID | VIndexVsagADP | 3 | 3 | 95477 | +---------------+-----------------+------------------+---------------+--------+--------+---------+ | sys | 10.19.50.6:2882 | KVSTORE_CACHE_ID | KvstorCacheMb | 2 | 0 | 1229 | +---------------+-----------------+------------------+---------------+--------+--------+---------+ | patswp2 | 10.19.50.6:2882 | KVSTORE_CACHE_ID | KvstorCacheMb | 4 | 0 | 2059 | +---------------+-----------------+------------------+---------------+--------+--------+---------+ | patswp2 | 10.19.50.6:2882 | VECTOR_CTX_ID | VIndexVsagADP | 3 | 3 | 95477 | +---------------+-----------------+------------------+---------------+--------+--------+---------+