GV$OB_MERGE_INFO

2025-12-03 11:18:03  Updated

Metrics

The metrics displayed on this page show the statistics of compactions completed in the OceanBase cluster.

Note

Introduced in OceanBase Database V4.0.0.

Field descriptions

Field name 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.
  • MDS_TABLE_MERGE: The system metadata is persisted to the disk in the SSTable format.
  • MAJOR_MERGE: A tenant-level major compaction.
  • MEDIUM_MERGE: A partition-level major compaction.
  • MINI_MERGE: A mini compaction that converts MemTables into a SSTable.
  • MINOR_MERGE: A minor compaction that merges multiple SSTables into a new SSTable or a minor SSTable into a new minor SSTable.
  • META_MAJOR_MERGE: A special type of compaction that synthesizes the data generated before a specified time point into a Meta Major SSTable. The data in a Meta Major SSTable is in the same format as that in a Major SSTable and 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