Note
This view is available starting with V4.0.0.
Purpose
This view displays the status and restore 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 election priority 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 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 indicates the end of all user data. If the log stream is dropped, this column records the SCN at which 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 indicates the SCN of the last transaction that is synchronized. |
| READABLE_SCN | bigint(20) unsigned | NO | The readable position of the log stream. This position indicates the minimum SCN at which the log stream 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. The value of this column is empty for the system log stream and broadcast log stream if no specific location is specified.
Note
|
Sample query
Query the status and restore 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 restore progress of log streams in all tenants: CDB_OB_LS
For more information about log stream replicas, see Replica introduction.