Note
This view is available starting with V4.1.0.
Purpose
This view displays the log stream archiving progress of all tenants.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| DEST_ID | bigint(20) | NO | The ID of the archive destination. |
| 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 ID of the latest piece. |
| INCARNATION | bigint(20) | NO | The incarnation ID. |
| START_SCN | bigint(20) unsigned | NO | The SCN of the archive start. |
| MIN_LSN | bigint(20) unsigned | NO | The minimum LSN of the current piece. |
| MAX_LSN | bigint(20) unsigned | NO | The maximum LSN of the current piece. |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | The maximum archive progress of the current piece. |
| STATUS | varchar(64) | NO | The archiving status of the tenant. Valid values:
|
| FILE_ID | bigint(20) | NO | The ID of the largest archive file of the current piece. |
| FILE_OFFSET | bigint(20) | NO | The offset of the largest archive file of the current piece. |
| INPUT_BYTES | bigint(20) | NO | The size of the log data read. |
| OUTPUT_BYTES | bigint(20) | NO | The size of the archived log data. |
Sample query
Query the log stream archiving progress of the tenant whose tenant ID is 1002 in the sys tenant.
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