Note
This view is available starting with V4.0.0.
Purpose
This view displays compaction suggestions 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 compaction. Valid values:
MDS_TABLE_MERGE: persists 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 a new Mini SSTable or combines multiple Mini SSTables with one Minor SSTable into a new Minor SSTable.META_MAJOR_MERGE: 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 ID of the log stream. |
| TABLET_ID |
bigint(20) |
NO |
The ID of the data tablet. |
| START_TIME |
timestamp(6) |
NO |
The start time. |
| FINISH_TIME |
timestamp(6) |
NO |
The end time. |
| SUGGESTION |
varchar(1024) |
NO |
The suggestion. |
