NAME

SYNOPSIS

DESCRIPTION

To improve the performance of frequently run queries, SQL Relay client applications can cache result sets locally and then access them rather than running the query again. When a result set is cached, a time-to-live (expiration date) is assigned to it. The sqlr-cachemanager goes through the cached result sets periodically and removes the ones that have expired.

Only one sqlr-cachemanager needs to be run per machine.

IMPORTANT NOTE:

Since cache managers clean up after SQL Relay client applications, they need to be run on machines which run client applications that could cache result sets. These are likely to be web or application servers, rather than the machines that run the sqlr-listener and sqlr-connection daemons.

OPTIONS

-cachedirs dirs

Colon-delimited list of directories to scan for cache files.

-scaninterval sec

Interval, in seconds, to scan the cache directories.

Rudiments version: 1.2.1 Compiled: Oct 23 2019 21:56:07

AUTHOR

COPYRIGHT