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 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: minor compaction. Converts the 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: major compaction. Combines the data before a specified time point into a Meta Major SSTable. The data format is the same as that of a Major SSTable. The Meta Major SSTable 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. |
| START_TIME |
timestamp(6) |
NO |
The start time. |
| FINISH_TIME |
timestamp(6) |
NO |
The end time. |
| SUGGESTION |
varchar(1024) |
NO |
The suggestion. |
