Copy link to clipboard
Copied
Hi,
The Server monitor in ColdFusion 10 is showing the Cached query count as 12212 (and rising) even though the is set at 9000, how can I stop the actual Cached Query count from exceeding this limit and just exponentially growing?
Many thanks,
Chris
Copy link to clipboard
Copied
I tried to replicate this, Chris, and wasn't able to.
Silly question, but are you certain the limit is 9000?
--
Adam
Copy link to clipboard
Copied
Hi Adam,
Thanks for your input, I double checked and can defintely confirm the limit is set at 9000 here is a screenshot from the same instance:
Any more ideas? This seems to be happening across multiple instances but interestingly only on CF10 and not CF9
Chris
Copy link to clipboard
Copied
Do you have multiple CF10 instances running on that box? I'm wondering ift hey're inadvertently sharing an ehcache, or whether the monitor is misreporting or something?
These are just wild guesses, I'm afraid.
--
Adam
Copy link to clipboard
Copied
Adam Cameron. wrote:
Do you have multiple CF10 instances running on that box? I'm wondering ift hey're inadvertently sharing an ehcache, or whether the monitor is misreporting or something?
Or perhaps the server monitor is counting cached queries from all of the instances and not just that one???
EDIT
Sorry, I just re-read Adam's post (the one that I quoted) and see that he also mentioned the server monitor misreporting. Oops!! Must be too early in the morning.
Copy link to clipboard
Copied
Thanks for your input people, this happens on all CF10 instances I am running at the moment. Some are on dedicated servers with one CF instance and others are running up to 4 CF instanances so it looks to be a problem across the board...
Very Strange!
Copy link to clipboard
Copied
One theory is that ColdFusion had cached a lot of queries before the limit was set. In any case, 9000 is too large, let alone 12000. That might lead to excessive memory consumption, especially given that the number keeps rising. I would press the button to Clear Query Cache Now, enabling ColdFusion to rebuild the query cache.