After a major compaction is initiated, you can view the merge information through views.
You can view the progress of a major compaction through views. The time spent on a major compaction depends on the data changes between two major compactions. If a large amount of data changes occur between two major compactions, the major compaction will take a longer time. The number of threads for major compactions and the cluster pressure during major compactions also affect the time spent on major compactions.
View the major compactions of all tenants
The sys tenant can observe the tenant-level and partition-level major compactions of all tenants through views.
Log in to the
systenant of the cluster as therootuser.Run the following statement to view the major compactions:
View the tenant-level major compactions through the
CDB_OB_ZONE_MAJOR_COMPACTIONorCDB_OB_MAJOR_COMPACTIONview.The
CDB_OB_ZONE_MAJOR_COMPACTIONview shows the major compactions of all tenants across all zones.obclient> SELECT * FROM oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION;The query result is as follows:
+-----------+-------+---------------------+---------------------+----------------------------+----------------------------+--------+ | TENANT_ID | ZONE | BROADCAST_SCN | LAST_SCN | LAST_FINISH_TIME | START_TIME | STATUS | +-----------+-------+---------------------+---------------------+----------------------------+----------------------------+--------+ | 1 | zone1 | 1748368801021617000 | 1748368801021617000 | 2025-05-28 02:04:15.351286 | 2025-05-28 02:00:01.051592 | IDLE | | 1001 | zone1 | 1748368802924607000 | 1748368802924607000 | 2025-05-28 02:02:16.412661 | 2025-05-28 02:00:02.965810 | IDLE | | 1002 | zone1 | 1748368802035321000 | 1748368802035321000 | 2025-05-28 02:03:25.019173 | 2025-05-28 02:00:02.090687 | IDLE | | 1003 | zone1 | 1748368802977311000 | 1748368802977311000 | 2025-05-28 02:02:46.565036 | 2025-05-28 02:00:03.009192 | IDLE | | 1004 | zone1 | 1748368801786323000 | 1748368801786323000 | 2025-05-28 02:03:54.629630 | 2025-05-28 02:00:01.820863 | IDLE | +-----------+-------+---------------------+---------------------+----------------------------+----------------------------+--------+ 5 rows in setObserve the
statuscolumn in the execution result. The following table describes some of the fields.Field Description TENANT_ID Tenant ID. ZONE Name of the zone. BROADCAST_SCN Broadcasted major compaction version number. LAST_SCN Major compaction version number of the last major compaction. LAST_FINISH_TIME End time of the last major compaction. START_TIME Start time of the major compaction. STATUS Major compaction status: IDLE: not in major compactionCOMPACTING: major compaction in progressVERIFYING: verifying checksums
The
CDB_OB_MAJOR_COMPACTIONview shows the global major compactions of all tenants.obclient> SELECT * FROM oceanbase.CDB_OB_MAJOR_COMPACTION;The query result is as follows:
+-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+ | TENANT_ID | FROZEN_SCN | FROZEN_TIME | GLOBAL_BROADCAST_SCN | LAST_SCN | LAST_FINISH_TIME | START_TIME | STATUS | IS_ERROR | IS_SUSPENDED | INFO | +-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+ | 1 | 1748368801021617000 | 2025-05-28 02:00:01.021617 | 1748368801021617000 | 1748368801021617000 | 2025-05-28 02:04:15.380802 | 2025-05-28 02:00:01.042282 | IDLE | NO | NO | | | 1001 | 1748368802924607000 | 2025-05-28 02:00:02.924607 | 1748368802924607000 | 1748368802924607000 | 2025-05-28 02:02:16.440351 | 2025-05-28 02:00:02.957000 | IDLE | NO | NO | | | 1002 | 1748368802035321000 | 2025-05-28 02:00:02.035321 | 1748368802035321000 | 1748368802035321000 | 2025-05-28 02:03:25.035666 | 2025-05-28 02:00:02.075224 | IDLE | NO | NO | | | 1003 | 1748368802977311000 | 2025-05-28 02:00:02.977311 | 1748368802977311000 | 1748368802977311000 | 2025-05-28 02:02:46.592681 | 2025-05-28 02:00:03.003544 | IDLE | NO | NO | | | 1004 | 1748368801786323000 | 2025-05-28 02:00:01.786323 | 1748368801786323000 | 1748368801786323000 | 2025-05-28 02:03:54.645389 | 2025-05-28 02:00:01.809475 | IDLE | NO | NO | | +-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+ 5 rows in setObserve the
statuscolumn in the execution result. The following table describes some of the parameters.Field Description TENANT_ID Tenant ID. FROZEN_SCN Major compaction version number of the last major compaction. FROZEN_TIME Readable time type of FROZEN_SCN.GLOBAL_BROADCAST_SCN Global broadcasted major compaction version number. LAST_SCN Major compaction version number of the last completed major compaction. LAST_FINISH_TIME End time of the last major compaction. START_TIME Start time of the major compaction. STATUS Major compaction status: IDLE: not in major compactionCOMPACTING: major compaction in progressVERIFYING: verifying checksums
IS_ERROR YES: errors occurred during the major compactionNO: no errors occurred during the major compaction
IS_SUSPENDED YES: the major compaction is suspended.NO: the major compaction is not suspended.
INFO Displays the major compaction information. View the partition-level major compactions through the
GV$OB_MERGE_INFOorGV$OB_TABLET_COMPACTION_HISTORYview.The
GV$OB_MERGE_INFOview shows the basic statistics of tablet major compactions.obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_MERGE_INFO WHERE TENANT_ID=1002 AND TABLET_ID=200001 ORDER BY START_TIME DESC LIMIT 10;The query result is as follows:
+----------------+----------+-----------+-------+-----------+-----------------+---------------------+----------------------------+----------------------------+-------------------+-----------+-----------------+ | SVR_IP | SVR_PORT | TENANT_ID | LS_ID | TABLET_ID | ACTION | COMPACTION_SCN | START_TIME | END_TIME | MACRO_BLOCK_COUNT | REUSE_PCT | PARALLEL_DEGREE | +----------------+----------+-----------+-------+-----------+-----------------+---------------------+----------------------------+----------------------------+-------------------+-----------+-----------------+ | 172.xx.xxx.xxx | 2882 | 1002 | 1001 | 200001 | MAJOR_MERGE | 1706119204801812283 | 2024-01-25 02:03:03.876629 | 2024-01-25 02:03:03.929758 | 0 | 0.00 | 1 | | 172.xx.xxx.xxx | 2882 | 1002 | 1001 | 200001 | MDS_TABLE_MERGE | 1706086731631303497 | 2024-01-24 16:58:52.078436 | 2024-01-24 16:58:52.080722 | 0 | 0.00 | 0 | | 172.xx.xxx.xxx | 2882 | 1002 | 1001 | 200001 | MEDIUM_MERGE | 1706086435242718629 | 2024-01-24 16:56:57.297697 | 2024-01-24 16:56:57.305654 | 0 | 0.00 | 1 | | 172.xx.xxx.xxx | 2882 | 1002 | 1001 | 200001 | MDS_TABLE_MERGE | 1706086356639492056 | 2024-01-24 16:52:37.067139 | 2024-01-24 16:52:37.069771 | 0 | 0.00 | 0 | +----------------+----------+-----------+-------+-----------+-----------------+---------------------+----------------------------+----------------------------+-------------------+-----------+-----------------+ 4 rows in setThe values in the
ACTIONcolumn have the following meanings:MDS_TABLE_MERGE: persists the system metadata to disk in the format of an SSTable.MAJOR_MERGE: tenant-level major compaction.MEDIUM_MERGE: partition-level major compaction.MINI_MERGE: mini compaction, which converts the MemTable to a mini SSTable.MINOR_MERGE: minor compaction, which combines multiple mini SSTables into one or combines multiple mini SSTables with one minor SSTable into one new minor SSTable.META_MAJOR_MERGE: a special compaction type that combines data before a specified point in time into one meta major SSTable. The data format of the meta major SSTable is the same as that of the major SSTable, without multiple versions of data or uncommitted transaction data.
For more information about other columns in the
GV$OB_MERGE_INFOview, see GV$OB_MERGE_INFO.The
GV$OB_TABLET_COMPACTION_HISTORYview shows the detailed history of tablet major compactions.obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_TABLET_COMPACTION_HISTORY WHERE TENANT_ID=1002 AND TABLET_ID=200001 ORDER BY START_TIME DESC LIMIT 2\GThe query result is as follows:
*************************** 1. row *************************** SVR_IP: 172.xx.xxx.xxx SVR_PORT: 2882 TENANT_ID: 1002 LS_ID: 1001 TABLET_ID: 200001 TYPE: MAJOR_MERGE COMPACTION_SCN: 1748455203748142000 START_TIME: 2025-05-29 02:03:35.771081 FINISH_TIME: 2025-05-29 02:03:35.778086 TASK_ID: YB42AC1E87E0-000635386FA342D5-0-0 OCCUPY_SIZE: 0 MACRO_BLOCK_COUNT: 0 MULTIPLEXED_MACRO_BLOCK_COUNT: 0 NEW_MICRO_COUNT_IN_NEW_MACRO: 0 MULTIPLEXED_MICRO_COUNT_IN_NEW_MACRO: 0 TOTAL_ROW_COUNT: 0 INCREMENTAL_ROW_COUNT: 0 COMPRESSION_RATIO: 1 NEW_FLUSH_DATA_RATE: 0 PROGRESSIVE_COMPACTION_ROUND: 1 PROGRESSIVE_COMPACTION_NUM: 0 PARALLEL_DEGREE: 1 PARALLEL_INFO: - PARTICIPANT_TABLE: table_cnt=1,[MAJOR]snapshot_version=1748368801840485000; MACRO_ID_LIST: COMMENTS: START_CG_ID: 0 END_CG_ID: 0 KEPT_SNAPSHOT: {type:"UNDO_RETENTION", snapshot:1748453603923723000} MERGE_LEVEL: MICRO_BLOCK_LEVEL EXEC_MODE: EXEC_MODE_LOCAL IS_FULL_MERGE: FALSE IO_COST_TIME_PERCENTAGE: 0 MERGE_REASON: TENANT_MAJOR BASE_MAJOR_STATUS: CO_MERGE_TYPE: MDS_FILTER_INFO: *************************** 2. row *************************** SVR_IP: 172.xx.xxx.xxx SVR_PORT: 2882 TENANT_ID: 1002 LS_ID: 1001 TABLET_ID: 200001 TYPE: MDS_MINOR_MERGE COMPACTION_SCN: 1748398151630809003 START_TIME: 2025-05-28 10:09:12.139170 FINISH_TIME: 2025-05-28 10:09:12.145988 TASK_ID: YB42AC1E87E0-000635386FA3413D-0-0 OCCUPY_SIZE: 493 MACRO_BLOCK_COUNT: 1 MULTIPLEXED_MACRO_BLOCK_COUNT: 0 NEW_MICRO_COUNT_IN_NEW_MACRO: 1 MULTIPLEXED_MICRO_COUNT_IN_NEW_MACRO: 0 TOTAL_ROW_COUNT: 1 INCREMENTAL_ROW_COUNT: 1 COMPRESSION_RATIO: 1 NEW_FLUSH_DATA_RATE: 78 PROGRESSIVE_COMPACTION_ROUND: 0 PROGRESSIVE_COMPACTION_NUM: 0 PARALLEL_DEGREE: 1 PARALLEL_INFO: - PARTICIPANT_TABLE: table_cnt=2,start_scn=1,end_scn=1748398151630809003; MACRO_ID_LIST: 77871 COMMENTS: comment="cost_mb=2;"; START_CG_ID: 0 END_CG_ID: 0 KEPT_SNAPSHOT: MERGE_LEVEL: MACRO_BLOCK_LEVEL EXEC_MODE: EXEC_MODE_LOCAL IS_FULL_MERGE: FALSE IO_COST_TIME_PERCENTAGE: 3 MERGE_REASON: BASE_MAJOR_STATUS: CO_MERGE_TYPE: 2 rows in setThe values in the
TYPEcolumn have the following meanings:MDS_TABLE_MERGE: persists the system metadata to disk in the format of an SSTable.MAJOR_MERGE: tenant-level major compaction.MEDIUM_MERGE: partition-level major compaction.MINI_MERGE: mini compaction, which converts the MemTable to a mini SSTable.MINOR_MERGE: minor compaction, which combines multiple mini SSTables into one or combines multiple mini SSTables with one minor SSTable into one new minor SSTable.META_MAJOR_MERGE: a special compaction type that combines data before a specified point in time into one meta major SSTable. The data format of the meta major SSTable is the same as that of the major SSTable, without multiple versions of data or uncommitted transaction data.
For more information about other columns in the
GV$OB_TABLET_COMPACTION_HISTORYview, see GV$OB_TABLET_COMPACTION_HISTORY.
View the major compaction information of the user tenant
User tenants can also view the major compaction information of the current tenant by using views.
The tenant administrator of the user tenant logs in to the database.
Execute the following statement to view the major compaction information.
MySQL modeOracle modeView the tenant-level major compaction information of the current tenant by using the
DBA_OB_ZONE_MAJOR_COMPACTIONorDBA_OB_MAJOR_COMPACTIONview.The
DBA_OB_ZONE_MAJOR_COMPACTIONview displays the major compaction information of each zone in the current tenant.obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION;Here is the sample result:
+-------+---------------------+---------------------+----------------------------+----------------------------+--------+ | ZONE | BROADCAST_SCN | LAST_SCN | LAST_FINISH_TIME | START_TIME | STATUS | +-------+---------------------+---------------------+----------------------------+----------------------------+--------+ | zone1 | 1748455202538454000 | 1748455202538454000 | 2025-05-29 02:04:34.174642 | 2025-05-29 02:00:02.679713 | IDLE | +-------+---------------------+---------------------+----------------------------+----------------------------+--------+ 1 row in setObserve the
statuscolumn in the execution result. The following table describes some parameters.Parameter Description ZONE The name of the zone. BROADCAST_SCN The broadcasted major compaction version number. LAST_SCN The major compaction version number of the last major compaction. LAST_FINISH_TIME The end time of the last major compaction. START_TIME The start time of the major compaction. STATUS The major compaction status. IDLE: Not in major compaction.COMPACTING: Major compaction is in progress.VERIFYING: Checking the checksum.
The
DBA_OB_MAJOR_COMPACTIONview displays the global information about major compactions in the current tenant.obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_MAJOR_COMPACTION;The execution result is as follows:
+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+ | FROZEN_SCN | FROZEN_TIME | GLOBAL_BROADCAST_SCN | LAST_SCN | LAST_FINISH_TIME | START_TIME | STATUS | IS_ERROR | IS_SUSPENDED | INFO | +---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+ | 1748455202538454000 | 2025-05-29 02:00:02.538454 | 1748455202538454000 | 1748455202538454000 | 2025-05-29 02:04:34.171690 | 2025-05-29 02:00:02.670090 | IDLE | NO | NO | | +---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+ 1 row in setObserve the
statuscolumn in the execution result. The following table describes some parameters.Parameter Description FROZEN_SCN The version number of the last major compaction. FROZEN_TIME The readable time type of FROZEN_SCN.GLOBAL_BROADCAST_SCN The broadcasted major compaction version for global communication. LAST_SCN The major compaction version number of the last completed major compaction. LAST_FINISH_TIME The end time of the last major compaction. START_TIME The start time of the major compaction. STATUS The major compaction status. IDLE: Not in major compaction.COMPACTING: Major compaction is in progress.VERIFYING: Checking the checksum.
IS_ERROR YES: An error occurred during the major compaction.NO: No error occurred during the major compaction.
IS_SUSPENDED YES: The major compaction was suspended.NO: The major compaction was not suspended.
INFO Displays information about the major compaction. View the partition-level major compaction information of the current tenant by using the
GV$OB_TABLET_COMPACTION_HISTORYview.The
GV$OB_TABLET_COMPACTION_HISTORYview displays the historical details about major compactions at the tablet level.obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_TABLET_COMPACTION_HISTORY WHERE TABLET_ID=200001 ORDER BY START_TIME DESC LIMIT 2\GThe execution result is as follows:
*************************** 1. row *************************** SVR_IP: 172.xx.xxx.xxx SVR_PORT: 2882 TENANT_ID: 1002 LS_ID: 1001 TABLET_ID: 200001 TYPE: MAJOR_MERGE COMPACTION_SCN: 1748455203748142000 START_TIME: 2025-05-29 02:03:35.771081 FINISH_TIME: 2025-05-29 02:03:35.778086 TASK_ID: YB42AC1E87E0-000635386FA342D5-0-0 OCCUPY_SIZE: 0 MACRO_BLOCK_COUNT: 0 MULTIPLEXED_MACRO_BLOCK_COUNT: 0 NEW_MICRO_COUNT_IN_NEW_MACRO: 0 MULTIPLEXED_MICRO_COUNT_IN_NEW_MACRO: 0 TOTAL_ROW_COUNT: 0 INCREMENTAL_ROW_COUNT: 0 COMPRESSION_RATIO: 1 NEW_FLUSH_DATA_RATE: 0 PROGRESSIVE_COMPACTION_ROUND: 1 PROGRESSIVE_COMPACTION_NUM: 0 PARALLEL_DEGREE: 1 PARALLEL_INFO: - PARTICIPANT_TABLE: table_cnt=1,[MAJOR]snapshot_version=1748368801840485000; MACRO_ID_LIST: COMMENTS: START_CG_ID: 0 END_CG_ID: 0 KEPT_SNAPSHOT: {type:"UNDO_RETENTION", snapshot:1748453603923723000} MERGE_LEVEL: MICRO_BLOCK_LEVEL EXEC_MODE: EXEC_MODE_LOCAL IS_FULL_MERGE: FALSE IO_COST_TIME_PERCENTAGE: 0 MERGE_REASON: TENANT_MAJOR BASE_MAJOR_STATUS: CO_MERGE_TYPE: MDS_FILTER_INFO: *************************** 2. row *************************** SVR_IP: 172.xx.xxx.xxx SVR_PORT: 2882 TENANT_ID: 1002 LS_ID: 1001 TABLET_ID: 200001 TYPE: MDS_MINOR_MERGE COMPACTION_SCN: 1748398151630809003 START_TIME: 2025-05-28 10:09:12.139170 FINISH_TIME: 2025-05-28 10:09:12.145988 TASK_ID: YB42AC1E87E0-000635386FA3413D-0-0 OCCUPY_SIZE: 493 MACRO_BLOCK_COUNT: 1 MULTIPLEXED_MACRO_BLOCK_COUNT: 0 NEW_MICRO_COUNT_IN_NEW_MACRO: 1 MULTIPLEXED_MICRO_COUNT_IN_NEW_MACRO: 0 TOTAL_ROW_COUNT: 1 INCREMENTAL_ROW_COUNT: 1 COMPRESSION_RATIO: 1 NEW_FLUSH_DATA_RATE: 78 PROGRESSIVE_COMPACTION_ROUND: 0 PROGRESSIVE_COMPACTION_NUM: 0 PARALLEL_DEGREE: 1 PARALLEL_INFO: - PARTICIPANT_TABLE: table_cnt=2,start_scn=1,end_scn=1748398151630809003; MACRO_ID_LIST: 77871 COMMENTS: comment="cost_mb=2;"; START_CG_ID: 0 END_CG_ID: 0 KEPT_SNAPSHOT: MERGE_LEVEL: MACRO_BLOCK_LEVEL EXEC_MODE: EXEC_MODE_LOCAL IS_FULL_MERGE: FALSE IO_COST_TIME_PERCENTAGE: 3 MERGE_REASON: BASE_MAJOR_STATUS: CO_MERGE_TYPE: 2 rows in setThe values in the
TYPEcolumn have the following meanings:MDS_TABLE_MERGE: persists the system metadata to disk in the format of an SSTable.MAJOR_MERGE: tenant-level major compaction.MEDIUM_MERGE: partition-level major compaction.MINI_MERGE: mini compaction, which converts the MemTable to a Mini SSTable.MINOR_MERGE: minor compaction, which combines multiple Mini SSTables into one or combines multiple Mini SSTables with one Minor SSTable into one new Minor SSTable.META_MAJOR_MERGE: a special type of compaction that combines data before a specified point in time into one Meta Major SSTable. The data format of the Meta Major SSTable is the same as that of the Major SSTable, without multi-version data or uncommitted transaction data.
For more information about the columns in the
GV$OB_TABLET_COMPACTION_HISTORYview, see GV$OB_TABLET_COMPACTION_HISTORY.
View the tenant-level major compaction information of the current tenant by using the
DBA_OB_ZONE_MAJOR_COMPACTIONorDBA_OB_MAJOR_COMPACTIONview.The
DBA_OB_ZONE_MAJOR_COMPACTIONview displays the major compaction information of each zone in the current tenant.obclient [TEST]> SELECT * FROM SYS.DBA_OB_ZONE_MAJOR_COMPACTION;The execution result is as follows:
+-------+---------------------+----------+------------------+------------------+------------+ | ZONE | BROADCAST_SCN | LAST_SCN | LAST_FINISH_TIME | START_TIME | STATUS | +-------+---------------------+----------+------------------+------------------+------------+ | zone1 | 1748487596765126000 | 1 | 0 | 1748487596921347 | COMPACTING | +-------+---------------------+----------+------------------+------------------+------------+ 1 row in setObserve the
statuscolumn in the execution result. The following table describes some parameters.Parameter Description ZONE The name of the zone. BROADCAST_SCN The broadcasted major compaction version number. LAST_SCN The major compaction version number of the last major compaction. LAST_FINISH_TIME The end time of the last major compaction. START_TIME The start time of the major compaction. STATUS The major compaction status. IDLE: Not in major compaction.COMPACTING: Major compaction is in progress.VERIFYING: Checking the checksum.
The
DBA_OB_MAJOR_COMPACTIONview displays the global information about major compactions in the current tenant.obclient [TEST]> SELECT * FROM SYS.DBA_OB_MAJOR_COMPACTION;The execution result is as follows:
+---------------------+----------------------+----------+------------------+------------------+------------+----------+--------------+------+ | FROZEN_SCN | GLOBAL_BROADCAST_SCN | LAST_SCN | LAST_FINISH_TIME | START_TIME | STATUS | IS_ERROR | IS_SUSPENDED | INFO | +---------------------+----------------------+----------+------------------+------------------+------------+----------+--------------+------+ | 1748487596765126000 | 1748487596765126000 | 1 | 0 | 1748487596900693 | COMPACTING | NO | NO | NULL | +---------------------+----------------------+----------+------------------+------------------+------------+----------+--------------+------+ 1 row in setObserve the
statuscolumn in the execution result. The following table describes some parameters.Parameter Description FROZEN_SCN The version number of the last major compaction. GLOBAL_BROADCAST_SCN The broadcasted major compaction version for global communication. LAST_SCN The major compaction version number of the last completed major compaction. LAST_FINISH_TIME The end time of the last major compaction. START_TIME The start time of the major compaction. STATUS The major compaction status. IDLE: Not in major compaction.COMPACTING: Major compaction is in progress.VERIFYING: Checking the checksum.
IS_ERROR YES: An error occurred during the major compaction.NO: No error occurred during the major compaction.
IS_SUSPENDED YES: The major compaction was suspended.NO: The major compaction was not suspended.
INFO Displays information about the major compaction. View the partition-level major compaction information of the current tenant by using the
GV$OB_TABLET_COMPACTION_HISTORYview.The
GV$OB_TABLET_COMPACTION_HISTORYview displays the historical details about major compactions at the tablet level.obclient [TEST]> SELECT * FROM SYS.GV$OB_TABLET_COMPACTION_HISTORY WHERE TABLET_ID=200001 AND ROWNUM<=10 ORDER BY START_TIME\GThe execution result is as follows:
*************************** 1. row *************************** SVR_IP: 172.xx.xxx.xxx SVR_PORT: 2882 TENANT_ID: 1004 LS_ID: 1001 TABLET_ID: 200001 TYPE: MDS_MINOR_MERGE COMPACTION_SCN: 1748368803414843000 START_TIME: 28-MAY-25 02.00.05.107746 AM FINISH_TIME: 28-MAY-25 02.00.05.113086 AM TASK_ID: YB42AC1E87E0-00063538753335FD-0-0 OCCUPY_SIZE: 630 MACRO_BLOCK_COUNT: 1 MULTIPLEXED_MACRO_BLOCK_COUNT: 0 NEW_MICRO_COUNT_IN_NEW_MACRO: 1 MULTIPLEXED_MICRO_COUNT_IN_NEW_MACRO: 0 TOTAL_ROW_COUNT: 2 INCREMENTAL_ROW_COUNT: 2 COMPRESSION_RATIO: 1 NEW_FLUSH_DATA_RATE: 191 PROGRESSIVE_COMPACTION_ROUND: 0 PROGRESSIVE_COMPACTION_NUM: 0 PARALLEL_DEGREE: 1 PARALLEL_INFO: - PARTICIPANT_TABLE: table_cnt=2,start_scn=1,end_scn=1748368803414843000; MACRO_ID_LIST: 75689 COMMENTS: comment="cost_mb=2;"; START_CG_ID: 0 END_CG_ID: 0 KEPT_SNAPSHOT: NULL MERGE_LEVEL: MACRO_BLOCK_LEVEL EXEC_MODE: EXEC_MODE_LOCAL IS_FULL_MERGE: FALSE IO_COST_TIME_PERCENTAGE: 2 MERGE_REASON: NULL BASE_MAJOR_STATUS: NULL CO_MERGE_TYPE: NULL 1 row in setThe values in the
TYPEcolumn have the following meanings:MDS_TABLE_MERGE: persists the system metadata to disk in the format of an SSTable.MAJOR_MERGE: tenant-level major compaction.MEDIUM_MERGE: partition-level major compaction.MINI_MERGE: mini compaction, which converts the MemTable to a Mini SSTable.MINOR_MERGE: minor compaction, which combines multiple Mini SSTables into one or combines multiple Mini SSTables with one Minor SSTable into one new Minor SSTable.META_MAJOR_MERGE: a special type of compaction that combines data before a specified point in time into one Meta Major SSTable. The data format of the Meta Major SSTable is the same as that of the Major SSTable, without multi-version data or uncommitted transaction data.
For more information about the columns in the
GV$OB_TABLET_COMPACTION_HISTORYview, see GV$OB_TABLET_COMPACTION_HISTORY.