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
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
Create a Table with Eviction Settings
describes the eviction process. The default eviction offheap percentage is 80%
of the critical offheap percentage value.
IN PERCENTAGE REAL NOT NULL
IN SERVER_GROUPS VARCHAR(32762)
- The percentage of used off-heap memory space that triggers
eviction for data stores in the specified server group(s).
- 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).
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);