Use the CACHE tab in the Cluster Settings page to configure the cache settings.
- Click on the CACHE tab.
Follow the table below to complete the configuration.
Field Description User input Maximum Query Size for Cache (KB)
Specifies the maximum value in kilobytes above which the data for a select query response is not cached. When query cache does not seem to work, increase this number to accommodate for larger query responses.
When responses to large queries are stored within ScaleArc, the cache memory utilization also increases.
Default value is 1024 KB. Cache Cleanup Cycle Time (seconds)
Specifies how often to run the cache garbage collector. This is not related to the minimum time to live (TTL) of your cache. So don't set this to an unreasonably low value.
The default value is 60 seconds. Cache Empty Result Set
Turn the status ON only if you need to cache empty responses to queries. Sometimes when there is an empty result set for queries having cache rules where pattern match happens but does not result in cache rule hits, this option needs to be turned ON to achieve cache hits.
Default setting is OFF. Dynamic Query Caching
Turn this setting ON if you would like to enable dynamic query caching.
Default setting is OFF.
- Click APPLY ALL to save the configuration changes or LOAD DEFAULTS to load the default settings.