V$OB_LS_LOG_TRANSPORT_STAT

Overview

The V$OB_LS_LOG_TRANSPORT_STAT view displays the transmission status of logs pushed from each log stream (LS) on the current node of a tenant to a standby database in strong sync mode. To query this view, you must log in as the primary tenant (or the sys tenant of the cluster where the primary tenant resides).

Columns

Sample query

In the primary tenant, query the transmission status of logs pushed from each log stream on the current node to the standby tenant.

1. Confirm the synchronization mode of the primary tenant LS.

   obclient(root@mysql001)[oceanbase]> SELECT LS_ID, ROLE, SYNC_MODE FROM oceanbase.V$OB_LOG_STAT WHERE ROLE = 'LEADER';
   

   The query result is as follows:

   +-------+--------+-----------+
   | LS_ID | ROLE   | SYNC_MODE |
   +-------+--------+-----------+
   |     1 | LEADER | SYNC      |
   |  1001 | LEADER | SYNC      |
   +-------+--------+-----------+
   2 rows in set
   

   The result SYNC indicates that the current tenant's log stream synchronization mode is strong sync.

2. Query the transmission status of log pushing from each log stream on all nodes of the primary tenant to the standby tenant.

   obclient(root@mysql001)[oceanbase]> SELECT LS_ID, ROLE, ENABLED, 
       END_LSN, LAST_SENT_LSN, STANDBY_END_LSN, STANDBY_ADDR
       FROM oceanbase.V$OB_LS_LOG_TRANSPORT_STAT WHERE ROLE = 'LEADER';
   

   The query result is as follows:

   +-------+--------+---------+-----------+---------------+-----------------+-------------------+
   | LS_ID | ROLE   | ENABLED | END_LSN   | LAST_SENT_LSN | STANDBY_END_LSN | STANDBY_ADDR      |
   +-------+--------+---------+-----------+---------------+-----------------+-------------------+
   |     1 | LEADER |       1 | 305300441 |     305300441 |       305300441 | 6.xx.xxx.160:2882 |
   |  1001 | LEADER |       1 | 201421647 |     201421647 |       201421647 | 6.xx.xxx.160:2882 |
   +-------+--------+---------+-----------+---------------+-----------------+-------------------+
   2 rows in set