Note
- This view is available starting with V4.4.0.
- This view is available starting with V4.3.5 BP2.
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 of this view 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 locally for the tablet, in bytes. |
| CACHE_HIT_COUNT | bigint(20) | NO | The number of cache hits for the tablet. This field is not enabled and the value is -1. |
| CACHE_MISS_COUNT | bigint(20) | NO | The number of cache misses for the tablet. This field is not enabled and the value is -1. |
| CACHE_HIT_SIZE | bigint(20) | NO | The size of data cached for the tablet, in bytes. This field is not enabled and the value is -1. |
| CACHE_MISS_SIZE | bigint(20) | NO | The size of data cached for the tablet, in bytes. This field is not enabled and the value is -1. |
| INFO | varchar(4096) | NO | Other information. |
Sample query
In SS mode, the system tenant queries the overall cache status of the tenant with ID 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