After you initiate a minor compaction, you can query the minor compaction progress and history in views.
View the minor compaction progress
Log on to the
systenant or a user tenant as the administrator.View the progress information such as the amount of data that has not been compacted and the estimated completion time.
The
GV$OB_TABLET_COMPACTION_PROGRESSview displays progress information of only ongoing tablet-level compaction tasks but not completed tasks. The query statements are as follows:View the minor compaction progress from the
systenantobclient> SELECT * FROM oceanbase.GV$OB_TABLET_COMPACTION_PROGRESS WHERE TYPE='MINI_MERGE'\GView the minor compaction progress from a user tenant
MySQL mode
obclient> SELECT * FROM oceanbase.GV$OB_TABLET_COMPACTION_PROGRESS WHERE TYPE='MINI_MERGE'\GOracle mode
obclient> SELECT * FROM SYS.GV$OB_TABLET_COMPACTION_PROGRESS WHERE TYPE='MINI_MERGE'\G
A sample query result is as follows:
*************************** 1. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2401 TENANT_ID: 1002 TYPE: MINI_MERGE LS_ID: 1001 TABLET_ID: 1152921504606847235 COMPACTION_SCN: 1680514780195130031 TASK_ID: Y9610BA2DA3E-0005F7FD6E1FE0FF-0-0 STATUS: NODE_RUNNING DATA_SIZE: 31890729 UNFINISHED_DATA_SIZE: 3351030 PROGRESSIVE_COMPACTION_ROUND: 1 CREATE_TIME: 2023-04-03 17:49:17.278506 START_TIME: 2023-04-03 17:51:57.953999 ESTIMATED_FINISH_TIME: 2023-04-03 23:32:25.969930 1 row in setFields in the query result are described as follows:
TYPE: the type of the compaction task. Valid values include the following ones:MINOR_MERGE: indicates a minor merge task that compacts multiple mini SSTables into a minor SSTable.MINI_MERGE: indicates a minor compaction task that freezes and flushes the MemTable into a mini SSTable.MEDIUM_MERGE: indicates a partition-level major compaction.MAJOR_MERGE: indicates a major compaction.META_MAJOR_MERGE: indicates a buffer table-level major compaction.
STATUS: the status of the compaction task. The valueNODE_RUNNINGindicates that the compaction task is running.DATA_SIZE: the total amount of data to be compacted.UNFINISHED_DATA_SIZE: the amount of data that has not been compacted.ESTIMATED_FINISH_TIME: the estimated time when the compaction task is completed.
For more information about columns in the
GV$OB_TABLET_COMPACTION_PROGRESSview, see GV$OB_TABLET_COMPACTION_PROGRESS.If a tablet does not appear in this view or the minor compaction remains unfinished for a tablet after a long period of time, you can query the
GV$OB_COMPACTION_DIAGNOSE_INFOview to verify whether an exception occurs.For more information about columns in the
GV$OB_COMPACTION_DIAGNOSE_INFOview, see GV$OB_COMPACTION_DIAGNOSE_INFO.
View the minor compaction history
Log on to the
systenant or a user tenant as the administrator.View the minor compaction history.
The
GV$OB_TABLET_COMPACTION_HISTORYview displays the tablet-level compaction history. The query statements are as follows:View the minor compaction history from the
systenantobclient> SELECT * FROM oceanbase.GV$OB_TABLET_COMPACTION_HISTORY WHERE TYPE='MINI_MERGE'\GView the minor compaction history from a user tenant
MySQL mode
obclient> SELECT * FROM oceanbase.GV$OB_TABLET_COMPACTION_HISTORY WHERE TYPE='MINI_MERGE'\GOracle mode
obclient> SELECT * FROM SYS.GV$OB_TABLET_COMPACTION_HISTORY WHERE TYPE='MINI_MERGE'\G
A sample query result is as follows:
*************************** 1. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 TENANT_ID: 1002 LS_ID: 1001 TABLET_ID: 200001 TYPE: MINI_MERGE COMPACTION_SCN: 1680142515939965301 START_TIME: 2023-03-30 10:15:20.433070 FINISH_TIME: 2023-03-30 10:15:20.433444 TASK_ID: YB42AC1E87CC-0005F7EE202A5810-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: 0 PROGRESSIVE_COMPACTION_NUM: 0 PARALLEL_DEGREE: 1 PARALLEL_INFO: - PARTICIPANT_TABLE: table_cnt=1,start_scn=1,end_scn=1680142515939965301; MACRO_ID_LIST: COMMENTS: time_guard=EXECUTE=892us|(0.49)|UPDATE_TABLET=605us|(0.33)|total=1.82ms; *************************** 2. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 TENANT_ID: 1002 LS_ID: 1001 TABLET_ID: 200001 TYPE: MINI_MERGE COMPACTION_SCN: 1680199217439878616 START_TIME: 2023-03-31 02:00:21.835832 FINISH_TIME: 2023-03-31 02:00:21.836314 TASK_ID: YB42AC1E87CC-0005F7EE202A5C53-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: 0 PROGRESSIVE_COMPACTION_NUM: 0 PARALLEL_DEGREE: 1 PARALLEL_INFO: - PARTICIPANT_TABLE: table_cnt=1,start_scn=1680142515939965301,end_scn=1680199217439878616; MACRO_ID_LIST: COMMENTS: new_medium_list:{cnt=1;1680199204727259164}|time_guard=EXECUTE=629us|(0.39)|UPDATE_TABLET=696us|(0.43)|total=1.61ms; *************************** 3. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 TENANT_ID: 1002 LS_ID: 1001 TABLET_ID: 200001 TYPE: MINI_MERGE COMPACTION_SCN: 1680285613573143617 START_TIME: 2023-04-01 02:00:14.248500 FINISH_TIME: 2023-04-01 02:00:14.248823 TASK_ID: YB42AC1E87CC-0005F7EE202A5F84-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: 0 PROGRESSIVE_COMPACTION_NUM: 0 PARALLEL_DEGREE: 1 PARALLEL_INFO: - PARTICIPANT_TABLE: table_cnt=1,start_scn=1680199217439878616,end_scn=1680285613573143617; MACRO_ID_LIST: COMMENTS: new_medium_list:{cnt=1;1680285601108938417}|time_guard=EXECUTE=528us|(0.22)|UPDATE_TABLET=1.58ms|(0.64)|total=2.45ms; *************************** 4. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 TENANT_ID: 1002 LS_ID: 1001 TABLET_ID: 200001 TYPE: MINI_MERGE COMPACTION_SCN: 1680372014559392064 START_TIME: 2023-04-02 02:00:16.549722 FINISH_TIME: 2023-04-02 02:00:16.550169 TASK_ID: YB42AC1E87CC-0005F7EE202A640F-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: 0 PROGRESSIVE_COMPACTION_NUM: 0 PARALLEL_DEGREE: 1 PARALLEL_INFO: - PARTICIPANT_TABLE: table_cnt=1,start_scn=1680285613573143617,end_scn=1680372014559392064; MACRO_ID_LIST: COMMENTS: new_medium_list:{cnt=1;1680372002531630824}|time_guard=EXECUTE=635us|(0.47)|UPDATE_TABLET=476us|(0.35)|total=1.35ms; *************************** 5. row *************************** SVR_IP: xx.xx.xx.xx SVR_PORT: 2882 TENANT_ID: 1002 LS_ID: 1001 TABLET_ID: 200001 TYPE: MINI_MERGE COMPACTION_SCN: 1680458416863471713 START_TIME: 2023-04-03 02:00:18.737260 FINISH_TIME: 2023-04-03 02:00:18.737475 TASK_ID: YB42AC1E87CC-0005F7EE202A6851-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: 0 PROGRESSIVE_COMPACTION_NUM: 0 PARALLEL_DEGREE: 1 PARALLEL_INFO: - PARTICIPANT_TABLE: table_cnt=1,start_scn=1680372014559392064,end_scn=1680458416863471713; MACRO_ID_LIST: COMMENTS: new_medium_list:{cnt=1;1680458404011443372}|time_guard=EXECUTE=334us|(0.46)|CREATE_SSTABLE=125us|(0.17)|UPDATE_TABLET=173us|(0.24)|total=733us; 5 rows in setFor more information about the columns in the
GV$OB_TABLET_COMPACTION_HISTORYview, see GV$OB_TABLET_COMPACTION_HISTORY.