Overview
Displays the log stream archiving progress for all tenants.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| DEST_ID | bigint(20) | NO | Archive Destination ID |
| LS_ID | bigint(20) | NO | Log Stream ID |
| ROUND_ID | bigint(20) | NO | Log Stream Round ID |
| PIECE_ID | bigint(20) | NO | Latest Piece ID |
| INCARNATION | bigint(20) | NO | Avatar ID |
| START_SCN | bigint(20) unsigned | NO | Archive Start SCN |
| MIN_LSN | bigint(20) unsigned | NO | Minimum LSN of Current Piece Log Stream |
| MAX_LSN | bigint(20) unsigned | NO | Maximum LSN of Current Piece Log Stream |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | Maximum Archiving Progress of Current Piece Log Stream |
| STATUS | varchar(64) | NO | Tenant archiving status:
|
| FILE_ID | bigint(20) | NO | Maximum Archived File ID of Current Piece |
| FILE_OFFSET | bigint(20) | NO | Maximum Archived File Offset for the Current Piece |
| INPUT_BYTES | bigint(20) | NO | Volume of Log Data Read |
| OUTPUT_BYTES | bigint(20) | NO | Volume of Archived Log Data |
Sample query
The system tenant queries the log stream archiving progress of the tenant with ID 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