Note
This view is available starting with V4.0.0.
Purpose
This view displays the diagnostic information of compactions on the current node.
Columns
| Column |
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 the compaction. Valid values:
MDS_TABLE_MERGE: persists the system metadata in SSTable format to disk.MAJOR_MERGE: major compaction at the tenant level.MEDIUM_MERGE: medium compaction at the partition level.MINI_MERGE: mini compaction. Converts a MemTable to a Mini SSTable.MINOR_MERGE: minor compaction. Combines multiple Mini SSTables into one Mini SSTable, or combines multiple Mini SSTables with one Minor SSTable into one Minor SSTable.META_MAJOR_MERGE: a special type of compaction. Combines data from a specified time point into a Meta Major SSTable. The data format is the same as that of a Major SSTable, and the data does not contain multi-version data or uncommitted transaction data. |
| LS_ID |
bigint(20) |
NO |
The log stream ID. |
| TABLET_ID |
bigint(20) |
NO |
The data tablet ID. |
| STATUS |
varchar(15) |
NO |
The task status. |
| CREATE_TIME |
timestamp(6) |
NO |
The creation time. |
| DIAGNOSE_INFO |
varchar(1024) |
NO |
The diagnostic information. |
