ldap_cache_max_bytes for MariaDB Xpand

USAGE

The ldap_cache_max_bytes system variable can be set by executing SET GLOBAL:

SET GLOBAL ldap_cache_max_bytes = <number_of_bytes>;

Using SET GLOBAL to set the value of a global variable in Xpand causes a change that will persist on restart.

DETAILS

The ldap_cache_max_bytes system variable sets the maximum size of the LDAP query cache, in bytes.

Valid range of values is from 0 to 9223372036854775807 (default: 10485760).

If the cache fills up, entries are evicted according to a least recently used (LRU) policy.

The cache can be manually flushed by running CALL system.ldap_cache_flush() on the Xpand SQL prompt.

Since the cache is per Xpand node, with each node having a cache up to ldap_cache_max_bytes, eviction by exceeding the cache capacity happens independently on each node.

EXAMPLES

To increase the total cache capacity from its default of 10 megabytes to 100 megabytes:

SET GLOBAL ldap_cache_max_bytes = 104857600;

CHANGE HISTORY