Note
This view is available starting with V4.1.0.
Purpose
This view displays the log stream archive progress of all tenants for the system tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| DEST_ID | bigint(20) | NO | The archive destination ID. |
| LS_ID | bigint(20) | NO | The log stream ID. |
| ROUND_ID | bigint(20) | NO | The log stream round ID. |
| PIECE_ID | bigint(20) | NO | The latest piece ID. |
| INCARNATION | bigint(20) | NO | The incarnation ID. |
| START_SCN | bigint(20) unsigned | NO | The archive start SCN. |
| MIN_LSN | bigint(20) unsigned | NO | The minimum LSN of the current piece log stream. |
| MAX_LSN | bigint(20) unsigned | NO | The maximum LSN of the current piece log stream. |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | The maximum archive progress of the current piece log stream. |
| STATUS | varchar(64) | NO | The archive status of the tenant. Valid values:
|
| FILE_ID | bigint(20) | NO | The maximum archive file ID of the current piece. |
| FILE_OFFSET | bigint(20) | NO | The maximum archive file offset of the current piece. |
| INPUT_BYTES | bigint(20) | NO | The amount of log data read. |
| OUTPUT_BYTES | bigint(20) | NO | The amount of archived log data. |
Sample query
Query the log stream archive progress of the tenant whose tenant ID is 1002.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS WHERE TENANT_ID = 1002\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
LS_ID: 1
ROUND_ID: 1
PIECE_ID: 1
INCARNATION: 1
START_SCN: 1736228322307513000
MIN_LSN: 67104768
MAX_LSN: 130710857
CHECKPOINT_SCN: 1736234926476865000
STATUS: DOING
FILE_ID: 2
FILE_OFFSET: 63606089
INPUT_BYTES: 63606089
OUTPUT_BYTES: 63606089
*************************** 2. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
LS_ID: 1001
ROUND_ID: 1
PIECE_ID: 1
INCARNATION: 1
START_SCN: 1736228322307513000
MIN_LSN: 67104768
MAX_LSN: 92201946
CHECKPOINT_SCN: 1736234926274668000
STATUS: DOING
FILE_ID: 2
FILE_OFFSET: 25097178
INPUT_BYTES: 25097178
OUTPUT_BYTES: 25097178
2 rows in set