SYS.SET_EVICTION_OFFHEAP_PERCENTAGE_SG

Sets the percentage of off-heap memory usage that triggers members of one or more GemFire XD server groups to perform LRU eviction on tables that are configured for LRU_HEAP eviction.

This procedure sets the off-heap percentage threshold for eviction on all members of one or more server groups, or for all data stores in the GemFire XD cluster. You can optionally set the global off-heap percentage only for the local GemFire data store by using SYS.SET_EVICTION_HEAP_PERCENTAGE. When used off-heap memory reaches the percentage, GemFire XD begins to evict rows, using a LRU algorithm, from tables that are configured for LRU_HEAP eviction. Create a Table with Eviction Settings describes the eviction process. The default eviction offheap percentage is 80% of the critical offheap percentage value.

Syntax

SYS.SET_EVICTION_OFFHEAP_PERCENTAGE_SG (
IN PERCENTAGE REAL NOT NULL
IN SERVER_GROUPS VARCHAR(32762)
}
PERCENTAGE
The percentage of used off-heap memory space that triggers eviction for data stores in the specified server group(s).
SERVER_GROUPS
A comma-separated list of server groups on which to apply the off-heap memory percentage setting. If you specify NULL, the command is distributed to all data stores (irrespective of defined server groups).

Example

This command triggers eviction on any member of the "overflows" server group when that member's off-heap memory usage reaches 85%:
call sys.set_eviction_offheap_percentage_sg (85, 'overflows');
This command triggers eviction on all GemFire XD data stores when that member's off-heap memory usage reaches 85%:
call sys.set_eviction_offheap_percentage_sg (85, null);