Slowing queries based on sample cache size
Increase the sample cache size and the idle timeout using the dsconfig
tool.
About this task
The evicted-count
attribute of the sample cache sets the number of entries that have been evicted from the cache due to a lack of space. The cache might not be large enough for the query load placed on the server.
Steps
-
To increase the size of the sample cache to the maximum size of
200000
, run the following command:$ dsconfig set-monitoring-configuration-prop \ --set sample-cache-max-cached-series:200000
Some queries are so infrequent that the cached data expires due to age. The default age is 10 minutes, but this can be increased up to one hour.
-
Optional: If the
expired-count
monitor attribute is increasing between queries, consider increasing the idle timeout with the command:$ dsconfig set-monitoring-configuration-prop \ --set sample-cache-idle-series-timeout:20m