Sets the percentage threshold of Java heap memory usage that
triggers members of one or more GemFire XD server groups to perform LRU
eviction on tables that are configured for eviction.
This procedure sets
the percentage threshold for evicting table data from the Java heap for all
members of one or more server groups, or for all data stores in the GemFire XD
cluster. You can optionally set the heap percentage only for the local GemFire
XD data store by using
When the used heap reaches the percentage, GemFire XD begins to evict rows,
using a LRU algorithm, from tables that are configured with LRU_HEAP eviction.
Create a Table with Eviction Settings
describes the eviction process. The default eviction heap percentage is 80% of
the critical heap percentage value.
IN PERCENTAGE REAL NOT NULL
IN SERVER_GROUPS VARCHAR(32762)
- The percentage of used heap 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
heap 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 heap reaches 85%:
call sys.set_eviction_heap_percentage_sg (85, 'overflows');
This command triggers eviction on all GemFire XD data stores when that
member's heap reaches 85%:
call sys.set_eviction_heap_percentage_sg (85, null);