Note
- For V4.4.x, this view is available starting with V4.4.0.
- For V4.3.5, this view is available starting with V4.3.5 BP2.
Purpose
This view displays the progress of converting tablets in log streams of C replicas on all OBServer nodes of the current tenant to columnar storage.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the server where the C replica is located. |
| SVR_PORT | bigint(20) | NO | The port number of the server where the C replica is located. |
| LS_ID | bigint(20) | NO | The log stream ID. |
| TOTAL_TABLET_CNT | bigint(20) | NO | The number of partitions to be converted to columnar storage. |
| AVAILABLE_TABLET_CNT | decimal(42,0) | NO | The number of available partitions. |
| TOTAL_MACRO_BLOCK_CNT | decimal(42,0) | NO | The total number of baseline macroblocks (excluding multi-version data). |
| AVAILABLE_MACRO_BLOCK_CNT | decimal(42,0) | NO | The number of available baseline macroblocks (excluding multi-version data). |
| AVAILABLE | varchar(5) | NO | Whether the log stream is fully available:
|
Sample query
Query the progress of converting tablets in log streams of C replicas on all OBServer nodes of the current tenant to columnar storage.
obclient[oceanbase]> SELECT * FROM oceanbase.DBA_OB_CS_REPLICA_STATS;
The query result is as follows:
+----------------+----------+-------+------------------+----------------------+-----------------------+---------------------------+-----------+
| SVR_IP | SVR_PORT | LS_ID | TOTAL_TABLET_CNT | AVAILABLE_TABLET_CNT | TOTAL_MACRO_BLOCK_CNT | AVAILABLE_MACRO_BLOCK_CNT | AVAILABLE |
+----------------+----------+-------+------------------+----------------------+-----------------------+---------------------------+-----------+
| xx.xxx.xxx.212 | 63000 | 1001 | 1019 | 1019 | 10706 | 10706 | TRUE |
+----------------+----------+-------+------------------+----------------------+-----------------------+---------------------------+-----------+
1 row in set
You can calculate the value of AVAILABLE_TABLET_CNT / TOTAL_TABLET_CNT or AVAILABLE_MACRO_BLOCK_CNT / TOTAL_MACRO_BLOCK_CNT to estimate the progress of converting rowstore data to columnar storage.