ldap_cache_entry_lifetime_s for MariaDB Xpand

USAGE

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

SET GLOBAL ldap_cache_entry_lifetime_s = <number_of_seconds>;

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_entry_lifetime_s system variable sets the duration that entries in the LDAP query cache are valid for, in seconds.

Valid range of values is from 1 to 9223372036854775807 (default: 300).

The longer the expiration duration, the longer it will take to evict an entry (as long as there is still space for it in the cache). The expiration time is calculated from the time of cache entry insert or update.

If your LDAP group membership changes often, take careful consideration for how long you really want this duration to be.

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, eviction by expiration happens independently on each node.

EXAMPLES

To increase the cache entry lifetime from its default of 5 minutes to 1 hour:

SET GLOBAL ldap_cache_entry_lifetime_s = 3600;

CHANGE HISTORY