Overview
v$merge_info displays statistics related to compactions that have been completed in the OceanBase cluster.
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(32) | No | The IP address of the OBServer. |
| SVR_PORT | BIGINT(20) | No | The port number of the OBServer. |
| TENANT_ID | BIGINT(20) | No | The ID of the tenant. |
| TABLE_ID | BIGINT(20) | No | The ID of the table. |
| PARTITION_ID | BIGINT(20) | No | The ID of the partition. |
| TYPE | varchar(5) | No | The type of the compaction. Valid values: * minor * major |
| ACTION | varchar(64) | No | The specific compaction action. Valid values: * mini * mini minor * buffer minor * minor |
| VERSION | varchar(64) | No | The version of the compaction. |
| START_TIME | TIMESTAMP(6) | No | The time when the compaction started. |
| END_TIME | TIMESTAMP(6) | No | The time when the compaction ended. |
| MACRO_BLOCK_COUNT | BIGINT(20) | No | The total number of macro blocks in the compaction. |
| REUSE_PCT | DECIMAL(26,2) | No | The reuse rate of macro blocks in the compaction. |
| PARALLEL_DEGREE | BIGINT(20) | No | The degree of parallelism of the compaction. |