Note
- This view is available starting with V4.4.0 for V4.4.x.
- This view is available starting with V4.3.5 BP2 for V4.3.5.
Purpose
This view displays the overall cache status of each tenant on all OBServer nodes.
Note
This view is available only in Shared-Storage (SS) mode. In Shared-Nothing (SN) mode, the query result is empty.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| TABLET_ID | bigint(20) | NO | The tablet ID. |
| STORAGE_CACHE_POLICY | varchar(64) | NO | The cache status of the tablet:
|
| CACHED_DATA_SIZE | bigint(20) | NO | The size of data cached to the local storage of the tablet, in bytes. |
| CACHE_HIT_COUNT | bigint(20) | NO | The number of cache hits for the tablet. This column is not enabled yet, and its value is -1. |
| CACHE_MISS_COUNT | bigint(20) | NO | The number of cache misses for the tablet. This column is not enabled yet, and its value is -1. |
| CACHE_HIT_SIZE | bigint(20) | NO | The size of data cached to the local storage of the tablet, in bytes. This column is not enabled yet, and its value is -1. |
| CACHE_MISS_SIZE | bigint(20) | NO | The size of data cached to the local storage of the tablet, in bytes. This column is not enabled yet, and its value is -1. |
| INFO | varchar(4096) | NO | Other information. |
Sample query
In SS mode, the system tenant queries the overall cache status of tenant 1002 on all OBServer nodes.
obclient> SELECT SVR_IP, SVR_PORT, TENANT_ID, TABLET_ID, STORAGE_CACHE_POLICY, INFO FROM oceanbase.GV$OB_TABLET_LOCAL_CACHE WHERE TENANT_ID = 1002;
The query result is as follows:
+---------------+----------+-----------+-----------+----------------------+------+
| SVR_IP | SVR_PORT | TENANT_ID | TABLET_ID | STORAGE_CACHE_POLICY | INFO |
+---------------+----------+-----------+-----------+----------------------+------+
| 11.xx.xxx.166 | 16702 | 1002 | 200001 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200002 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200003 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200004 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200005 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200006 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200007 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200008 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200009 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200010 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200011 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200012 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200013 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200014 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200015 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200016 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200017 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200018 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200019 | AUTO | |
| 11.xx.xxx.166 | 16702 | 1002 | 200020 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200001 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200002 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200003 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200004 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200005 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200006 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200007 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200008 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200009 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200010 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200011 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200012 | AUTO | |
| 11.xx.xxx.167 | 16703 | 1002 | 200013 | AUTO | |
+---------------+----------+-----------+-----------+----------------------+------+
33 rows in set