Purpose
If the system fails to allocate memory due to memory fragmentation, the system will automatically clean up memory fragments and try again. You can also use this statement to manually clean up memory fragments. This statement releases all idle blocks on an OBServer node.
Required privileges
Only the root user of the sys tenant (root@sys) can execute this statement.
Syntax
ALTER SYSTEM WASH MEMORY FRAGMENTATION server_or_zone;
server_or_zone:
SERVER [=] 'ip:port'
ZONE [=] zone_name
Parameters
| Parameter | Description |
|---|---|
| server_or_zone | Specifies whether to clean up memory fragments for an OBServer node or a zone. |
| ip:port | The IP address and RPC port number of the target OBServer node. You can specify only one OBServer node at a time. |
| zone_name | The name of the target zone. You can specify only one zone at a time. |
Examples
Clean up memory fragments on all OBServer nodes in
Zone1.obclient [(none)]> ALTER SYSTEM WASH MEMORY FRAGMENTATION ZONE = 'zone1';Clean up memory fragments on the specified OBServer node.
obclient [(none)]> ALTER SYSTEM WASH MEMORY FRAGMENTATION SERVER = '10.10.10.1:2882';