Note
- Due to the optimization of the storage architecture in V4.x, this view was removed starting from V4.0.0.
- In V4.x, you can query the V$OB_MEMSTORE and V$OB_MEMSTORE_INFO views to obtain information about MemTables.
Purpose
The v$tenant_memstore_allocator_info view displays information about MemTables on the connected OBServer node. This view is mainly used to troubleshoot issues where the memory of the MemStore of a tenant is not released for a long time. Each row of the view corresponds to the information of a MemTable.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SVR_IP | varchar(32) | 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. |
| TABLE_ID | bigint(20) | NO | The table ID. |
| PARTITION_ID | bigint(20) | NO | The partition ID. |
| MT_BASE_VERSION | bigint(20) | NO | The starting transaction version of the MemTable. |
| RETIRE_CLOCK | bigint(20) | NO | The total amount of memory allocated to the MemStore of the tenant to which the MemTable belongs, in bytes. |
| MT_IS_FROZEN | bigint(20) | NO | Indicates whether the MemTable is frozen. |
| MT_PROTECTION_CLOCK | bigint(20) | NO | The amount of memory allocated to the MemStore of the tenant to which the MemTable belongs when the MemTable was first allocated memory, in bytes. |
| MT_SNAPSHOT_VERSION | bigint(20) | NO | The snapshot version of the MemTable. |