Note
This view is available starting with V4.0.0.
Purpose
This view displays the diagnostic information of the current node's COMPACTION.
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:
|
| 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. |
Sample query
Query the diagnostic information of the current node's COMPACTION in the user tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_COMPACTION_DIAGNOSE_INFO;