Overview
Displays the memory usage of the MemTable for all tenants on all servers.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | Server IP |
| SVR_PORT | bigint(20) | NO | Server Port |
| TENANT_ID | bigint(20) | NO | Tenant ID |
| ACTIVE_SPAN | bigint(20) | NO | Estimated memory usage of the active MemTable (may be higher), in bytes |
| FREEZE_TRIGGER | bigint(20) | NO | Memory size that triggers MemTable freezing, in bytes |
| FREEZE_CNT | bigint(20) | NO | Number of Freezes of MemTable |
| MEMSTORE_USED | bigint(20) | NO | Total memory size currently used by the MemTable, in bytes |
| MEMSTORE_LIMIT | bigint(20) | NO | Memory size limit for MemTable, in bytes |
Sample query
The system tenant queries the memory usage of the MemTable on all servers of the tenant with ID 1002.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_MEMSTORE WHERE TENANT_ID=1002;
The query result is as follows:
+----------------+----------+-----------+-------------+----------------+------------+---------------+----------------+
| SVR_IP | SVR_PORT | TENANT_ID | ACTIVE_SPAN | FREEZE_TRIGGER | FREEZE_CNT | MEMSTORE_USED | MEMSTORE_LIMIT |
+----------------+----------+-----------+-------------+----------------+------------+---------------+----------------+
| 172.xx.xxx.xxx | 2882 | 1002 | 62914560 | 603982068 | 0 | 62914560 | 2684354550 |
+----------------+----------+-----------+-------------+----------------+------------+---------------+----------------+
1 row in set
Related views
View the memory usage of the tenant's MemTable on the current node: V$OB_MEMSTORE
View detailed information about the MemTable of all partitions on all nodes: GV$OB_MEMSTORE_INFO