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 SYS.SET_EVICTION_HEAP_PERCENTAGE. 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.
SYS.SET_EVICTION_HEAP_PERCENTAGE_SG ( 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);