MySQL [oceanbase]> select tenant_id,tenant_name from dba_ob_tenants; +-----------+-------------+ | tenant_id | tenant_name | +-----------+-------------+ | 1 | sys | | 1093 | META$1094 | | 1094 | dg1 | | 1097 | META$1098 | | 1098 | dg2 | | 1099 | META$1100 | | 1100 | dg3 | +-----------+-------------+ 7 rows in set (0.02 sec) MySQL [oceanbase]> select gmt_create, name2, value2, name3, value3, rs_svr_ip, rs_svr_port, timestampdiff(SECOND, gmt_create, lead(gmt_create) over (order by gmt_create)) as cost from __all_rootservice_event_history where module like 'physical_restore' and event like 'change_restore_status' and value1=3 order by gmt_create; Empty set (0.08 sec) MySQL [oceanbase]> select count(*),zone from cdb_ob_table_locations where TENANT_ID=1094 group by zone; +----------+-------+ | count(*) | zone | +----------+-------+ | 786 | zone3 | | 786 | zone2 | | 786 | zone1 | +----------+-------+ 3 rows in set (0.89 sec) MySQL [oceanbase]> MySQL [oceanbase]> select gmt_create, svr_ip, svr_port, name2, value2, name3, value3, name4, value4, name5, value5, name6, value6 from __all_server_event_history where event like 'restore_ls' and value1=1094 and cast(value3 as unsigned)<7 order by cast(value2 as unsigned), svr_ip, svr_port, cast(value3 as unsigned); +----------------------------+------------+----------+-------+--------+-------------+--------+-------------+--------+-----------------+---------------------------+-----------------+--------------------------------+ | gmt_create | svr_ip | svr_port | name2 | value2 | name3 | value3 | name4 | value4 | name5 | value5 | name6 | value6 | +----------------------------+------------+----------+-------+--------+-------------+--------+-------------+--------+-----------------+---------------------------+-----------------+--------------------------------+ | 2026-01-08 07:49:51.976166 | 10.10.1.74 | 2882 | ls_id | 1 | curr_status | 1 | next_status | 2 | curr_status_str | RESTORE_START | next_status_str | RESTORE_SYS_TABLETS | | 2026-01-08 08:02:34.173008 | 10.10.1.74 | 2882 | ls_id | 1 | curr_status | 2 | next_status | 3 | curr_status_str | RESTORE_SYS_TABLETS | next_status_str | WAIT_RESTORE_SYS_TABLETS | | 2026-01-08 08:02:34.473231 | 10.10.1.74 | 2882 | ls_id | 1 | curr_status | 3 | next_status | 4 | curr_status_str | WAIT_RESTORE_SYS_TABLETS | next_status_str | RESTORE_TABLETS_META | | 2026-01-08 08:02:34.766328 | 10.10.1.74 | 2882 | ls_id | 1 | curr_status | 4 | next_status | 5 | curr_status_str | RESTORE_TABLETS_META | next_status_str | WAIT_RESTORE_TABLETS_META | | 2026-01-08 08:03:00.249500 | 10.10.1.74 | 2882 | ls_id | 1 | curr_status | 5 | next_status | 6 | curr_status_str | WAIT_RESTORE_TABLETS_META | next_status_str | RESTORE_TO_CONSISTENT_SCN | | 2026-01-08 08:03:05.494816 | 10.10.1.74 | 2882 | ls_id | 1 | curr_status | 6 | next_status | 7 | curr_status_str | RESTORE_TO_CONSISTENT_SCN | next_status_str | WAIT_RESTORE_TO_CONSISTENT_SCN | | 2026-01-08 07:49:52.875994 | 10.10.1.75 | 2882 | ls_id | 1 | curr_status | 1 | next_status | 2 | curr_status_str | RESTORE_START | next_status_str | RESTORE_SYS_TABLETS | | 2026-01-08 08:02:52.742287 | 10.10.1.75 | 2882 | ls_id | 1 | curr_status | 2 | next_status | 3 | curr_status_str | RESTORE_SYS_TABLETS | next_status_str | WAIT_RESTORE_SYS_TABLETS | | 2026-01-08 08:02:52.859426 | 10.10.1.75 | 2882 | ls_id | 1 | curr_status | 3 | next_status | 4 | curr_status_str | WAIT_RESTORE_SYS_TABLETS | next_status_str | RESTORE_TABLETS_META | | 2026-01-08 08:02:52.919136 | 10.10.1.75 | 2882 | ls_id | 1 | curr_status | 4 | next_status | 5 | curr_status_str | RESTORE_TABLETS_META | next_status_str | WAIT_RESTORE_TABLETS_META | | 2026-01-08 08:03:01.132187 | 10.10.1.75 | 2882 | ls_id | 1 | curr_status | 5 | next_status | 6 | curr_status_str | WAIT_RESTORE_TABLETS_META | next_status_str | RESTORE_TO_CONSISTENT_SCN | | 2026-01-08 08:03:05.369015 | 10.10.1.75 | 2882 | ls_id | 1 | curr_status | 6 | next_status | 7 | curr_status_str | RESTORE_TO_CONSISTENT_SCN | next_status_str | WAIT_RESTORE_TO_CONSISTENT_SCN | | 2026-01-08 07:49:52.832924 | 10.10.1.76 | 2882 | ls_id | 1 | curr_status | 1 | next_status | 2 | curr_status_str | RESTORE_START | next_status_str | RESTORE_SYS_TABLETS | | 2026-01-08 08:02:58.996508 | 10.10.1.76 | 2882 | ls_id | 1 | curr_status | 2 | next_status | 3 | curr_status_str | RESTORE_SYS_TABLETS | next_status_str | WAIT_RESTORE_SYS_TABLETS | | 2026-01-08 08:02:59.060099 | 10.10.1.76 | 2882 | ls_id | 1 | curr_status | 3 | next_status | 4 | curr_status_str | WAIT_RESTORE_SYS_TABLETS | next_status_str | RESTORE_TABLETS_META | | 2026-01-08 08:02:59.091650 | 10.10.1.76 | 2882 | ls_id | 1 | curr_status | 4 | next_status | 5 | curr_status_str | RESTORE_TABLETS_META | next_status_str | WAIT_RESTORE_TABLETS_META | | 2026-01-08 08:03:01.324151 | 10.10.1.76 | 2882 | ls_id | 1 | curr_status | 5 | next_status | 6 | curr_status_str | WAIT_RESTORE_TABLETS_META | next_status_str | RESTORE_TO_CONSISTENT_SCN | | 2026-01-08 08:03:05.505674 | 10.10.1.76 | 2882 | ls_id | 1 | curr_status | 6 | next_status | 7 | curr_status_str | RESTORE_TO_CONSISTENT_SCN | next_status_str | WAIT_RESTORE_TO_CONSISTENT_SCN | | 2026-01-08 07:49:59.198047 | 10.10.1.74 | 2882 | ls_id | 1001 | curr_status | 1 | next_status | 2 | curr_status_str | RESTORE_START | next_status_str | RESTORE_SYS_TABLETS | | 2026-01-08 07:50:49.592252 | 10.10.1.74 | 2882 | ls_id | 1001 | curr_status | 2 | next_status | 3 | curr_status_str | RESTORE_SYS_TABLETS | next_status_str | WAIT_RESTORE_SYS_TABLETS | | 2026-01-08 07:50:50.495628 | 10.10.1.74 | 2882 | ls_id | 1001 | curr_status | 3 | next_status | 4 | curr_status_str | WAIT_RESTORE_SYS_TABLETS | next_status_str | RESTORE_TABLETS_META | | 2026-01-08 07:50:51.398904 | 10.10.1.74 | 2882 | ls_id | 1001 | curr_status | 4 | next_status | 5 | curr_status_str | RESTORE_TABLETS_META | next_status_str | WAIT_RESTORE_TABLETS_META | | 2026-01-08 07:50:52.604373 | 10.10.1.74 | 2882 | ls_id | 1001 | curr_status | 5 | next_status | 6 | curr_status_str | WAIT_RESTORE_TABLETS_META | next_status_str | RESTORE_TO_CONSISTENT_SCN | | 2026-01-08 08:03:05.780215 | 10.10.1.74 | 2882 | ls_id | 1001 | curr_status | 6 | next_status | 7 | curr_status_str | RESTORE_TO_CONSISTENT_SCN | next_status_str | WAIT_RESTORE_TO_CONSISTENT_SCN | | 2026-01-08 07:49:58.144666 | 10.10.1.75 | 2882 | ls_id | 1001 | curr_status | 1 | next_status | 2 | curr_status_str | RESTORE_START | next_status_str | RESTORE_SYS_TABLETS | | 2026-01-08 07:50:51.667560 | 10.10.1.75 | 2882 | ls_id | 1001 | curr_status | 2 | next_status | 3 | curr_status_str | RESTORE_SYS_TABLETS | next_status_str | WAIT_RESTORE_SYS_TABLETS | | 2026-01-08 07:50:51.724757 | 10.10.1.75 | 2882 | ls_id | 1001 | curr_status | 3 | next_status | 4 | curr_status_str | WAIT_RESTORE_SYS_TABLETS | next_status_str | RESTORE_TABLETS_META | | 2026-01-08 07:50:51.775421 | 10.10.1.75 | 2882 | ls_id | 1001 | curr_status | 4 | next_status | 5 | curr_status_str | RESTORE_TABLETS_META | next_status_str | WAIT_RESTORE_TABLETS_META | | 2026-01-08 07:50:52.850137 | 10.10.1.75 | 2882 | ls_id | 1001 | curr_status | 5 | next_status | 6 | curr_status_str | WAIT_RESTORE_TABLETS_META | next_status_str | RESTORE_TO_CONSISTENT_SCN | | 2026-01-08 08:03:05.416588 | 10.10.1.75 | 2882 | ls_id | 1001 | curr_status | 6 | next_status | 7 | curr_status_str | RESTORE_TO_CONSISTENT_SCN | next_status_str | WAIT_RESTORE_TO_CONSISTENT_SCN | | 2026-01-08 07:49:58.173906 | 10.10.1.76 | 2882 | ls_id | 1001 | curr_status | 1 | next_status | 2 | curr_status_str | RESTORE_START | next_status_str | RESTORE_SYS_TABLETS | | 2026-01-08 07:50:51.906042 | 10.10.1.76 | 2882 | ls_id | 1001 | curr_status | 2 | next_status | 3 | curr_status_str | RESTORE_SYS_TABLETS | next_status_str | WAIT_RESTORE_SYS_TABLETS | | 2026-01-08 07:50:51.946766 | 10.10.1.76 | 2882 | ls_id | 1001 | curr_status | 3 | next_status | 4 | curr_status_str | WAIT_RESTORE_SYS_TABLETS | next_status_str | RESTORE_TABLETS_META | | 2026-01-08 07:50:52.010142 | 10.10.1.76 | 2882 | ls_id | 1001 | curr_status | 4 | next_status | 5 | curr_status_str | RESTORE_TABLETS_META | next_status_str | WAIT_RESTORE_TABLETS_META | | 2026-01-08 07:50:53.079267 | 10.10.1.76 | 2882 | ls_id | 1001 | curr_status | 5 | next_status | 6 | curr_status_str | WAIT_RESTORE_TABLETS_META | next_status_str | RESTORE_TO_CONSISTENT_SCN | | 2026-01-08 08:03:05.476705 | 10.10.1.76 | 2882 | ls_id | 1001 | curr_status | 6 | next_status | 7 | curr_status_str | RESTORE_TO_CONSISTENT_SCN | next_status_str | WAIT_RESTORE_TO_CONSISTENT_SCN | +----------------------------+------------+----------+-------+--------+-------------+--------+-------------+--------+-----------------+---------------------------+-----------------+--------------------------------+ 36 rows in set (0.68 sec) MySQL [oceanbase]> select gmt_create, svr_ip, svr_port, name2, value2, name3, value3, name4, value4, name5, value5, name6, value6 from __all_server_event_history where event like 'restore_ls' and value1=1094 and cast(value3 as unsigned)>=7 order by cast(value2 as unsigned), svr_ip, svr_port, cast(value3 as unsigned); +----------------------------+------------+----------+-------+--------+-------------+--------+-------------+--------+-----------------+--------------------------------+-----------------+-------------------------+ | gmt_create | svr_ip | svr_port | name2 | value2 | name3 | value3 | name4 | value4 | name5 | value5 | name6 | value6 | +----------------------------+------------+----------+-------+--------+-------------+--------+-------------+--------+-----------------+--------------------------------+-----------------+-------------------------+ | 2026-01-08 08:03:07.252424 | 10.10.1.74 | 2882 | ls_id | 1 | curr_status | 7 | next_status | 8 | curr_status_str | WAIT_RESTORE_TO_CONSISTENT_SCN | next_status_str | QUICK_RESTORE | | 2026-01-08 08:57:44.346328 | 10.10.1.74 | 2882 | ls_id | 1 | curr_status | 8 | next_status | 9 | curr_status_str | QUICK_RESTORE | next_status_str | WAIT_QUICK_RESTORE | | 2026-01-08 08:58:06.975707 | 10.10.1.74 | 2882 | ls_id | 1 | curr_status | 9 | next_status | 11 | curr_status_str | WAIT_QUICK_RESTORE | next_status_str | RESTORE_MAJOR_DATA | | 2026-01-08 08:58:07.273725 | 10.10.1.74 | 2882 | ls_id | 1 | curr_status | 11 | next_status | 12 | curr_status_str | RESTORE_MAJOR_DATA | next_status_str | WAIT_RESTORE_MAJOR_DATA | | 2026-01-08 08:58:08.479932 | 10.10.1.74 | 2882 | ls_id | 1 | curr_status | 12 | next_status | 0 | curr_status_str | WAIT_RESTORE_MAJOR_DATA | next_status_str | NONE | | 2026-01-08 08:03:06.525252 | 10.10.1.75 | 2882 | ls_id | 1 | curr_status | 7 | next_status | 8 | curr_status_str | WAIT_RESTORE_TO_CONSISTENT_SCN | next_status_str | QUICK_RESTORE | | 2026-01-08 08:03:52.077797 | 10.10.1.75 | 2882 | ls_id | 1 | curr_status | 8 | next_status | 9 | curr_status_str | QUICK_RESTORE | next_status_str | WAIT_QUICK_RESTORE | | 2026-01-08 08:58:06.955255 | 10.10.1.75 | 2882 | ls_id | 1 | curr_status | 9 | next_status | 11 | curr_status_str | WAIT_QUICK_RESTORE | next_status_str | RESTORE_MAJOR_DATA | | 2026-01-08 08:58:07.212814 | 10.10.1.75 | 2882 | ls_id | 1 | curr_status | 11 | next_status | 12 | curr_status_str | RESTORE_MAJOR_DATA | next_status_str | WAIT_RESTORE_MAJOR_DATA | | 2026-01-08 08:58:07.414143 | 10.10.1.75 | 2882 | ls_id | 1 | curr_status | 12 | next_status | 0 | curr_status_str | WAIT_RESTORE_MAJOR_DATA | next_status_str | NONE | | 2026-01-08 08:03:06.626691 | 10.10.1.76 | 2882 | ls_id | 1 | curr_status | 7 | next_status | 8 | curr_status_str | WAIT_RESTORE_TO_CONSISTENT_SCN | next_status_str | QUICK_RESTORE | | 2026-01-08 08:04:08.455755 | 10.10.1.76 | 2882 | ls_id | 1 | curr_status | 8 | next_status | 9 | curr_status_str | QUICK_RESTORE | next_status_str | WAIT_QUICK_RESTORE | | 2026-01-08 08:58:07.064555 | 10.10.1.76 | 2882 | ls_id | 1 | curr_status | 9 | next_status | 11 | curr_status_str | WAIT_QUICK_RESTORE | next_status_str | RESTORE_MAJOR_DATA | | 2026-01-08 08:58:07.302040 | 10.10.1.76 | 2882 | ls_id | 1 | curr_status | 11 | next_status | 12 | curr_status_str | RESTORE_MAJOR_DATA | next_status_str | WAIT_RESTORE_MAJOR_DATA | | 2026-01-08 08:58:07.451147 | 10.10.1.76 | 2882 | ls_id | 1 | curr_status | 12 | next_status | 0 | curr_status_str | WAIT_RESTORE_MAJOR_DATA | next_status_str | NONE | | 2026-01-08 08:03:07.553885 | 10.10.1.74 | 2882 | ls_id | 1001 | curr_status | 7 | next_status | 8 | curr_status_str | WAIT_RESTORE_TO_CONSISTENT_SCN | next_status_str | QUICK_RESTORE | | 2026-01-08 08:03:16.917629 | 10.10.1.74 | 2882 | ls_id | 1001 | curr_status | 8 | next_status | 9 | curr_status_str | QUICK_RESTORE | next_status_str | WAIT_QUICK_RESTORE | | 2026-01-08 08:58:06.686457 | 10.10.1.74 | 2882 | ls_id | 1001 | curr_status | 9 | next_status | 11 | curr_status_str | WAIT_QUICK_RESTORE | next_status_str | RESTORE_MAJOR_DATA | | 2026-01-08 08:58:07.574671 | 10.10.1.74 | 2882 | ls_id | 1001 | curr_status | 11 | next_status | 12 | curr_status_str | RESTORE_MAJOR_DATA | next_status_str | WAIT_RESTORE_MAJOR_DATA | | 2026-01-08 08:58:09.080376 | 10.10.1.74 | 2882 | ls_id | 1001 | curr_status | 12 | next_status | 0 | curr_status_str | WAIT_RESTORE_MAJOR_DATA | next_status_str | NONE | | 2026-01-08 08:03:06.605877 | 10.10.1.75 | 2882 | ls_id | 1001 | curr_status | 7 | next_status | 8 | curr_status_str | WAIT_RESTORE_TO_CONSISTENT_SCN | next_status_str | QUICK_RESTORE | | 2026-01-08 08:03:07.789073 | 10.10.1.75 | 2882 | ls_id | 1001 | curr_status | 8 | next_status | 9 | curr_status_str | QUICK_RESTORE | next_status_str | WAIT_QUICK_RESTORE | | 2026-01-08 08:58:07.037407 | 10.10.1.75 | 2882 | ls_id | 1001 | curr_status | 9 | next_status | 11 | curr_status_str | WAIT_QUICK_RESTORE | next_status_str | RESTORE_MAJOR_DATA | | 2026-01-08 08:58:07.134102 | 10.10.1.75 | 2882 | ls_id | 1001 | curr_status | 11 | next_status | 12 | curr_status_str | RESTORE_MAJOR_DATA | next_status_str | WAIT_RESTORE_MAJOR_DATA | | 2026-01-08 08:58:07.304825 | 10.10.1.75 | 2882 | ls_id | 1001 | curr_status | 12 | next_status | 0 | curr_status_str | WAIT_RESTORE_MAJOR_DATA | next_status_str | NONE | | 2026-01-08 08:03:06.708404 | 10.10.1.76 | 2882 | ls_id | 1001 | curr_status | 7 | next_status | 8 | curr_status_str | WAIT_RESTORE_TO_CONSISTENT_SCN | next_status_str | QUICK_RESTORE | | 2026-01-08 08:03:07.933334 | 10.10.1.76 | 2882 | ls_id | 1001 | curr_status | 8 | next_status | 9 | curr_status_str | QUICK_RESTORE | next_status_str | WAIT_QUICK_RESTORE | | 2026-01-08 08:58:07.136007 | 10.10.1.76 | 2882 | ls_id | 1001 | curr_status | 9 | next_status | 11 | curr_status_str | WAIT_QUICK_RESTORE | next_status_str | RESTORE_MAJOR_DATA | | 2026-01-08 08:58:07.212059 | 10.10.1.76 | 2882 | ls_id | 1001 | curr_status | 11 | next_status | 12 | curr_status_str | RESTORE_MAJOR_DATA | next_status_str | WAIT_RESTORE_MAJOR_DATA | | 2026-01-08 08:58:07.400566 | 10.10.1.76 | 2882 | ls_id | 1001 | curr_status | 12 | next_status | 0 | curr_status_str | WAIT_RESTORE_MAJOR_DATA | next_status_str | NONE | +----------------------------+------------+----------+-------+--------+-------------+--------+-------------+--------+-----------------+--------------------------------+-----------------+-------------------------+ 30 rows in set (0.05 sec) MySQL [oceanbase]> SELECT c.TENANT_ID, e.TENANT_NAME, f.SVR_IP,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 DBA_OB_RESOURCE_POOLS c, DBA_OB_UNIT_CONFIGS d, DBA_OB_TENANTS e ,DBA_OB_UNITS f WHERE c.UNIT_CONFIG_ID=d.UNIT_CONFIG_ID AND c.TENANT_ID=e.TENANT_ID AND e.TENANT_ID=f.TENANT_ID AND c.RESOURCE_POOL_ID=f.RESOURCE_POOL_ID ORDER BY c.TENANT_ID; +-----------+-------------+------------+---------------------------+---------------+ | TENANT_ID | TENANT_NAME | SVR_IP | pool:conf | unit_info | +-----------+-------------+------------+---------------------------+---------------+ | 1 | sys | 10.10.1.74 | sys_pool: sys_unit_config | 1 unit: 4C/5G | | 1 | sys | 10.10.1.75 | sys_pool: sys_unit_config | 1 unit: 4C/5G | | 1 | sys | 10.10.1.76 | sys_pool: sys_unit_config | 1 unit: 4C/5G | | 1094 | dg1 | 10.10.1.74 | pool_1: unit_4c8g | 1 unit: 4C/8G | | 1094 | dg1 | 10.10.1.75 | pool_1: unit_4c8g | 1 unit: 4C/8G | | 1094 | dg1 | 10.10.1.76 | pool_1: unit_4c8g | 1 unit: 4C/8G | | 1098 | dg2 | 10.10.1.74 | pool_2: unit_4c8g | 1 unit: 4C/8G | | 1098 | dg2 | 10.10.1.75 | pool_2: unit_4c8g | 1 unit: 4C/8G | | 1098 | dg2 | 10.10.1.76 | pool_2: unit_4c8g | 1 unit: 4C/8G | | 1100 | dg3 | 10.10.1.74 | pool_3: unit_3c6g | 1 unit: 3C/6G | | 1100 | dg3 | 10.10.1.75 | pool_3: unit_3c6g | 1 unit: 3C/6G | | 1100 | dg3 | 10.10.1.76 | pool_3: unit_3c6g | 1 unit: 3C/6G | +-----------+-------------+------------+---------------------------+---------------+ 12 rows in set (0.05 sec) MySQL [oceanbase]> select * from GV$OB_PARAMETERS where name like '%__min_full_resource_pool_memory%'\G; *************************** 1. row *************************** SVR_IP: 10.10.1.74 SVR_PORT: 2882 ZONE: zone1 SCOPE: CLUSTER TENANT_ID: NULL NAME: __min_full_resource_pool_memory DATA_TYPE: INT VALUE: 1073741824 INFO: the min memory value which is specified for a full resource pool. SECTION: LOAD_BALANCE EDIT_LEVEL: DYNAMIC_EFFECTIVE DEFAULT_VALUE: 5368709120 ISDEFAULT: NO *************************** 2. row *************************** SVR_IP: 10.10.1.75 SVR_PORT: 2882 ZONE: zone2 SCOPE: CLUSTER TENANT_ID: NULL NAME: __min_full_resource_pool_memory DATA_TYPE: INT VALUE: 1073741824 INFO: the min memory value which is specified for a full resource pool. SECTION: LOAD_BALANCE EDIT_LEVEL: DYNAMIC_EFFECTIVE DEFAULT_VALUE: 5368709120 ISDEFAULT: NO *************************** 3. row *************************** SVR_IP: 10.10.1.76 SVR_PORT: 2882 ZONE: zone3 SCOPE: CLUSTER TENANT_ID: NULL NAME: __min_full_resource_pool_memory DATA_TYPE: INT VALUE: 1073741824 INFO: the min memory value which is specified for a full resource pool. SECTION: LOAD_BALANCE EDIT_LEVEL: DYNAMIC_EFFECTIVE DEFAULT_VALUE: 5368709120 ISDEFAULT: NO 3 rows in set (0.03 sec) ERROR: No query specified MySQL [oceanbase]> show parameters like 'memory_limit'\G; *************************** 1. row *************************** zone: zone1 svr_type: observer svr_ip: 10.10.1.74 svr_port: 2882 name: memory_limit data_type: CAPACITY value: 35G info: the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0M isdefault: 0 *************************** 2. row *************************** zone: zone2 svr_type: observer svr_ip: 10.10.1.75 svr_port: 2882 name: memory_limit data_type: CAPACITY value: 35G info: the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0M isdefault: 0 *************************** 3. row *************************** zone: zone3 svr_type: observer svr_ip: 10.10.1.76 svr_port: 2882 name: memory_limit data_type: CAPACITY value: 35G info: the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE default_value: 0M isdefault: 0 3 rows in set (0.03 sec) ERROR: No query specified MySQL [oceanbase]> SELECT -> gmt_create AS event_time, -> module, -> event, -> name1, value1, -> name2, value2, -> name3, value3, -> name4, value4, -> name5, value5, -> name6, value6, -> extra_info -> FROM oceanbase.__all_rootservice_event_history -> WHERE module IN ('unit', 'resource_pool', 'tenant') -> AND event LIKE '%unit%' -> OR event LIKE '%resource%' -> OR event LIKE '%alter%' -> ORDER BY gmt_create DESC -> LIMIT 100; +----------------------------+--------------+----------------------+---------+-----------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+--------+-------+--------+------------+ | event_time | module | event | name1 | value1 | name2 | value2 | name3 | value3 | name4 | value4 | name5 | value5 | name6 | value6 | extra_info | +----------------------------+--------------+----------------------+---------+-----------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+--------+-------+--------+------------+ | 2026-01-08 08:50:57.786078 | root_service | create_resource_pool | ret | 0 | arg | pool_name:"pool_3", unit:"unit_3c6g", unit_num:1, zone_list:["zone1", "zone2", "zone3"], replica_type:0, if_not_exist:false | | | | | | | | | | | 2026-01-08 08:50:57.785963 | unit | create_resource_pool | name | pool_3 | unit | unit_3c6g | zone_list | [..., "zone3"] | source_tenant_id | 0 | | | | | | | 2026-01-08 08:50:57.782732 | unit | create_unit | unit_id | 1045 | server | "10.10.1.76:2882" | | | | | | | | | | | 2026-01-08 08:50:57.761918 | unit | create_unit | unit_id | 1044 | server | "10.10.1.75:2882" | | | | | | | | | | | 2026-01-08 08:50:57.747489 | unit | create_unit | unit_id | 1043 | server | "10.10.1.74:2882" | | | | | | | | | | | 2026-01-08 08:50:30.508360 | root_service | create_resource_pool | ret | -4733 | arg | pool_name:"pool_3", unit:"unit_4c8g", unit_num:1, zone_list:["zone1", "zone2", "zone3"], replica_type:0, if_not_exist:false | | | | | | | | | | | 2026-01-08 08:49:34.101652 | root_service | create_resource_pool | ret | 0 | arg | pool_name:"pool_2", unit:"unit_4c8g", unit_num:1, zone_list:["zone1", "zone2", "zone3"], replica_type:0, if_not_exist:false | | | | | | | | | | | 2026-01-08 08:49:34.101567 | unit | create_resource_pool | name | pool_2 | unit | unit_4c8g | zone_list | [..., "zone3"] | source_tenant_id | 0 | | | | | | | 2026-01-08 08:49:34.061549 | unit | create_unit | unit_id | 1042 | server | "10.10.1.76:2882" | | | | | | | | | | | 2026-01-08 08:49:34.028152 | unit | create_unit | unit_id | 1041 | server | "10.10.1.75:2882" | | | | | | | | | | | 2026-01-08 08:49:34.004166 | unit | create_unit | unit_id | 1040 | server | "10.10.1.74:2882" | | | | | | | | | | | 2026-01-08 08:48:05.917558 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_2", if_exist:true, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-08 08:48:05.915153 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_2", if_exist:true, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-08 08:48:05.911092 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_2", if_exist:true, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-08 08:48:05.911050 | unit | drop_resource_pool | name | pool_2 | | | | | | | | | | | | | 2026-01-08 08:48:05.910969 | unit | drop_unit | unit_id | 1039 | | | | | | | | | | | | | 2026-01-08 08:48:05.910930 | unit | drop_unit | unit_id | 1038 | | | | | | | | | | | | | 2026-01-08 08:48:05.910845 | unit | drop_unit | unit_id | 1037 | | | | | | | | | | | | | 2026-01-08 08:48:05.862796 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_3", if_exist:true, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-08 08:48:05.859590 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_3", if_exist:true, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-08 08:48:05.854667 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_3", if_exist:true, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-08 08:48:05.854619 | unit | drop_resource_pool | name | pool_3 | | | | | | | | | | | | | 2026-01-08 08:48:05.854563 | unit | drop_unit | unit_id | 1030 | | | | | | | | | | | | | 2026-01-08 08:48:05.854524 | unit | drop_unit | unit_id | 1029 | | | | | | | | | | | | | 2026-01-08 08:48:05.854401 | unit | drop_unit | unit_id | 1028 | | | | | | | | | | | | | 2026-01-07 17:09:28.418876 | root_service | alter_resource_unit | ret | 0 | arg | {unit_config:{unit_config_id:18446744073709551615, name:"sys_unit_config", resource:{min_cpu:4, max_cpu:4, memory_size:"0GB", log_disk_size:-1, data_disk_size:-1, min_iops:0, max_iops:0, iops_weight:-1, max_net_bandwidth:"0GB", net_bandwidth_weight:-1, }}} | | | | | | | | | | | 2026-01-07 17:09:28.418711 | unit | alter_resource_unit | name | sys_unit_config | unit_config_id | 1 | old_resource | {min_cpu:3, max_cpu:3, memory_size:"5GB", log_disk_size:"4GB", data_disk_size:0, min_iops:9223372036854775807, max_iops:9223372036854775807, iops_weight:3, max_net_bandwidth:INT64_MAX, net_bandwidth_weight:3, } | new_resource | {min_cpu:4, max_cpu:4, memory_size:"5GB", log_disk_size:"4GB", data_disk_size:0, min_iops:9223372036854775807, max_iops:9223372036854775807, iops_weight:3, max_net_bandwidth:INT64_MAX, net_bandwidth_weight:3, } | | | | | | | 2026-01-07 17:08:27.072637 | root_service | alter_resource_unit | ret | 0 | arg | {unit_config:{unit_config_id:18446744073709551615, name:"sys_unit_config", resource:{min_cpu:0, max_cpu:0, memory_size:"5GB", log_disk_size:-1, data_disk_size:-1, min_iops:0, max_iops:0, iops_weight:-1, max_net_bandwidth:"0GB", net_bandwidth_weight:-1, }}} | | | | | | | | | | | 2026-01-07 17:08:27.072495 | unit | alter_resource_unit | name | sys_unit_config | unit_config_id | 1 | old_resource | {min_cpu:3, max_cpu:3, memory_size:"2GB", log_disk_size:"4GB", data_disk_size:0, min_iops:9223372036854775807, max_iops:9223372036854775807, iops_weight:3, max_net_bandwidth:INT64_MAX, net_bandwidth_weight:3, } | new_resource | {min_cpu:3, max_cpu:3, memory_size:"5GB", log_disk_size:"4GB", data_disk_size:0, min_iops:9223372036854775807, max_iops:9223372036854775807, iops_weight:3, max_net_bandwidth:INT64_MAX, net_bandwidth_weight:3, } | | | | | | | 2026-01-07 16:51:45.278526 | root_service | alter_resource_unit | ret | 0 | arg | {unit_config:{unit_config_id:18446744073709551615, name:"sys_unit_config", resource:{min_cpu:0, max_cpu:0, memory_size:"2GB", log_disk_size:-1, data_disk_size:-1, min_iops:0, max_iops:0, iops_weight:-1, max_net_bandwidth:"0GB", net_bandwidth_weight:-1, }}} | | | | | | | | | | | 2026-01-07 16:51:45.278356 | unit | alter_resource_unit | name | sys_unit_config | unit_config_id | 1 | old_resource | {min_cpu:3, max_cpu:3, memory_size:"1GB", log_disk_size:"4GB", data_disk_size:0, min_iops:9223372036854775807, max_iops:9223372036854775807, iops_weight:3, max_net_bandwidth:INT64_MAX, net_bandwidth_weight:3, } | new_resource | {min_cpu:3, max_cpu:3, memory_size:"2GB", log_disk_size:"4GB", data_disk_size:0, min_iops:9223372036854775807, max_iops:9223372036854775807, iops_weight:3, max_net_bandwidth:INT64_MAX, net_bandwidth_weight:3, } | | | | | | | 2026-01-07 16:35:19.527055 | root_service | create_resource_pool | ret | 0 | arg | pool_name:"pool_2", unit:"unit_4c8g", unit_num:1, zone_list:["zone1", "zone2", "zone3"], replica_type:0, if_not_exist:false | | | | | | | | | | | 2026-01-07 16:35:19.526904 | unit | create_resource_pool | name | pool_2 | unit | unit_4c8g | zone_list | [..., "zone3"] | source_tenant_id | 0 | | | | | | | 2026-01-07 16:35:19.516766 | unit | create_unit | unit_id | 1039 | server | "10.10.1.76:2882" | | | | | | | | | | | 2026-01-07 16:35:19.500714 | unit | create_unit | unit_id | 1038 | server | "10.10.1.75:2882" | | | | | | | | | | | 2026-01-07 16:35:19.490942 | unit | create_unit | unit_id | 1037 | server | "10.10.1.74:2882" | | | | | | | | | | | 2026-01-07 16:35:19.458553 | root_service | create_resource_pool | ret | 0 | arg | pool_name:"pool_1", unit:"unit_4c8g", unit_num:1, zone_list:["zone1", "zone2", "zone3"], replica_type:0, if_not_exist:false | | | | | | | | | | | 2026-01-07 16:35:19.458359 | unit | create_resource_pool | name | pool_1 | unit | unit_4c8g | zone_list | [..., "zone3"] | source_tenant_id | 0 | | | | | | | 2026-01-07 16:35:19.437094 | unit | create_unit | unit_id | 1036 | server | "10.10.1.76:2882" | | | | | | | | | | | 2026-01-07 16:35:19.427881 | unit | create_unit | unit_id | 1035 | server | "10.10.1.75:2882" | | | | | | | | | | | 2026-01-07 16:35:19.385541 | unit | create_unit | unit_id | 1034 | server | "10.10.1.74:2882" | | | | | | | | | | | 2026-01-07 16:35:06.824311 | root_service | create_resource_unit | ret | -4649 | arg | {if_not_exist:false, unit_config:{unit_config_id:18446744073709551615, name:"unit_4c8g", resource:{min_cpu:4, max_cpu:4, memory_size:"8GB", log_disk_size:-1, data_disk_size:-1, min_iops:10000, max_iops:10000, iops_weight:-1, max_net_bandwidth:"0GB", net_bandwidth_weight:-1, }}} | | | | | | | | | | | 2026-01-07 16:34:45.618781 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_2", if_exist:false, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-07 16:34:45.618717 | unit | drop_resource_pool | name | pool_2 | | | | | | | | | | | | | 2026-01-07 16:34:45.618673 | unit | drop_unit | unit_id | 1027 | | | | | | | | | | | | | 2026-01-07 16:34:45.618638 | unit | drop_unit | unit_id | 1026 | | | | | | | | | | | | | 2026-01-07 16:34:45.618559 | unit | drop_unit | unit_id | 1025 | | | | | | | | | | | | | 2026-01-07 16:34:43.508427 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_1", if_exist:false, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-07 16:34:43.508321 | unit | drop_resource_pool | name | pool_1 | | | | | | | | | | | | | 2026-01-07 16:34:43.508266 | unit | drop_unit | unit_id | 1024 | | | | | | | | | | | | | 2026-01-07 16:34:43.508229 | unit | drop_unit | unit_id | 1023 | | | | | | | | | | | | | 2026-01-07 16:34:43.508149 | unit | drop_unit | unit_id | 1022 | | | | | | | | | | | | | 2026-01-06 21:14:55.090764 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_4", if_exist:true, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-06 21:14:55.087349 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_4", if_exist:true, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-06 21:14:55.083570 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_4", if_exist:true, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-06 21:14:55.083510 | unit | drop_resource_pool | name | pool_4 | | | | | | | | | | | | | 2026-01-06 21:14:55.083442 | unit | drop_unit | unit_id | 1033 | | | | | | | | | | | | | 2026-01-06 21:14:55.083406 | unit | drop_unit | unit_id | 1032 | | | | | | | | | | | | | 2026-01-06 21:14:55.083321 | unit | drop_unit | unit_id | 1031 | | | | | | | | | | | | | 2026-01-05 22:51:09.364341 | root_service | create_resource_pool | ret | 0 | arg | pool_name:"pool_4", unit:"unit_3c6g", unit_num:1, zone_list:["zone1", "zone2", "zone3"], replica_type:0, if_not_exist:false | | | | | | | | | | | 2026-01-05 22:51:09.364154 | unit | create_resource_pool | name | pool_4 | unit | unit_3c6g | zone_list | [..., "zone3"] | source_tenant_id | 0 | | | | | | | 2026-01-05 22:51:09.311208 | unit | create_unit | unit_id | 1033 | server | "10.10.1.76:2882" | | | | | | | | | | | 2026-01-05 22:51:09.275320 | unit | create_unit | unit_id | 1032 | server | "10.10.1.75:2882" | | | | | | | | | | | 2026-01-05 22:51:09.219809 | unit | create_unit | unit_id | 1031 | server | "10.10.1.74:2882" | | | | | | | | | | | 2026-01-05 22:51:08.906957 | root_service | create_resource_pool | ret | 0 | arg | pool_name:"pool_3", unit:"unit_3c6g", unit_num:1, zone_list:["zone1", "zone2", "zone3"], replica_type:0, if_not_exist:false | | | | | | | | | | | 2026-01-05 22:51:08.906734 | unit | create_resource_pool | name | pool_3 | unit | unit_3c6g | zone_list | [..., "zone3"] | source_tenant_id | 0 | | | | | | | 2026-01-05 22:51:08.893107 | unit | create_unit | unit_id | 1030 | server | "10.10.1.76:2882" | | | | | | | | | | | 2026-01-05 22:51:08.854621 | unit | create_unit | unit_id | 1029 | server | "10.10.1.75:2882" | | | | | | | | | | | 2026-01-05 22:51:08.827077 | unit | create_unit | unit_id | 1028 | server | "10.10.1.74:2882" | | | | | | | | | | | 2026-01-05 22:51:08.716972 | root_service | create_resource_pool | ret | 0 | arg | pool_name:"pool_2", unit:"unit_3c6g", unit_num:1, zone_list:["zone1", "zone2", "zone3"], replica_type:0, if_not_exist:false | | | | | | | | | | | 2026-01-05 22:51:08.716801 | unit | create_resource_pool | name | pool_2 | unit | unit_3c6g | zone_list | [..., "zone3"] | source_tenant_id | 0 | | | | | | | 2026-01-05 22:51:08.656244 | unit | create_unit | unit_id | 1027 | server | "10.10.1.76:2882" | | | | | | | | | | | 2026-01-05 22:51:08.609203 | unit | create_unit | unit_id | 1026 | server | "10.10.1.75:2882" | | | | | | | | | | | 2026-01-05 22:51:08.537804 | unit | create_unit | unit_id | 1025 | server | "10.10.1.74:2882" | | | | | | | | | | | 2026-01-05 22:51:08.418108 | root_service | create_resource_pool | ret | 0 | arg | pool_name:"pool_1", unit:"unit_3c6g", unit_num:1, zone_list:["zone1", "zone2", "zone3"], replica_type:0, if_not_exist:false | | | | | | | | | | | 2026-01-05 22:51:08.417890 | unit | create_resource_pool | name | pool_1 | unit | unit_3c6g | zone_list | [..., "zone3"] | source_tenant_id | 0 | | | | | | | 2026-01-05 22:51:08.406817 | unit | create_unit | unit_id | 1024 | server | "10.10.1.76:2882" | | | | | | | | | | | 2026-01-05 22:51:08.336383 | unit | create_unit | unit_id | 1023 | server | "10.10.1.75:2882" | | | | | | | | | | | 2026-01-05 22:51:08.228765 | unit | create_unit | unit_id | 1022 | server | "10.10.1.74:2882" | | | | | | | | | | | 2026-01-05 22:50:37.983630 | root_service | create_resource_unit | ret | 0 | arg | {if_not_exist:false, unit_config:{unit_config_id:18446744073709551615, name:"unit_3c6g", resource:{min_cpu:3, max_cpu:3, memory_size:"6GB", log_disk_size:-1, data_disk_size:-1, min_iops:10000, max_iops:10000, iops_weight:-1, max_net_bandwidth:"0GB", net_bandwidth_weight:-1, }}} | | | | | | | | | | | 2026-01-05 22:50:26.854001 | root_service | drop_resource_unit | ret | 0 | arg | unit_name:"unit_3c7g", if_exist:false | | | | | | | | | | | 2026-01-05 22:50:26.853754 | unit | drop_resource_unit | name | unit_3c7g | | | | | | | | | | | | | 2026-01-05 22:39:51.804783 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_3", if_exist:false, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-05 22:39:51.804707 | unit | drop_resource_pool | name | pool_3 | | | | | | | | | | | | | 2026-01-05 22:39:51.804625 | unit | drop_unit | unit_id | 1021 | | | | | | | | | | | | | 2026-01-05 22:39:51.804594 | unit | drop_unit | unit_id | 1020 | | | | | | | | | | | | | 2026-01-05 22:39:51.804501 | unit | drop_unit | unit_id | 1019 | | | | | | | | | | | | | 2026-01-05 22:39:49.971310 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_2", if_exist:false, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-05 22:39:49.971238 | unit | drop_resource_pool | name | pool_2 | | | | | | | | | | | | | 2026-01-05 22:39:49.971187 | unit | drop_unit | unit_id | 1015 | | | | | | | | | | | | | 2026-01-05 22:39:49.971144 | unit | drop_unit | unit_id | 1014 | | | | | | | | | | | | | 2026-01-05 22:39:49.971042 | unit | drop_unit | unit_id | 1013 | | | | | | | | | | | | | 2026-01-05 22:39:47.714745 | root_service | drop_resource_pool | ret | 0 | arg | pool_name:"pool_1", if_exist:false, pool_id:18446744073709551615 | | | | | | | | | | | 2026-01-05 22:39:47.714654 | unit | drop_resource_pool | name | pool_1 | | | | | | | | | | | | | 2026-01-05 22:39:47.714598 | unit | drop_unit | unit_id | 1012 | | | | | | | | | | | | | 2026-01-05 22:39:47.714560 | unit | drop_unit | unit_id | 1011 | | | | | | | | | | | | | 2026-01-05 22:39:47.714451 | unit | drop_unit | unit_id | 1010 | | | | | | | | | | | | | 2026-01-05 22:39:17.436291 | root_service | create_resource_unit | ret | 0 | arg | {if_not_exist:false, unit_config:{unit_config_id:18446744073709551615, name:"unit_3c7g", resource:{min_cpu:3, max_cpu:3, memory_size:"7GB", log_disk_size:-1, data_disk_size:-1, min_iops:10000, max_iops:10000, iops_weight:-1, max_net_bandwidth:"0GB", net_bandwidth_weight:-1, }}} | | | | | | | | | | | 2026-01-05 22:39:01.284457 | root_service | drop_resource_unit | ret | 0 | arg | unit_name:"unit_3c7g", if_exist:false | | | | | | | | | | | 2026-01-05 22:39:01.284355 | unit | drop_resource_unit | name | unit_3c7g | | | | | | | | | | | | +----------------------------+--------------+----------------------+---------+-----------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+--------+-------+--------+------------+ 100 rows in set (0.02 sec) MySQL [oceanbase]> exit Bye You have new mail in /var/spool/mail/root [root@observer1 ~]# exit logout