Overview
Displays the overall cache usage of each tenant on the current OBServer node.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | IP Address of OBServer Node |
| SVR_PORT | bigint(20) | NO | Port number of the OBServer node |
| TENANT_ID | bigint(20) | NO | Tenant ID |
| TABLET_ID | bigint(20) | NO | Tablet ID |
| STORAGE_CACHE_POLICY | varchar(64) | NO | The current cache status of the tablet:
|
| CACHED_DATA_SIZE | bigint(20) | NO | The amount of data cached locally in this tablet, in bytes |
| CACHE_HIT_COUNT | bigint(20) | NO | The number of times the tablet cache hit. This field is not currently enabled, and the value is -1 |
| CACHE_MISS_COUNT | bigint(20) | NO | The number of times the tablet cache has experienced misses. This field is not currently enabled and its value is -1 |
| CACHE_HIT_SIZE | bigint(20) | NO | The amount of data cached in the tablet, in bytes. This field is not currently enabled and the value is -1 |
| CACHE_MISS_SIZE | bigint(20) | NO | The amount of data in bytes that is cached in the tablet for misses. This field is not currently enabled and the value is -1 |
| INFO | varchar(4096) | NO | Other information |
Sample query
In SS mode, the system tenant queries the overall cache usage 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