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 all tenants.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| 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 log stream ID. |
| TOTAL_TABLET_CNT | bigint(20) | NO | The number of partitions 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
In the following example, the system tenant queries the progress of tablet conversion to columnstore format within columnstore replica log streams on various OBServer nodes for the tenant with ID 1004.
obclient[oceanbase]> SELECT * FROM oceanbase.CDB_OB_CS_REPLICA_STATS WHERE TENANT_ID=1004;
The query result is as follows:
+-----------+----------------+----------+-------+------------------+----------------------+-----------------------+---------------------------+-----------+
| TENANT_ID | SVR_IP | SVR_PORT | LS_ID | TOTAL_TABLET_CNT | AVAILABLE_TABLET_CNT | TOTAL_MACRO_BLOCK_CNT | AVAILABLE_MACRO_BLOCK_CNT | AVAILABLE |
+-----------+----------------+----------+-------+------------------+----------------------+-----------------------+---------------------------+-----------+
| 1004 | 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.