After you initiate a major compaction, you can query views for major compaction information.
You can query the major compaction process from views. Generally, the time required for a major compaction depends on the amount of data changed since the last major compaction. The time required by a major compaction increases when the amount of changed data increases after the last major compaction. The time required by a major compaction is also affected by the number of threads used for the compaction and the load of the cluster during the compaction.
View the major compaction information of all tenants in the sys tenant
You can query views in the sys tenant for information about tenant-level and partition-level major compactions of all tenants.
Log on to the
systenant of the cluster as therootuser.Execute the following statements to view major compaction information.
Query the
CDB_OB_ZONE_MAJOR_COMPACTIONorCDB_OB_MAJOR_COMPACTIONview for tenant-level major compaction information.The
CDB_OB_ZONE_MAJOR_COMPACTIONview displays the major compaction information of each zone in all tenants.obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION\GThe query result is as follows:
*************************** 1. row *************************** TENANT_ID: 1 ZONE: zone1 BROADCAST_VERSION: 1657130401540694079 LAST_VERSION: 1657130401540694079 LAST_FINISH_TIME: 2022-07-07 02:00:11.646856 START_TIME: 2022-07-07 02:00:01.604192 STATUS: IDLE IS_ERROR: NO INFO: *************************** 2. row *************************** TENANT_ID: 1001 ZONE: zone1 BROADCAST_VERSION: 1657130404994417856 LAST_VERSION: 1657130404994417856 LAST_FINISH_TIME: 2022-07-07 02:06:06.475449 START_TIME: 2022-07-07 02:00:05.008268 STATUS: IDLE IS_ERROR: NO INFO: *************************** 3. row *************************** TENANT_ID: 1002 ZONE: zone1 BROADCAST_VERSION: 1657130404995985329 LAST_VERSION: 1657130404995985329 LAST_FINISH_TIME: 2022-07-07 02:04:38.954977 START_TIME: 2022-07-07 02:00:05.064080 STATUS: IDLE IS_ERROR: NO INFO: *************************** 4. row *************************** TENANT_ID: 1003 ZONE: zone1 BROADCAST_VERSION: 1657130401541700827 LAST_VERSION: 1657130401541700827 LAST_FINISH_TIME: 2022-07-07 02:04:57.750464 START_TIME: 2022-07-07 02:00:01.658430 STATUS: IDLE IS_ERROR: NO INFO: *************************** 5. row *************************** TENANT_ID: 1004 ZONE: zone1 BROADCAST_VERSION: 1657130401542173174 LAST_VERSION: 1657130401542173174 LAST_FINISH_TIME: 2022-07-07 02:05:38.452746 START_TIME: 2022-07-07 02:00:01.658391 STATUS: IDLE IS_ERROR: NO INFO: *************************** 6. row *************************** TENANT_ID: 1007 ZONE: zone1 BROADCAST_VERSION: 1657130402418968296 LAST_VERSION: 1657130402418968296 LAST_FINISH_TIME: 2022-07-07 02:04:24.919463 START_TIME: 2022-07-07 02:00:02.529412 STATUS: IDLE IS_ERROR: NO INFO: *************************** 7. row *************************** TENANT_ID: 1008 ZONE: zone1 BROADCAST_VERSION: 1657130402672739296 LAST_VERSION: 1657130402672739296 LAST_FINISH_TIME: 2022-07-07 02:05:09.385212 START_TIME: 2022-07-07 02:00:02.744969 STATUS: IDLE IS_ERROR: NO INFO: 7 rows in setCheck the value in the
STATUScolumn in the execution result. The following table describes the columns in the execution result.Column Description TENANT_ID The ID of the tenant. ZONE The name of the zone. BROADCAST_VERSION The major compaction version that is broadcast. LAST_VERSION The version number of the last major compaction. LAST_FINISH_TIME The time when the last major compaction was completed. START_TIME The time when the major compaction started. STATUS The major compaction status. Valid values: IDLE: No major compaction is in progress.COMPACTING: A major compaction is in progress.VERIFYING: The checksum is being verified.
IS_ERROR Indicates whether an error occurred during the major compaction. Valid values: YESNO
INFO The major compaction information. The
CDB_OB_MAJOR_COMPACTIONview displays the global major compaction information of all tenants.obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_MAJOR_COMPACTION\GThe query result is as follows:
*************************** 1. row *************************** TENANT_ID: 1 FROZEN_SNAPSHOT: 1657130401540694079 FROZEN_TIME: 2022-07-07 02:00:01.540694 GLOBAL_BROADCAST_VERSION: 1657130401540694079 LAST_VERSION: 1657130401540694079 LAST_FINISH_TIME: 2022-07-07 02:00:11.651551 START_TIME: 2022-07-07 02:00:01.600871 STATUS: IDLE IS_ERROR: NO IS_SUSPENDED: NO INFO: *************************** 2. row *************************** TENANT_ID: 1001 FROZEN_SNAPSHOT: 1657130404994417856 FROZEN_TIME: 2022-07-07 02:00:04.994418 GLOBAL_BROADCAST_VERSION: 1657130404994417856 LAST_VERSION: 1657130404994417856 LAST_FINISH_TIME: 2022-07-07 02:06:06.480182 START_TIME: 2022-07-07 02:00:05.004782 STATUS: IDLE IS_ERROR: NO IS_SUSPENDED: NO INFO: *************************** 3. row *************************** TENANT_ID: 1002 FROZEN_SNAPSHOT: 1657130404995985329 FROZEN_TIME: 2022-07-07 02:00:04.995985 GLOBAL_BROADCAST_VERSION: 1657130404995985329 LAST_VERSION: 1657130404995985329 LAST_FINISH_TIME: 2022-07-07 02:04:39.318737 START_TIME: 2022-07-07 02:00:05.060462 STATUS: IDLE IS_ERROR: NO IS_SUSPENDED: NO INFO: *************************** 4. row *************************** TENANT_ID: 1003 FROZEN_SNAPSHOT: 1657130401541700827 FROZEN_TIME: 2022-07-07 02:00:01.541701 GLOBAL_BROADCAST_VERSION: 1657130401541700827 LAST_VERSION: 1657130401541700827 LAST_FINISH_TIME: 2022-07-07 02:04:57.764742 START_TIME: 2022-07-07 02:00:01.654864 STATUS: IDLE IS_ERROR: NO IS_SUSPENDED: NO INFO: *************************** 5. row *************************** TENANT_ID: 1004 FROZEN_SNAPSHOT: 1657130401542173174 FROZEN_TIME: 2022-07-07 02:00:01.542173 GLOBAL_BROADCAST_VERSION: 1657130401542173174 LAST_VERSION: 1657130401542173174 LAST_FINISH_TIME: 2022-07-07 02:05:38.456814 START_TIME: 2022-07-07 02:00:01.654895 STATUS: IDLE IS_ERROR: NO IS_SUSPENDED: NO INFO: *************************** 6. row *************************** TENANT_ID: 1007 FROZEN_SNAPSHOT: 1657130402418968296 FROZEN_TIME: 2022-07-07 02:00:02.418968 GLOBAL_BROADCAST_VERSION: 1657130402418968296 LAST_VERSION: 1657130402418968296 LAST_FINISH_TIME: 2022-07-07 02:04:24.928647 START_TIME: 2022-07-07 02:00:02.522797 STATUS: IDLE IS_ERROR: NO IS_SUSPENDED: NO INFO: *************************** 7. row *************************** TENANT_ID: 1008 FROZEN_SNAPSHOT: 1657130402672739296 FROZEN_TIME: 2022-07-07 02:00:02.672739 GLOBAL_BROADCAST_VERSION: 1657130402672739296 LAST_VERSION: 1657130402672739296 LAST_FINISH_TIME: 2022-07-07 02:05:09.389730 START_TIME: 2022-07-07 02:00:02.741418 STATUS: IDLE IS_ERROR: NO IS_SUSPENDED: NO INFO: 7 rows in setCheck the value in the
STATUScolumn in the execution result. The following table describes the columns in the execution result.Column Description TENANT_ID The ID of the tenant. FROZEN_SNAPSHOT The latest major compaction snapshot. FROZEN_TIME The value of FROZEN_SCNin the form of readable time.GLOBAL_BROADCAST_VERSION The major compaction version that is globally broadcast. LAST_VERSION The version of the last major compaction. LAST_FINISH_TIME The time when the last major compaction was completed. START_TIME The time when the major compaction started. STATUS The major compaction status. Valid values: IDLE: No major compaction is in progress.COMPACTING: A major compaction is in progress.VERIFYING: The checksum is being verified.
IS_ERROR Indicates whether an error occurred during the major compaction. Valid values: YESNO
IS_SUSPENDED Indicates whether the major compaction is suspended. Valid values: YESNO
INFO The major compaction information. Query the
GV$OB_MERGE_INFOorGV$OB_TABLET_COMPACTION_HISTORYview for partition-level major compaction information.The
GV$OB_MERGE_INFOview displays the basic statistics of tablet-level 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 of the
ACTIONcolumn in the query result are described as follows:MDS_TABLE_MERGE: indicates a multi-source minor compaction.MAJOR_MERGE: indicates a tenant-level major compaction.MEDIUM_MERGE: indicates a partition-level major compaction.MINI_MERGE: indicates a minor or L0 compaction that converts MemTables into SSTables.MINOR_MERGE: indicates an L1 compaction that combines multiple mini SSTables into one.META_MAJOR_MERGE: indicates a special compaction type that compacts the data generated before a specified point in time into a meta major SSTable, which has the same data format as a major SSTable but does not contain multi-version data or data of uncommitted transactions.
For more information about columns in the
GV$OB_MERGE_INFOview, see GV$OB_MERGE_INFO.The
GV$OB_TABLET_COMPACTION_HISTORYview displays the tablet-level major compaction history.obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_TABLET_COMPACTION_HISTORY 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 | 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 | START_CG_ID | END_CG_ID | KEPT_SNAPSHOT | MERGE_LEVEL | +----------------+----------+-----------+-------+-----------+-----------------+---------------------+----------------------------+----------------------------+-----------------------------------+-------------+-------------------+-------------------------------+------------------------------+--------------------------------------+-----------------+-----------------------+-------------------+---------------------+------------------------------+----------------------------+-----------------+---------------+----------------------------------------------------------+---------------+-----------------------------------------------------------------------------------------------------------+-------------+-----------+----------------------------------------------------------------+-------------------+ | 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 | YB42AC1E87CA-00060FAC10C57D5C-0-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | - | table_cnt=1,[MAJOR]snapshot_version=1706086435242718629; | | comment="merge_reason="TENANT_MAJOR";time=add_time:1706119382538344|wait_schedule_time=1.34s|total=53.;"; | 0 | 0 | {type:"SNAPSHOT_UNDO_RETENTION", snapshot:1706117574893656222} | MICRO_BLOCK_LEVEL | | 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 | YB42AC1E87CA-00060FAC10C5797A-0-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | - | | | comment="time=add_time:1706086732078234|total=2.29ms;"; | 0 | 0 | | MICRO_BLOCK_LEVEL | | 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 | YB42AC1E87CA-00060FAC10C57979-0-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | - | table_cnt=1,[MAJOR]snapshot_version=1; | | comment="merge_reason="USER_REQUEST";time=add_time:1706086617297507|total=7.96ms;"; | 0 | 0 | {type:"SNAPSHOT_UNDO_RETENTION", snapshot:1706084810844670506} | MACRO_BLOCK_LEVEL | | 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 | YB42AC1E87CA-00060FAC10C57971-0-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | - | | | comment="time=add_time:1706086357066962|total=2.63ms;"; | 0 | 0 | | MICRO_BLOCK_LEVEL | +----------------+----------+-----------+-------+-----------+-----------------+---------------------+----------------------------+----------------------------+-----------------------------------+-------------+-------------------+-------------------------------+------------------------------+--------------------------------------+-----------------+-----------------------+-------------------+---------------------+------------------------------+----------------------------+-----------------+---------------+----------------------------------------------------------+---------------+-----------------------------------------------------------------------------------------------------------+-------------+-----------+----------------------------------------------------------------+-------------------+ 4 rows in setThe values of the
TYPEcolumn in the query result are described as follows:MDS_TABLE_MERGE: indicates a multi-source minor compaction.MAJOR_MERGE: indicates a tenant-level major compaction.MEDIUM_MERGE: indicates a partition-level major compaction.MINI_MERGE: indicates a minor or L0 compaction that converts MemTables into SSTables.MINOR_MERGE: indicates an L1 compaction that combines multiple mini SSTables into one.META_MAJOR_MERGE: indicates a special compaction type that compacts the data generated before a specified point in time into a meta major SSTable, which has the same data format as a major SSTable but does not contain multi-version data or data of uncommitted transactions.
For more information about columns in the
GV$OB_TABLET_COMPACTION_HISTORYview, see GV$OB_TABLET_COMPACTION_HISTORY.
View the major compaction information of the current user tenant
You can query views in a user tenant for major compaction information of the current tenant.
Log on to the database as an administrator of a user tenant.
Execute the following statements to view major compaction information.
Query the
DBA_OB_ZONE_MAJOR_COMPACTIONorDBA_OB_MAJOR_COMPACTIONview for tenant-level major compaction information of the current tenant.The
DBA_OB_ZONE_MAJOR_COMPACTIONview displays the major compaction information of each zone of the current tenant.MySQL modeOracle modeHere is an example in MySQL mode:
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION\GHere is an example in Oracle mode:
obclient [TEST]> SELECT * FROM SYS.DBA_OB_ZONE_MAJOR_COMPACTION\GThe query result is as follows:
*************************** 1. row *************************** ZONE: zone1 BROADCAST_VERSION: 1 LAST_VERSION: 1 LAST_FINISH_TIME: 1970-01-01 08:00:00.000000 START_TIME: 1970-01-01 08:00:00.000000 STATUS: IDLE IS_ERROR: NO INFO: 1 row in setCheck the value in the
STATUScolumn in the execution result. The following table describes the columns in the execution result.Column Description ZONE The name of the zone. BROADCAST_VERSION The major compaction version that is broadcast. LAST_VERSION The version number of the last major compaction. LAST_FINISH_TIME The time when the last major compaction was completed. START_TIME The time when the major compaction started. STATUS The major compaction status. Valid values: IDLE: No major compaction is in progress.COMPACTING: A major compaction is in progress.VERIFYING: The checksum is being verified.
IS_ERROR Indicates whether an error occurred during the major compaction. Valid values: YESNO
INFO The major compaction information. The
DBA_OB_MAJOR_COMPACTIONview displays the global major compaction information of the current tenant.MySQL modeOracle modeHere is an example in MySQL mode:
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_MAJOR_COMPACTION\GHere is an example in Oracle mode:
obclient [TEST]> SELECT * FROM SYS.DBA_OB_MAJOR_COMPACTION\GCheck the value in the
STATUScolumn in the execution result. The following table describes the columns in the execution result.Column Description FROZEN_SNAPSHOT The latest major compaction snapshot. FROZEN_TIME The value of FROZEN_SCNin the form of readable time.GLOBAL_BROADCAST_VERSION The major compaction version that is globally broadcast. LAST_VERSION The version of the last major compaction. LAST_FINISH_TIME The time when the last major compaction was completed. START_TIME The time when the major compaction started. STATUS The major compaction status. Valid values: IDLE: No major compaction is in progress.COMPACTING: A major compaction is in progress.VERIFYING: The checksum is being verified.
IS_ERROR Indicates whether an error occurred during the major compaction. Valid values: YESNO
IS_SUSPENDED Indicates whether the major compaction is suspended. Valid values: YESNO
INFO The major compaction information. Query the
GV$OB_TABLET_COMPACTION_HISTORYview for partition-level major compaction information of the current tenant.The
GV$OB_TABLET_COMPACTION_HISTORYview displays the tablet-level major compaction history.MySQL modeOracle modeHere is an example in MySQL mode:
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_TABLET_COMPACTION_HISTORY WHERE TABLET_ID=200001 ORDER BY START_TIME DESC LIMIT 10\GHere is an example in Oracle mode:
obclient [TEST]> SELECT * FROM SYS.GV$OB_TABLET_COMPACTION_HISTORY WHERE TABLET_ID=200001 AND ROWNUM<=10 ORDER BY START_TIME\GThe query result is as follows:
+----------------+----------+-----------+-------+-----------+-----------------+---------------------+------------------------------+------------------------------+-----------------------------------+-------------+-------------------+-------------------------------+------------------------------+--------------------------------------+-----------------+-----------------------+-------------------+---------------------+------------------------------+----------------------------+-----------------+---------------+----------------------------------------+---------------+-------------------------------------------------------------------------------------+-------------+-----------+ | 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 | START_CG_ID | END_CG_ID | +----------------+----------+-----------+-------+-----------+-----------------+---------------------+------------------------------+------------------------------+-----------------------------------+-------------+-------------------+-------------------------------+------------------------------+--------------------------------------+-----------------+-----------------------+-------------------+---------------------+------------------------------+----------------------------+-----------------+---------------+----------------------------------------+---------------+-------------------------------------------------------------------------------------+-------------+-----------+ | 172.xx.xxx.xxx | 2882 | 1004 | 1001 | 200001 | MDS_TABLE_MERGE | 1706086090286179071 | 24-JAN-24 04.48.10.406906 PM | 24-JAN-24 04.48.10.410714 PM | YB42AC1E87CA-00060FAC16A5796B-0-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | - | NULL | NULL | comment="time=add_time:1706086090406790|total=3.81ms;"; | 0 | 0 | | 172.xx.xxx.xxx | 2882 | 1004 | 1001 | 200001 | MAJOR_MERGE | 1706119203390704409 | 25-JAN-24 02.02.26.660093 AM | 25-JAN-24 02.02.26.668066 AM | YB42AC1E87CA-00060FAC16A57C1C-0-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | - | table_cnt=1,[MAJOR]snapshot_version=1; | NULL | comment="merge_reason="TENANT_MAJOR";time=add_time:1706119345834256|total=7.97ms;"; | 0 | 0 | +----------------+----------+-----------+-------+-----------+-----------------+---------------------+------------------------------+------------------------------+-----------------------------------+-------------+-------------------+-------------------------------+------------------------------+--------------------------------------+-----------------+-----------------------+-------------------+---------------------+------------------------------+----------------------------+-----------------+---------------+----------------------------------------+---------------+-------------------------------------------------------------------------------------+-------------+-----------+ 2 rows in setThe values of the
TYPEcolumn in the query result are described as follows:MDS_TABLE_MERGE: indicates a multi-source minor compaction.MAJOR_MERGE: indicates a tenant-level major compaction.MEDIUM_MERGE: indicates a partition-level major compaction.MINI_MERGE: indicates a minor or L0 compaction that converts MemTables into SSTables.MINOR_MERGE: indicates an L1 compaction that combines multiple mini SSTables into one.META_MAJOR_MERGE: indicates a special compaction type that compacts the data generated before a specified point in time into a meta major SSTable, which has the same data format as a major SSTable but does not contain multi-version data or data of uncommitted transactions.
For more information about columns in the
GV$OB_TABLET_COMPACTION_HISTORYview, see GV$OB_TABLET_COMPACTION_HISTORY.