obclient [oceanbase]> select * from GV$OB_TABLET_COMPACTION_HISTORY where tenant_id = 1002 and compaction_scn = 1709211602665446060 order by time_to_usec(finish_time)-time_to_usec(start_time) desc limit 10 -> ; +-------------+----------+-----------+-------+---------------------+-------------+---------------------+----------------------------+----------------------------+-----------------------------------+-------------+-------------------+-------------------------------+------------------------------+--------------------------------------+-----------------+-----------------------+-------------------+---------------------+------------------------------+----------------------------+-----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------+----------------------------------------------------------------+------------------------------------------------------------+ | SVR_IP | SVR_PORT | TENANT_ID | LS_ID | TABLET_ID | TYPE | COMPACTION_SCN | START_TIME | FINISH_TIME | TASK_ID | OCCUPY_SIZE | MACRO_BLOCK_COUNT | MULTIPLEXED_MACRO_BLOCK_COUNT | NEW_MICRO_COUNT_IN_NEW_MACRO | MULTIPLEXED_MICRO_COUNT_IN_NEW_MACRO | TOTAL_ROW_COUNT | INCREMENTAL_ROW_COUNT | COMPRESSION_RATIO | NEW_FLUSH_DATA_RATE | PROGRESSIVE_COMPACTION_ROUND | PROGRESSIVE_COMPACTION_NUM | PARALLEL_DEGREE | PARALLEL_INFO | PARTICIPANT_TABLE | MACRO_ID_LIST | COMMENTS | +-------------+----------+-----------+-------+---------------------+-------------+---------------------+----------------------------+----------------------------+-----------------------------------+-------------+-------------------+-------------------------------+------------------------------+--------------------------------------+-----------------+-----------------------+-------------------+---------------------+------------------------------+----------------------------+-----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------+----------------------------------------------------------------+------------------------------------------------------------+ | 81.16.49.46 | 2882 | 1002 | 1002 | 1893163 | MAJOR_MERGE | 1709211602665446060 | 2024-03-01 16:24:06.579930 | 2024-03-01 16:24:10.907414 | YB425110312E-0006097A74CD8582-0-0 | 1808943118 | 904 | 890 | 1600 | 0 | 80147114 | 1188695 | 0.62 | 6083 | 1 | 0 | 15 | {{type:"scan_units", min:0, max:0, avg:0}, {type:"cost_time", min:90813, max:1508116, avg:1247562}, {type:"use_old_macro_block_cnt", min:52, max:71, avg:59}, {type:"incremental_row_count", min:0, max:98619, avg:79246}, } | table_cnt=1,[MAJOR]snapshot_version=1709056804474085212; | | extra_info="time_guard=EXECUTE=4.32s|(0.96)|total=4.52s;"; | | 81.16.49.46 | 2882 | 1002 | 1002 | 1152921504610575476 | MAJOR_MERGE | 1709211602665446060 | 2024-03-01 16:24:06.582673 | 2024-03-01 16:24:09.498750 | YB425110312E-0006097A74CD8583-0-0 | 14202850 | 7 | 7 | 0 | 0 | 1443038 | 0 | 1 | 0 | 1 | 0 | 1 | - | table_cnt=1,[MAJOR]snapshot_version=1709056804474085212; | 12632677,13615239,13679563,13658443,13653404,13632284,13606125 | extra_info="time_guard=EXECUTE=2.90s|(0.97)|total=2.99s;"; | | 81.16.49.46 | 2882 | 1002 | 1002 | 1152921504609546896 | MAJOR_MERGE | 1709211602665446060 | 2024-03-01 16:24:06.582775 | 2024-03-01 16:24:09.490318 | YB425110312E-0006097A74CD8584-0-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | - | table_cnt=1,[MAJOR]snapshot_version=1709056804474085212; | | extra_info="time_guard=EXECUTE=2.90s|(0.98)|total=2.97s;"; | | 81.16.49.44 | 2882 | 1002 | 1003 | 1152921504609986147 | MAJOR_MERGE | 1709211602665446060 | 2024-03-01 14:43:17.833996 | 2024-03-01 14:43:20.002394 | YB425110312C-00060A6102A7C376-0-0 | 99588297 | 83 | 82 | 127 | 0 | 48561896 | 1026487 | 0.99 | 934 | 2 | 100 | 2 | {{type:"scan_units", min:627183, max:11433957, avg:6030570}, {type:"cost_time", min:140949, max:2158191, avg:1149570}, {type:"use_old_macro_block_cnt", min:35, max:47, avg:41}, {type:"incremental_row_count", min:0, max:1026487, avg:513243}, } | table_cnt=1,[MAJOR]snapshot_version=1709056804474085212; | | extra_info="time_guard=EXECUTE=2.16s|(0.93)|total=2.32s;"; | | 81.16.49.44 | 2882 | 1002 | 1003 | 1891949 | MAJOR_MERGE | 1709211602665446060 | 2024-03-01 15:51:34.367697 | 2024-03-01 15:51:36.312430 | YB425110312C-00060A6102A804DA-0-0 | 864197275 | 459 | 452 | 838 | 0 | 20092487 | 318535 | 0.57 | 6804 | 1 | 0 | 8 | {{type:"scan_units", min:0, max:0, avg:0}, {type:"cost_time", min:134120, max:1189823, avg:903087}, {type:"use_old_macro_block_cnt", min:55, max:63, avg:56}, {type:"incremental_row_count", min:0, max:59982, avg:39816}, } | table_cnt=1,[MAJOR]snapshot_version=1709056804474085212; | | extra_info="time_guard=EXECUTE=1.93s|(0.92)|total=2.10s;"; | | 81.16.49.44 | 2882 | 1002 | 1003 | 1152921504609986145 | MAJOR_MERGE | 1709211602665446060 | 2024-03-01 14:40:58.071700 | 2024-03-01 14:40:59.917136 | YB425110312C-00060A6102A7AD78-0-0 | 87044224 | 68 | 67 | 125 | 0 | 40125428 | 971987 | 0.99 | 1102 | 2 | 100 | 2 | {{type:"scan_units", min:0, max:2, avg:1}, {type:"cost_time", min:189872, max:1811525, avg:1000698}, {type:"use_old_macro_block_cnt", min:31, max:36, avg:33}, {type:"incremental_row_count", min:0, max:971987, avg:485993}, } | table_cnt=1,[MAJOR]snapshot_version=1709056804474085212; | | extra_info="time_guard=EXECUTE=1.83s|(0.93)|total=1.96s;"; | | 81.16.49.46 | 2882 | 1002 | 1001 | 1893832 | MAJOR_MERGE | 1709211602665446060 | 2024-03-01 16:06:20.534952 | 2024-03-01 16:06:22.163607 | YB425110312E-0006097A74CCF218-0-0 | 318110266 | 158 | 156 | 244 | 0 | 15514895 | 204968 | 0.66 | 2488 | 1 | 0 | 3 | {{type:"scan_units", min:0, max:0, avg:0}, {type:"cost_time", min:225683, max:1570892, avg:1099063}, {type:"use_old_macro_block_cnt", min:45, max:60, avg:52}, {type:"incremental_row_count", min:0, max:102491, avg:68322}, } | table_cnt=1,[MAJOR]snapshot_version=1709056804474085212; | | extra_info="time_guard=EXECUTE=1.62s|(0.86)|total=1.88s;"; | | 81.16.49.46 | 2882 | 1002 | 1001 | 1893036 | MAJOR_MERGE | 1709211602665446060 | 2024-03-01 16:16:02.081667 | 2024-03-01 16:16:03.678115 | YB425110312E-0006097A74CD42BC-0-0 | 345653066 | 183 | 181 | 131 | 0 | 14695934 | 85516 | 0.59 | 1284 | 1 | 0 | 3 | {{type:"scan_units", min:0, max:0, avg:0}, {type:"cost_time", min:319322, max:1585220, avg:759466}, {type:"use_old_macro_block_cnt", min:52, max:70, avg:60}, {type:"incremental_row_count", min:0, max:85037, avg:28505}, } | table_cnt=1,[MAJOR]snapshot_version=1709056804474085212; | | extra_info="time_guard=EXECUTE=1.59s|(0.89)|total=1.78s;"; | | 81.16.49.45 | 2882 | 1002 | 1003 | 1152921504609994337 | MAJOR_MERGE | 1709211602665446060 | 2024-03-01 18:35:51.008859 | 2024-03-01 18:35:52.517970 | YB425110312D-0006097A696EB61D-0-0 | 185977858 | 127 | 126 | 127 | 0 | 40125428 | 457893 | 0.78 | 1335 | 2 | 100 | 2 | {{type:"scan_units", min:0, max:2, avg:1}, {type:"cost_time", min:364399, max:1489973, avg:927186}, {type:"use_old_macro_block_cnt", min:59, max:67, avg:63}, {type:"incremental_row_count", min:0, max:457893, avg:228946}, } | table_cnt=1,[MAJOR]snapshot_version=1709056804474085212; | | extra_info="time_guard=EXECUTE=1.50s|(0.90)|total=1.68s;"; | | 81.16.49.45 | 2882 | 1002 | 1001 | 1894381 | MAJOR_MERGE | 1709211602665446060 | 2024-03-01 17:54:11.924784 | 2024-03-01 17:54:13.428674 | YB425110312D-0006097A696E8D51-0-0 | 192728630 | 107 | 106 | 124 | 0 | 6961788 | 78574 | 0.52 | 1351 | 1 | 0 | 2 | {{type:"scan_units", min:0, max:0, avg:0}, {type:"cost_time", min:308306, max:1448412, avg:878359}, {type:"use_old_macro_block_cnt", min:45, max:61, avg:53}, {type:"incremental_row_count", min:0, max:78574, avg:39287}, } | table_cnt=1,[MAJOR]snapshot_version=1709056804474085212; | | extra_info="time_guard=EXECUTE=1.50s|(0.90)|total=1.66s;"; | +-------------+----------+-----------+-------+---------------------+-------------+---------------------+----------------------------+----------------------------+-----------------------------------+-------------+-------------------+-------------------------------+------------------------------+--------------------------------------+-----------------+-----------------------+-------------------+---------------------+------------------------------+----------------------------+-----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------+----------------------------------------------------------------+------------------------------------------------------------+ 10 rows in set (1.495 sec) obclient [oceanbase]> 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 | 2023-11-06 16:42:52.691411 | 2023-11-06 16:42:52.691411 | 2 | 2 | 5368709120 | 31332780572 | 9223372036854775807 | 9223372036854775807 | 2 | | 1001 | jdmws_unit_config | 2023-11-07 10:32:57.461028 | 2023-11-07 10:32:57.461028 | 150 | 150 | 762356695040 | 3221225472000 | 10000 | 10000 | 1 | +----------------+-------------------+----------------------------+----------------------------+---------+---------+--------------+---------------+---------------------+---------------------+-------------+ 2 rows in set (0.025 sec) obclient [ljdmws]> SELECT count(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA in ('cst','hds','jcw','ljdmws','org','pub','smy') ; +----------+ | count(*) | +----------+ | 127 | +----------+