Note
This view is available starting with V4.0.0.
Purpose
This view displays the compaction suggestions 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 compaction. Valid values:
MDS_TABLE_MERGE: persists the system's metadata in SSTable format to disk.MAJOR_MERGE: major compaction at the tenant level.MEDIUM_MERGE: medium compaction at the partition level.MINI_MERGE: minor compaction, which converts a MemTable to a Mini SSTable.MINOR_MERGE: minor compaction, which merges multiple Mini SSTables into a new Mini SSTable or merges multiple Mini SSTables with one Minor SSTable into a new Minor SSTable.META_MAJOR_MERGE: major compaction at the Meta level, which merges data before a specified time into a Meta Major SSTable. This SSTable has the same data format as a Major SSTable and 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. |
