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