Note
This view is available starting with V4.0.0.
Purpose
This view displays the status and recovery progress of log streams in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| 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 zone of the log stream. |
| 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 system log streams (log stream 1) and broadcast log streams, this field is 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 field records the SCN at which the log stream is dropped. If the log stream is not dropped, this field 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 successfully synchronized. |
| READABLE_SCN | bigint(20) unsigned | NO | The readable position of the log stream. This position marks the minimum SCN that can be read from the log stream. |
| FLAG | varchar(2048) | NO | The flag of the log stream. Valid values:
NoteThis field is available starting from V4.2.0. |
| UNIT_LIST | varchar(1216) | NO | The list of units where the user log stream is distributed. For system log streams and broadcast log streams, this field is empty if no specific location is specified.
Note
|
Sample query
Query the status and recovery progress of log streams in the current user tenant.
obclient(root@mysql001)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_LS;
The query result is as follows:
+-------+--------+--------------+---------------+-------------+---------------------+----------+---------------------+---------------------+------+-----------+
| LS_ID | STATUS | PRIMARY_ZONE | UNIT_GROUP_ID | LS_GROUP_ID | CREATE_SCN | DROP_SCN | SYNC_SCN | READABLE_SCN | FLAG | UNIT_LIST |
+-------+--------+--------------+---------------+-------------+---------------------+----------+---------------------+---------------------+------+-----------+
| 1 | NORMAL | zone1 | 0 | 0 | NULL | NULL | 1768205234345984000 | 1768205234345984000 | | |
| 1001 | NORMAL | zone1 | 0 | 1001 | 1767769653174440000 | NULL | 1768205234345984000 | 1768205234345984000 | | 1001 |
+-------+--------+--------------+---------------+-------------+---------------------+----------+---------------------+---------------------+------+-----------+
2 rows in set
References
Query the status and recovery progress of log streams in all tenants: CDB_OB_LS
For more information about log stream replicas, see Replica introduction.