V$OB_MERGE_INFO

2025-12-03 11:18:03  Updated

Metrics

Displays the statistics of compactions completed in the OceanBase cluster.

Note

Introduced in OceanBase Database V4.0.0.

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 ID of the tenant.
LS_ID bigint(20) NO The ID of the log stream.
TABLET_ID bigint(20) NO The ID of the data shard.
ACTION varchar(64) NO The specific action of the compaction. The following actions are supported:
  • MDS_TABLE_MERGE: The system metadata is persisted to disk in the format of SSTable.
  • MAJOR_MERGE: A tenant-level major compaction.
  • MEDIUM_MERGE: A partition-level minor compaction.
  • MINI_MERGE: A mini compaction that converts MemTables into a SSTable.
  • MINOR_MERGE: A minor compaction that combines multiple SSTables into a new SSTable or combines a SSTable with a minor SSTable into a new minor SSTable.
  • META_MAJOR_MERGE: A special type of compaction that synthesizes data generated before a specified time point into a Meta Major SSTable. The data format of a Meta Major SSTable is the same as that of a major SSTable, but does not contain multi-version data or uncommitted transactions.
COMPACTION_SCN bigint(20) unsigned NO The version number of the compaction.
START_TIME timestamp(6) NO The start time of the compaction.
END_TIME timestamp(6) NO The end time of the compaction.
MACRO_BLOCK_COUNT bigint(20) NO The total number of macroblocks in the compaction.
REUSE_PCT decimal(26,2) NO The reuse rate of macroblocks in the compaction.
PARALLEL_DEGREE bigint(20) NO The degree of parallelism of the compaction.

Contact Us