Overview
Displays the progress of converting tablets to columnar storage in the log streams of the C replicas on each OBServer node of the tenant.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | IP address of the server where the leader replica resides |
| SVR_PORT | bigint(20) | NO | Port number of the server where the follower replica resides |
| LS_ID | bigint(20) | NO | Log Stream ID |
| TOTAL_TABLET_CNT | bigint(20) | NO | Number of Partitions to Convert to Columnar Storage |
| AVAILABLE_TABLET_CNT | decimal(42,0) | NO | Number of Available Partitions |
| TOTAL_MACRO_BLOCK_CNT | decimal(42,0) | NO | Total Baseline Macroblocks (without Multi-Versioning) |
| AVAILABLE_MACRO_BLOCK_CNT | decimal(42,0) | NO | Number of Available Baseline Macroblocks (Excluding Multi-Version) |
| AVAILABLE | varchar(5) | NO | Whether the log stream is fully available:
|
Sample query
You can query the progress of converting tablets to columnar storage in the log streams of the C replicas on each OBServer node of the current 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 calculate the value of AVAILABLE_TABLET_CNT / TOTAL_TABLET_CNT or AVAILABLE_MACRO_BLOCK_CNT / TOTAL_MACRO_BLOCK_CNT to roughly estimate the progress of converting row-based storage to columnar storage.