Note
- For V4.4.x versions, this view is available starting with V4.4.0.
- For V4.3.5, this view is available starting with V4.3.5 BP2.
Purpose
This view displays the overall cache information of each 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 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 its value is -1. |
| CACHE_MISS_COUNT | bigint(20) | NO | The number of cache misses for the tablet. This field is not enabled and its 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 its 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 its value is -1. |
| INFO | varchar(4096) | NO | Other information |
Sample query
In SS mode, the sys tenant queries the overall cache information of the tenant with ID 1002 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 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.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