GV$OB_TABLET_COMPACTION_PROGRESS

2025-12-04 02:53:14  Updated

Note

Introduced in MySQL 4.0.0.

Description

Displays the progress of major compactions at the tablet level.

Field descriptions

Field Type Nullable Description
SVR_IP varchar(46) NO The IP address of the server.
SVR_PORT bigint(20) NO The port number of the server.
TENANT_ID bigint(20) NO The tenant ID.
TYPE varchar(64) NO The type of compaction:
  • MDS_TABLE_MERGE: the system metadata is persisted to the disk in the SSTable format.
  • MAJOR_MERGE: a major compaction at the tenant level.
  • MEDIUM_MERGE: a major compaction at the partition level.
  • MINI_MERGE: a minor compaction, which converts MemTables into a Mini SSTable.
  • MINOR_MERGE: a minor compaction, which merges multiple Mini SSTables into a new one or a minor compaction, which merges a few Mini SSTables and a minor SSTable into a new one.
  • META_MAJOR_MERGE: a special type of compaction that synthesizes data existing before a specified time point into a Meta Major SSTable. The data in this table is stored in the same format as that in a Major SSTable and does not contain multi-version data or uncommitted transaction data.
LS_ID bigint(20) NO The ID of the log stream.
TABLET_ID bigint(20) NO The ID of the data shard.
COMPACTION_SCN bigint(20) unsigned NO The version information of the compaction.
TASK_ID varchar(64) NO The trace ID of the executed task.
STATUS varchar(15) NO The status of the task.
DATA_SIZE bigint(20) NO The total data amount to be scanned.
UNFINISHED_DATA_SIZE bigint(20) NO The data amount that remains to be scanned.
PROGRESSIVE_COMPACTION_ROUND bigint(20) NO The round of progressive compaction.
CREATE_TIME timestamp(6) NO The creation time of the task.
START_TIME timestamp(6) NO The start time.
ESTIMATED_FINISH_TIME timestamp(6) NO The estimated finish time.
START_CG_ID bigint(20) NO The start ID of the column group

Note

This field is introduced in V4.3.0.

.
END_CG_ID bigint(20) NO The end ID of the column group

Note

This field is introduced in V4.3.0.

.

Contact Us