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 caused by 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:200000Some queries are so infrequent that the cached data expires because of age. The default age is 10 minutes, but this can be increased up to one hour.
-
(Optional) If the
expired-countmonitor 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