Note
- Due to the storage architecture optimization in V4.x, this view is 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. It is mainly used to troubleshoot issues where the memory in 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 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 start transaction version of the MemTable. |
| RETIRE_CLOCK | bigint(20) | NO | The total allocated memory of 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 total allocated memory of the MemStore of the tenant to which the MemTable belongs when the MemTable is first allocated memory, in bytes. |
| MT_SNAPSHOT_VERSION | bigint(20) | NO | The snapshot version of the MemTable. |