Note
The view V$MEMSTORE_INFO was renamed to V$OB_MEMSTORE_INFO starting from V4.0.0. In V4.0.0 and later versions, you must use the new view name V$OB_MEMSTORE_INFO to query. Using the old view name V$MEMSTORE_INFO will result in an error.
Purpose
This view displays detailed information about MemTables of all partitions of all tenants on the current server.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| LS_ID | bigint(20) | NO | The log stream ID. |
| TABLE_ID | bigint(20) | NO | The data shard ID. |
| IS_ACTIVE | varchar(3) | NO | Indicates whether the MemTable is active. |
| START_SCN | bigint(20) unsigned | NO | The start SCN of the MemTable. |
| END_SCN | bigint(20) unsigned | NO | The end SCN of the MemTable. |
| FREEZE_TS | bigint(20) | NO | The timestamp when the MemTable was frozen. |
Sample query
Query detailed information about MemTables of all partitions of the tenant with ID 1002 on the current server.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_MEMSTORE_INFO WHERE TENANT_ID=1002;
The query result is as follows:
+----------------+----------+-----------+-------+-----------+-----------+---------------------+---------------------+-----------+
| SVR_IP | SVR_PORT | TENANT_ID | LS_ID | TABLET_ID | IS_ACTIVE | START_SCN | END_SCN | FREEZE_TS |
+----------------+----------+-----------+-------+-----------+-----------+---------------------+---------------------+-----------+
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 378 | YES | 1714068002572249530 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 1 | YES | 1714068112628329951 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 377 | YES | 1714068002572249530 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 323 | YES | 1714068002572249530 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 331 | YES | 1714068002572249530 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 121 | YES | 1714068114066199993 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 431 | YES | 1714031525703603309 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 373 | YES | 1 | 4611686018427387903 | 0 |
+----------------+----------+-----------+-------+-----------+-----------+---------------------+---------------------+-----------+
8 rows in set
References
Query detailed information about MemTables of all partitions on all nodes: GV$OB_MEMSTORE_INFO
Query the memory usage of MemTables of a tenant on the current node: V$OB_MEMSTORE