MySQL [(none)]> SHOW VARIABLES like 'version_comment'; +-----------------+-------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +-----------------+-------------------------------------------------------------------------------------------------------------------+ | version_comment | OceanBase_CE 4.2.1.10 (r110000072024112010-28c1343085627e79a4f13c29121646bb889cf901) (Built Nov 20 2024 10:14:47) | +-----------------+-------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.023 sec) MySQL [(none)]> select* from CDB_OB_MAJOR_COMPACTION; ERROR 1046 (3D000): No database selected MySQL [(none)]> use oceanbase; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MySQL [oceanbase]> SHOW VARIABLES like 'version_comment'; +-----------------+-------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +-----------------+-------------------------------------------------------------------------------------------------------------------+ | version_comment | OceanBase_CE 4.2.1.10 (r110000072024112010-28c1343085627e79a4f13c29121646bb889cf901) (Built Nov 20 2024 10:14:47) | +-----------------+-------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.004 sec) MySQL [oceanbase]> select* from CDB_OB_MAJOR_COMPACTION; +-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+ | TENANT_ID | FROZEN_SCN | FROZEN_TIME | GLOBAL_BROADCAST_SCN | LAST_SCN | LAST_FINISH_TIME | START_TIME | STATUS | IS_ERROR | IS_SUSPENDED | INFO | +-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+ | 1 | 1776189603631176256 | 2026-04-15 02:00:03.631176 | 1776189603631176256 | 1776189603631176256 | 2026-04-15 02:03:35.886471 | 2026-04-15 02:00:03.667023 | IDLE | NO | NO | | | 1001 | 1776189602108465872 | 2026-04-15 02:00:02.108466 | 1776189602108465872 | 1776189602108465872 | 2026-04-15 02:02:13.966119 | 2026-04-15 02:00:02.139967 | IDLE | NO | NO | | | 1002 | 1776189603629974624 | 2026-04-15 02:00:03.629975 | 1776189603629974624 | 1776189603629974624 | 2026-04-15 09:35:10.371018 | 2026-04-15 02:00:05.473403 | IDLE | NO | NO | | | 1003 | 1776189603406600558 | 2026-04-15 02:00:03.406601 | 1776189603406600558 | 1776189603406600558 | 2026-04-15 02:03:45.500312 | 2026-04-15 02:00:03.434304 | IDLE | NO | NO | | | 1004 | 1741543201628953082 | 2025-03-10 02:00:01.628953 | 1741543201628953082 | 1741543201628953082 | 2025-03-15 01:05:27.824671 | 2025-03-13 12:54:21.155302 | IDLE | NO | NO | | +-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+ 5 rows in set (0.009 sec) MySQL [oceanbase]> select * from __all_virtual_server_compaction_progress where tenant_id = 1002; +---------------+----------+-------+-----------+-------------+---------------------+--------+--------------------+-------------------------+----------------+----------------------+-------------------+----------------------------+----------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | svr_ip | svr_port | zone | tenant_id | type | compaction_scn | status | total_tablet_count | unfinished_tablet_count | data_size | unfinished_data_size | compression_ratio | start_time | estimated_finish_time | comments | +---------------+----------+-------+-----------+-------------+---------------------+--------+--------------------+-------------------------+----------------+----------------------+-------------------+----------------------------+----------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1775844004503460543 | FINISH | 462748 | 0 | 15405406183958 | 0 | 0.63 | 2026-04-11 02:00:08.291228 | 2026-04-11 10:31:46.741352 | wait_schedule_time=1.02s|COMPACTION_POLICY=23.87s||GET_PARALLEL_RANGE=8.41s||EXECUTE=48533.86s|(0.93)|CREATE_SSTABLE=363.86s||UPDATE_TABLET=3426.89s|(0.07)|total=52356.89s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1775930401324056724 | FINISH | 462748 | 0 | 15405406022096 | 0 | 0.63 | 2026-04-12 02:00:06.042817 | 2026-04-12 09:38:47.105222 | wait_schedule_time=1.01s|COMPACTION_POLICY=24.05s||GET_PARALLEL_RANGE=8.50s||EXECUTE=45655.55s|(0.93)|CREATE_SSTABLE=349.18s||UPDATE_TABLET=3089.70s|(0.06)|total=49126.99s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1776016803069046632 | FINISH | 462748 | 0 | 15405404325013 | 0 | 0.63 | 2026-04-13 02:00:08.693738 | 2026-04-13 09:49:31.457438 | wait_schedule_time=1.01s|COMPACTION_POLICY=26.04s||GET_PARALLEL_RANGE=9.85s||EXECUTE=46229.52s|(0.93)|CREATE_SSTABLE=344.41s||UPDATE_TABLET=3051.30s|(0.06)|total=49661.12s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1776103202393338924 | FINISH | 462748 | 0 | 15405405277197 | 0 | 0.63 | 2026-04-14 02:00:07.304542 | 2026-04-14 10:00:38.118569 | wait_schedule_time=1.02s|COMPACTION_POLICY=141.13s||GET_PARALLEL_RANGE=28.61s||EXECUTE=47499.25s|(0.93)|CREATE_SSTABLE=358.19s||UPDATE_TABLET=3204.13s|(0.06)|total=51231.31s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1776189603629974624 | FINISH | 462748 | 0 | 15405406412162 | 0 | 0.63 | 2026-04-15 02:00:09.175528 | 2026-04-15 10:05:03.737557 | wait_schedule_time=1.04s|COMPACTION_POLICY=26.05s||GET_PARALLEL_RANGE=9.07s||EXECUTE=45505.96s|(0.93)|CREATE_SSTABLE=344.89s||UPDATE_TABLET=3026.00s|(0.06)|total=48911.98s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1773684000528420270 | FINISH | 462748 | 0 | 15405408247489 | 0 | 0.63 | 2026-03-17 02:00:04.785544 | 2026-03-17 10:14:05.315501 | wait_schedule_time=1.00s|COMPACTION_POLICY=209.23s||GET_PARALLEL_RANGE=31.91s||EXECUTE=49278.95s|(0.92)|CREATE_SSTABLE=362.47s||UPDATE_TABLET=3734.39s|(0.07)|total=53616.96s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1773770404629363193 | FINISH | 462748 | 0 | 15405408195027 | 0 | 0.63 | 2026-03-18 02:00:11.401380 | 2026-03-18 10:14:42.844426 | wait_schedule_time=1.01s|COMPACTION_POLICY=24.05s||GET_PARALLEL_RANGE=8.36s||EXECUTE=47768.39s|(0.92)|CREATE_SSTABLE=362.15s||UPDATE_TABLET=3608.29s|(0.07)|total=51771.24s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1773856803875327500 | FINISH | 462748 | 0 | 15405408267590 | 0 | 0.63 | 2026-03-19 02:00:08.633879 | 2026-03-19 10:07:34.229207 | wait_schedule_time=1.01s|COMPACTION_POLICY=52.56s||GET_PARALLEL_RANGE=12.67s||EXECUTE=48144.77s|(0.93)|CREATE_SSTABLE=359.19s||UPDATE_TABLET=3441.16s|(0.07)|total=52010.34s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1773943203586289669 | FINISH | 462748 | 0 | 15405405991047 | 0 | 0.63 | 2026-03-20 02:00:08.182420 | 2026-03-20 10:04:18.980945 | wait_schedule_time=1.01s|COMPACTION_POLICY=24.06s||GET_PARALLEL_RANGE=8.34s||EXECUTE=47778.25s|(0.93)|CREATE_SSTABLE=358.75s||UPDATE_TABLET=3429.23s|(0.07)|total=51598.62s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1774029604860441515 | FINISH | 462748 | 0 | 15405406226237 | 0 | 0.63 | 2026-03-21 02:00:11.179557 | 2026-03-21 10:19:57.602745 | wait_schedule_time=1.01s|COMPACTION_POLICY=24.09s||GET_PARALLEL_RANGE=8.37s||EXECUTE=48521.47s|(0.93)|CREATE_SSTABLE=361.66s||UPDATE_TABLET=3350.58s|(0.06)|total=52266.17s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1774116004698557718 | FINISH | 462748 | 0 | 15405408137611 | 0 | 0.63 | 2026-03-22 02:00:08.267692 | 2026-03-22 10:38:35.919992 | wait_schedule_time=1.01s|COMPACTION_POLICY=196.46s||GET_PARALLEL_RANGE=30.93s||EXECUTE=49645.46s|(0.92)|CREATE_SSTABLE=372.92s||UPDATE_TABLET=3457.88s|(0.06)|total=53703.65s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1774202403624349890 | FINISH | 462748 | 0 | 15405410234213 | 0 | 0.63 | 2026-03-23 02:00:07.309238 | 2026-03-23 10:00:55.688009 | wait_schedule_time=1.04s|COMPACTION_POLICY=24.60s||GET_PARALLEL_RANGE=8.58s||EXECUTE=45675.65s|(0.93)|CREATE_SSTABLE=348.03s||UPDATE_TABLET=3088.42s|(0.06)|total=49145.28s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1774288803831045523 | FINISH | 462748 | 0 | 15405406486992 | 0 | 0.63 | 2026-03-24 02:00:09.429067 | 2026-03-24 09:55:06.376903 | wait_schedule_time=1.03s|COMPACTION_POLICY=35.74s||GET_PARALLEL_RANGE=11.94s||EXECUTE=46201.97s|(0.93)|CREATE_SSTABLE=351.74s||UPDATE_TABLET=3050.48s|(0.06)|total=49651.88s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1774375202817958491 | FINISH | 462748 | 0 | 15405405211645 | 0 | 0.63 | 2026-03-25 02:00:06.975379 | 2026-03-25 09:51:34.880930 | wait_schedule_time=1.02s|COMPACTION_POLICY=94.78s||GET_PARALLEL_RANGE=20.10s||EXECUTE=47375.52s|(0.93)|CREATE_SSTABLE=357.82s||UPDATE_TABLET=3183.47s|(0.06)|total=51031.68s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1774461602601638721 | FINISH | 462748 | 0 | 15405408214047 | 0 | 0.63 | 2026-03-26 02:00:08.379792 | 2026-03-26 10:10:28.846336 | wait_schedule_time=1.01s|COMPACTION_POLICY=23.82s||GET_PARALLEL_RANGE=8.29s||EXECUTE=46722.91s|(0.93)|CREATE_SSTABLE=356.95s||UPDATE_TABLET=3255.63s|(0.06)|total=50367.60s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1774548003277448094 | FINISH | 462748 | 0 | 15405408091939 | 0 | 0.63 | 2026-03-27 02:00:08.270798 | 2026-03-27 10:07:31.744309 | wait_schedule_time=1.04s|COMPACTION_POLICY=24.42s||GET_PARALLEL_RANGE=8.49s||EXECUTE=46620.46s|(0.93)|CREATE_SSTABLE=348.25s||UPDATE_TABLET=3279.37s|(0.07)|total=50280.99s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1774634404582999805 | FINISH | 462748 | 0 | 15405404403636 | 0 | 0.63 | 2026-03-28 02:00:10.266087 | 2026-03-28 10:08:14.370754 | wait_schedule_time=1.01s|COMPACTION_POLICY=23.87s||GET_PARALLEL_RANGE=8.28s||EXECUTE=47306.70s|(0.93)|CREATE_SSTABLE=358.03s||UPDATE_TABLET=3442.13s|(0.07)|total=51139.02s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1774720802774646122 | FINISH | 462748 | 0 | 15405405160606 | 0 | 0.63 | 2026-03-29 02:00:08.483780 | 2026-03-29 09:58:38.982911 | wait_schedule_time=1.02s|COMPACTION_POLICY=42.71s||GET_PARALLEL_RANGE=11.46s||EXECUTE=47607.38s|(0.92)|CREATE_SSTABLE=359.67s||UPDATE_TABLET=3478.61s|(0.07)|total=51499.83s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1774807203206729886 | FINISH | 462748 | 0 | 15405405206043 | 0 | 0.63 | 2026-03-30 02:00:08.163656 | 2026-03-30 09:57:33.163039 | wait_schedule_time=1.02s|COMPACTION_POLICY=38.73s||GET_PARALLEL_RANGE=10.45s||EXECUTE=47322.35s|(0.93)|CREATE_SSTABLE=352.40s||UPDATE_TABLET=3428.07s|(0.07)|total=51152.01s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1774893601370215065 | FINISH | 462748 | 0 | 15405405250846 | 0 | 0.63 | 2026-03-31 02:00:07.924676 | 2026-03-31 10:10:03.476089 | wait_schedule_time=1.02s|COMPACTION_POLICY=71.48s||GET_PARALLEL_RANGE=15.89s||EXECUTE=47042.04s|(0.93)|CREATE_SSTABLE=349.66s||UPDATE_TABLET=3297.50s|(0.06)|total=50776.57s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1774980001811948143 | FINISH | 462748 | 0 | 15405406060971 | 0 | 0.63 | 2026-04-01 02:00:06.420574 | 2026-04-01 10:02:35.723293 | wait_schedule_time=1.01s|COMPACTION_POLICY=24.27s||GET_PARALLEL_RANGE=8.31s||EXECUTE=46835.67s|(0.93)|CREATE_SSTABLE=354.41s||UPDATE_TABLET=3386.71s|(0.07)|total=50609.37s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1775066400683765842 | FINISH | 462748 | 0 | 15405406190507 | 0 | 0.63 | 2026-04-02 02:00:05.370784 | 2026-04-02 09:55:09.956771 | wait_schedule_time=1.01s|COMPACTION_POLICY=195.09s||GET_PARALLEL_RANGE=32.41s||EXECUTE=46798.34s|(0.92)|CREATE_SSTABLE=351.51s||UPDATE_TABLET=3251.48s|(0.06)|total=50628.82s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1775152800730243174 | FINISH | 462748 | 0 | 15405406021368 | 0 | 0.63 | 2026-04-03 02:00:07.670439 | 2026-04-03 10:12:25.902968 | wait_schedule_time=1.01s|COMPACTION_POLICY=24.21s||GET_PARALLEL_RANGE=8.33s||EXECUTE=46650.10s|(0.92)|CREATE_SSTABLE=358.62s||UPDATE_TABLET=3451.66s|(0.07)|total=50492.92s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1775239200736086285 | FINISH | 462748 | 0 | 15405406182035 | 0 | 0.63 | 2026-04-04 02:00:07.428247 | 2026-04-04 10:12:30.117230 | wait_schedule_time=1.00s|COMPACTION_POLICY=27.49s||GET_PARALLEL_RANGE=9.06s||EXECUTE=47753.10s|(0.92)|CREATE_SSTABLE=361.95s||UPDATE_TABLET=3513.39s|(0.07)|total=51664.99s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1775325600438470058 | FINISH | 462748 | 0 | 15405406008607 | 0 | 0.63 | 2026-04-05 02:00:07.062734 | 2026-04-05 09:55:22.448600 | wait_schedule_time=1.04s|COMPACTION_POLICY=24.54s||GET_PARALLEL_RANGE=8.57s||EXECUTE=45901.66s|(0.93)|CREATE_SSTABLE=351.02s||UPDATE_TABLET=3258.44s|(0.07)|total=49544.23s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1775412002701361399 | FINISH | 462748 | 0 | 15405406320270 | 0 | 0.63 | 2026-04-06 02:00:08.680599 | 2026-04-06 10:10:14.006006 | wait_schedule_time=1.01s|COMPACTION_POLICY=229.10s||GET_PARALLEL_RANGE=40.95s||EXECUTE=47647.86s|(0.92)|CREATE_SSTABLE=368.76s||UPDATE_TABLET=3411.40s|(0.07)|total=51698.06s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1775498400499011079 | FINISH | 462748 | 0 | 15405440528714 | 0 | 0.63 | 2026-04-07 02:00:06.845906 | 2026-04-07 10:05:17.491810 | wait_schedule_time=1.02s|COMPACTION_POLICY=38.66s||GET_PARALLEL_RANGE=10.63s||EXECUTE=48666.77s|(0.92)|CREATE_SSTABLE=370.12s||UPDATE_TABLET=3697.29s|(0.07)|total=52783.48s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1775584803275672552 | FINISH | 462748 | 0 | 15405442050346 | 0 | 0.63 | 2026-04-08 02:00:07.946531 | 2026-04-08 10:20:30.128696 | wait_schedule_time=1.01s|COMPACTION_POLICY=25.74s||GET_PARALLEL_RANGE=8.63s||EXECUTE=48406.45s|(0.92)|CREATE_SSTABLE=367.07s||UPDATE_TABLET=3738.10s|(0.07)|total=52545.98s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1775671200957046475 | FINISH | 462748 | 0 | 15405414623788 | 0 | 0.63 | 2026-04-09 02:00:05.180526 | 2026-04-09 10:19:06.646879 | wait_schedule_time=1.01s|COMPACTION_POLICY=212.30s||GET_PARALLEL_RANGE=32.72s||EXECUTE=49443.77s|(0.92)|CREATE_SSTABLE=367.10s||UPDATE_TABLET=3572.31s|(0.07)|total=53628.21s; | | 10.173.37.152 | 2882 | zone1 | 1002 | MAJOR_MERGE | 1775757604346680290 | FINISH | 462748 | 0 | 15405406471558 | 0 | 0.63 | 2026-04-10 02:00:11.447915 | 2026-04-10 10:12:39.042624 | COMPACTION_POLICY=23.77s||GET_PARALLEL_RANGE=8.31s||EXECUTE=48091.50s|(0.93)|CREATE_SSTABLE=361.67s||UPDATE_TABLET=3454.97s|(0.07)|total=51940.23s; | +---------------+----------+-------+-----------+-------------+---------------------+--------+--------------------+-------------------------+----------------+----------------------+-------------------+----------------------------+----------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 30 rows in set (0.035 sec) MySQL [oceanbase]> Your system is not activated. Please activate as soon as possible for normal use. MySQL [oceanbase]> select * from __all_virtual_tablet_compaction_progress where tenant_id = 1002; Empty set (0.015 sec)