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 the current tenant on the current OBServer node.
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 the data cached to the local tablet, in bytes. |
| CACHE_HIT_COUNT | bigint(20) | NO | The number of cache hits. This field is currently not enabled and its value is -1. |
| CACHE_MISS_COUNT | bigint(20) | NO | The number of cache misses. This field is currently not enabled and its value is -1. |
| CACHE_HIT_SIZE | bigint(20) | NO | The size of the data cached to the local tablet, in bytes. This field is currently not enabled and its value is -1. |
| CACHE_MISS_SIZE | bigint(20) | NO | The size of the data cached to the local tablet, in bytes. This field is currently not enabled and its value is -1. |
| INFO | varchar(4096) | NO | Other information. |
Sample query
In SS mode, a user tenant queries the overall cache status of the tenant on the current OBServer node.
obclient> SELECT SVR_IP, SVR_PORT, TENANT_ID, TABLET_ID, STORAGE_CACHE_POLICY, INFO FROM oceanbase.V$OB_TABLET_LOCAL_CACHE;
The query result is as follows:
+---------------+----------+-----------+-----------+----------------------+------+
| SVR_IP | SVR_PORT | TENANT_ID | TABLET_ID | STORAGE_CACHE_POLICY | INFO |
+---------------+----------+-----------+-----------+----------------------+------+
| 11.xx.xxx.xxx | 16702 | 1002 | 200001 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200002 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200003 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200004 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200005 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200006 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200007 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200008 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200009 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200010 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200011 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200012 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200013 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200014 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200015 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200016 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200017 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200018 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200019 | AUTO | |
| 11.xx.xxx.xxx | 16702 | 1002 | 200020 | AUTO | |
+---------------+----------+-----------+-----------+----------------------+------+
20 rows in set