Note
For OceanBase Database V4.3.5, this view is introduced in V4.3.5 BP1.
Purpose
This view displays the progress of converting tablets to columnstore format within columnstore replica log streams on each OBServer node for the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the server where the columnstore replica resides. |
| SVR_PORT | bigint(20) | NO | The port number of the server where the columnstore replica resides. |
| LS_ID | bigint(20) | NO | The ID of the log stream. |
| TOTAL_TABLET_CNT | bigint(20) | NO | The number of partitions that need to be converted to columnstore format. |
| 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 (ignoring multi-version). |
| AVAILABLE_MACRO_BLOCK_CNT | decimal(42,0) | NO | The number of available baseline macroblocks (ignoring multi-version). |
| AVAILABLE | varchar(5) | NO | Whether the log stream is completely available:
|
Sample query
A user tenant queries the progress of converting tablets to columnstore format in the log streams of columnstore replicas on all each OBServer node of the tenant.
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
Based on the query results, you can estimate the progress of rowstore to columnstore conversion by calculating the values of AVAILABLE_TABLET_CNT / TOTAL_TABLET_CNT or AVAILABLE_MACRO_BLOCK_CNT / TOTAL_MACRO_BLOCK_CNT.
