Purpose
The GV$OB_COMPACTION_DIAGNOSE_INFO view displays the compaction diagnostic information.
Note
This view was introduced in OceanBase Database V4.0.0.
Columns
| Column |
Type |
Nullable? |
Description |
| SVR_IP |
varchar(46) |
NO |
The IP address of the OBServer node. |
| SVR_PORT |
bigint(20) |
NO |
The port number of the OBServer node. |
| TENANT_ID |
bigint(20) |
NO |
The ID of the tenant. |
| TYPE |
varchar(64) |
NO |
The compaction type. Valid values:
MDS_TABLE_MERGE: indicates to persist system metadata to the disk in the SSTable format.MAJOR_MERGE: indicates a tenant-level major compaction.MEDIUM_MERGE: indicates a partition-level major compaction.MINI_MERGE: indicates a mini compaction that converts a MemTable to a mini SSTable.MINOR_MERGE: indicates a minor compaction that combines multiple mini SSTables or multple mini SSTables and minor SSTables into one minor SSTable.META_MAJOR_MERGE: indicates a special compaction type that compacts the data generated before a specified point in time into a meta major SSTable, which has the same data format as a major SSTable but does not contain multi-version data or data of uncommitted transactions. |
| LS_ID |
bigint(20) |
NO |
The ID of the log stream. |
| TABLET_ID |
bigint(20) |
NO |
The ID of the tablet. |
| STATUS |
varchar(15) |
NO |
The status of the task. |
| CREATE_TIME |
timestamp(6) |
NO |
The creation time. |
| DIAGNOSE_INFO |
varchar(1024) |
NO |
The diagnostic information. |
