SYS.SET_EVICTION_OFFHEAP_PERCENTAGE

Sets the percentage threshold of off-heap memory usage that triggers a GemFire XD data store to perform LRU eviction on tables that are configured for LRU_HEAP eviction. This procedure executes only on the local GemFire XD data store member.

This procedure sets the percentage threshold for evicting table data from off-heap memory for the local GemFire XD data store. When the off-heap memory usage 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 offheap percentage is 80% of the critical offheap percentage value.

Syntax

SYS.SET_EVICTION_OFFHEAP_PERCENTAGE (
IN PERCENTAGE REAL NOT NULL
)
PERCENTAGE
The percentage of used off-heap memory that triggers eviction on GemFire XD data stores for all tables configured with LRU_HEAP eviction.

Example

This command triggers eviction on any GemFire XD member when the local member's off-heap memory usage reaches 90%:
call sys.set_eviction_offheap_percentage (90);