Note
This view is available starting with V4.0.0.
Purpose
This view displays the status and recovery progress of all log streams of all tenants.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| LS_ID | bigint(20) | NO | The ID of the log stream. |
| STATUS | varchar(100) | NO | The status of the log stream. Valid values:
|
| PRIMARY_ZONE | longtext | YES | The priority of the log stream for leader election. |
| UNIT_GROUP_ID | bigint(20) | NO | The ID of the unit group.
Note
|
| LS_GROUP_ID | bigint(20) | NO | The ID of the log stream group. For the system log stream (log stream 1) and broadcast log stream, this column displays 0, indicating that the log stream does not belong to any log stream group. |
| CREATE_SCN | bigint(20) unsigned | NO | The position at which the log stream starts to write logs. |
| DROP_SCN | bigint(20) unsigned | NO | The position at which the log stream is dropped. This position marks the end of all user data. If the log stream is dropped, this column records the SCN when the log stream is dropped. If the log stream is not dropped, this column is empty. |
| SYNC_SCN | bigint(20) unsigned | NO | The synchronization position of the log stream. This position marks the SCN of the last transaction that is synchronized to the log stream. |
| READABLE_SCN | bigint(20) unsigned | NO | The readable position of the log stream. This position marks the minimum SCN of the log stream that can be read. |
| FLAG | varchar(2048) | NO | The flag of the log stream. Valid values:
NoteThis column is available starting with V4.2.0. |
| UNIT_LIST | varchar(1216) | NO | The list of units where the user log stream is distributed. For the system log stream and broadcast log stream, this column is empty if no specific location is specified.
Note
|
Sample query
Query the status and recovery progress of all log streams of all tenants in the sys tenant.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_LS;
The query result is as follows:
+-----------+-------+--------+--------------+---------------+-------------+---------------------+----------+---------------------+---------------------+------+-----------+
| TENANT_ID | LS_ID | STATUS | PRIMARY_ZONE | UNIT_GROUP_ID | LS_GROUP_ID | CREATE_SCN | DROP_SCN | SYNC_SCN | READABLE_SCN | FLAG | UNIT_LIST |
+-----------+-------+--------+--------------+---------------+-------------+---------------------+----------+---------------------+---------------------+------+-----------+
| 1 | 1 | NORMAL | zone1 | 0 | 0 | NULL | NULL | NULL | NULL | | |
| 1001 | 1 | NORMAL | zone1 | 0 | 0 | NULL | NULL | NULL | NULL | | |
| 1002 | 1 | NORMAL | zone1 | 0 | 0 | NULL | NULL | 1768205075324901000 | 1768205075223955000 | | |
| 1002 | 1001 | NORMAL | zone1 | 0 | 1001 | 1767769653174440000 | NULL | 1768205075324901000 | 1768205075223955000 | | 1001 |
| 1003 | 1 | NORMAL | zone1 | 0 | 0 | NULL | NULL | NULL | NULL | | |
| 1004 | 1 | NORMAL | zone1 | 0 | 0 | NULL | NULL | 1768205075324901001 | 1768205075324901001 | | |
| 1004 | 1001 | NORMAL | zone1 | 0 | 1001 | 1767769662964400002 | NULL | 1768205075224971000 | 1768205075224971000 | | 1002 |
+-----------+-------+--------+--------------+---------------+-------------+---------------------+----------+---------------------+---------------------+------+-----------+
7 rows in set