obclient > show variables like 'version_comment'; +-----------------+-------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +=================+===================================================================================================================+ | version_comment | OceanBase_CE 4.2.1.10 (r110000072024112010-28c1343085627e79a4f13c29121646bb889cf901) (Built Nov 20 2024 10:10:50) | +-----------------+-------------------------------------------------------------------------------------------------------------------+ obclient > SELECT * FROM oceanbase.DBA_OB_ZONES ORDER BY ZONE; +--------+----------------------------+----------------------------+----------+-------+------------+-----------+ | ZONE | CREATE_TIME | MODIFY_TIME | STATUS | IDC | REGION | TYPE | +========+============================+============================+==========+=======+============+===========+ | zone1 | 2025-01-21 17:03:23.646131 | 2025-01-21 17:03:23.646131 | ACTIVE | | sys_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------+------------+-----------+ | zone2 | 2025-01-21 17:03:23.646131 | 2025-01-21 17:03:23.646131 | ACTIVE | | sys_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------+------------+-----------+ | zone3 | 2025-01-21 17:03:23.646131 | 2025-01-21 17:03:23.646131 | ACTIVE | | sys_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 | +============+============+======+========+============+===================+==========+============================+=============+=========================+============================+============================+============================================================================================+============================+ | 172.20.0.3 | 2882 | 1 | zone1 | 2881 | NO | ACTIVE | 2025-04-02 17:18:50.098375 | | | 2025-01-21 17:03:25.289519 | 2025-04-02 17:18:51.310849 | 4.2.1.10_110000072024112010-28c1343085627e79a4f13c29121646bb889cf901(Nov 20 2024 10:10:50) | | +------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+--------------------------------------------------------------------------------------------+----------------------------+ | 172.20.0.4 | 2882 | 2 | zone2 | 2881 | YES | ACTIVE | 2025-04-02 17:19:06.749053 | | | 2025-01-21 17:03:25.320090 | 2025-04-02 17:19:07.386300 | 4.2.1.10_110000072024112010-28c1343085627e79a4f13c29121646bb889cf901(Nov 20 2024 10:10:50) | | +------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+--------------------------------------------------------------------------------------------+----------------------------+ | 172.20.0.5 | 2882 | 3 | zone3 | 2881 | NO | INACTIVE | | | | 2025-01-21 17:03:25.349191 | 2025-04-03 13:45:55.256147 | 4.2.1.10_110000072024112010-28c1343085627e79a4f13c29121646bb889cf901(Nov 20 2024 10:10:50) | 2025-04-03 13:45:55.252098 | +------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+--------------------------------------------------------------------------------------------+----------------------------+ 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,concat(ROUND(DATA_DISK_ALLOCATED/1024/1024/1024,0), 'G') as DATA_DISK_ALLOCATED 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 | DATA_DISK_ALLOCATED | +============+============+========+============+================+====================+================+====================+================+================+=====================+=====================+===================+======================+====================+================+=======================+ | 172.20.0.3 | 2882 | zone1 | 2881 | 6 | 6 | 6 | 6 | 8G | 7G | 50G | 19G | 16G | 50G | 1G | 10G | 50G | +------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+----------------+-----------------------+ | 172.20.0.4 | 2882 | zone2 | 2881 | 6 | 6 | 6 | 6 | 8G | 7G | 50G | 19G | 16G | 50G | 1G | 10G | 50G | +------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+----------------+-----------------------+ 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 | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT | +==================+=================+============================+============================+===========+===========+===============+=================+=====================+=====================+===============+ | 1 | sys_unit_config | 2025-01-21 17:03:23.423192 | 2025-04-02 18:01:52.930862 | 1 | 1 | 2147483648 | 2147483648 | 9223372036854775807 | 9223372036854775807 | 2 | +------------------+-----------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+---------------------+---------------------+---------------+ | 1001 | ocp_unit | 2025-01-21 17:04:19.347569 | 2025-01-23 14:53:35.139969 | 1 | 1 | 1073741824 | 2147483648 | 9223372036854775807 | 9223372036854775807 | 1 | +------------------+-----------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+---------------------+---------------------+---------------+ | 1002 | dev_ncs_user | 2025-01-22 11:34:04.357265 | 2025-04-02 18:09:39.899265 | 4 | 4 | 3221225472 | 10737418240 | 1280 | 1024 | 1 | +------------------+-----------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+---------------------+---------------------+---------------+ 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 | 2025-01-21 17:03:23.429722 | 2025-01-21 17:03:23.449756 | 1 | 1 | zone1;zone2;zone3 | FULL | +--------------------+-------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------------+----------------+ | 1001 | ocp_pool | 1002 | 2025-01-21 17:04:19.369404 | 2025-01-21 17:04:19.474193 | 1 | 1001 | zone1;zone2;zone3 | FULL | +--------------------+-------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------------+----------------+ | 1004 | dev_ncs_user_pool | 1004 | 2025-01-23 15:18:27.472007 | 2025-04-02 18:18:04.222761 | 1 | 1002 | zone1;zone2;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 | +=============+===============+===============+============================+============================+================+=============================================+=====================+======================+==========+=================+==========+===============+=====================+====================+=====================+=====================+=====================+======================+==============+==============================+============+==============+=============+ | 1 | sys | SYS | 2025-01-21 17:03:23.477820 | 2025-01-21 17:03:23.477820 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.2.1.10 | 1 | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+ | 1001 | META$1002 | META | 2025-01-21 17:04:19.464590 | 2025-01-21 17:05:00.870984 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.2.1.10 | 1 | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+ | 1002 | ocp | USER | 2025-01-21 17:04:19.469837 | 2025-01-21 17:05:01.009709 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | 1743659285792641394 | 1743659285792641394 | 1743659285691370508 | 4611686018427387903 | NOARCHIVELOG | DISABLED | 1 | 4.2.1.10 | 1003 | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+ | 1003 | META$1004 | META | 2025-01-23 15:21:17.367307 | 2025-04-02 18:35:21.025330 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.2.1.10 | 1 | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+ | 1004 | ncs_user | USER | 2025-01-23 15:21:17.385287 | 2025-04-02 18:35:21.021854 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | 1743659285768046619 | 1743659285768046619 | 1743659285768046619 | 4611686018427387903 | NOARCHIVELOG | DISABLED | 1 | 4.2.1.10 | 1004 | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+ 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 | ocp | ocp_pool: ocp_unit | 1 unit: 1C/1G | +-------------+---------------+---------------------------------+---------------+ | 1004 | ncs_user | dev_ncs_user_pool: dev_ncs_user | 1 unit: 4C/3G | +-------------+---------------+---------------------------------+---------------+ 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 | 172.20.0.4 | +---------------+-------------+------------+ | META$1002 | 1001 | 172.20.0.4 | +---------------+-------------+------------+ | ocp | 1002 | 172.20.0.4 | +---------------+-------------+------------+ | META$1004 | 1003 | 172.20.0.4 | +---------------+-------------+------------+ | ncs_user | 1004 | 172.20.0.4 | +---------------+-------------+------------+ | sys | 1 | 172.20.0.3 | +---------------+-------------+------------+ | META$1002 | 1001 | 172.20.0.3 | +---------------+-------------+------------+ | ocp | 1002 | 172.20.0.3 | +---------------+-------------+------------+ | META$1004 | 1003 | 172.20.0.3 | +---------------+-------------+------------+ | ncs_user | 1004 | 172.20.0.3 | +---------------+-------------+------------+ obclient > show parameters like '%syslog_level%'; +--------+------------+------------+------------+--------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | +========+============+============+============+==============+=============+=========+==============================================================================================================================+===========+=========+==========+===================+ | zone2 | observer | 172.20.0.4 | 2882 | syslog_level | | 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 | +--------+------------+------------+------------+--------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+ | zone1 | observer | 172.20.0.3 | 2882 | syslog_level | | 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 | +--------+------------+------------+------------+--------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+ 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 | +========+============+============+============+===========================+=============+=========+==================================================================================================+===========+=========+==========+===================+ | zone2 | observer | 172.20.0.4 | 2882 | syslog_io_bandwidth_limit | | 30MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+------------+------------+---------------------------+-------------+---------+--------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+ | zone1 | observer | 172.20.0.3 | 2882 | syslog_io_bandwidth_limit | | 30MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+------------+------------+---------------------------+-------------+---------+--------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+ 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 | 172.20.0.3 | 0.25 | 0.0574 | 0.0352 | 14.0625% | 0.0352 | 13 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1002 | 172.20.0.4 | 0.25 | 0.0607 | 0.041 | 16.4063% | 0.041 | 9 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1004 | 172.20.0.3 | 0.5 | 0.1313 | 0.1016 | 20.3125% | 0.1016 | 3 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | META$1004 | 172.20.0.4 | 0.5 | 0.1313 | 0.0996 | 19.9219% | 0.0996 | 3 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | ncs_user | 172.20.0.3 | 1 | 0.325 | 0.1211 | 12.1094% | 0.1211 | 0 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | ncs_user | 172.20.0.4 | 1 | 0.325 | 0.125 | 12.5000% | 0.125 | 0 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | ocp | 172.20.0.3 | 0.5 | 0.109 | 0.0332 | 6.6406% | 0.0332 | 0 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | ocp | 172.20.0.4 | 0.5 | 0.1066 | 0.0332 | 6.6406% | 0.0332 | 0 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | sys | 172.20.0.3 | 1 | 0.2313 | 0.1387 | 13.8672% | 0.1387 | 2 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ | sys | 172.20.0.4 | 1 | 0.2313 | 0.1348 | 13.4766% | 0.1348 | 1 | +---------------+------------+---------------------+---------------------+--------------------+-------------------------+------------------+--------------+ 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 | +===============+========+============+============+========+========+=========+ +---------------+--------+------------+------------+--------+--------+---------+