Skip to main content
ComrzChris
ComrzChris
New Participant
December 17, 2012
Question

Cached Query Count exceeds the Maximum number of cached queries

  • December 17, 2012
  • 2 replies
  • 2027 views

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

This topic has been closed for replies.

2 replies

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
January 2, 2013

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.

A
Adam Cameron.
Inspiring
December 20, 2012

I tried to replicate this, Chris, and wasn't able to.

Silly question, but are you certain the limit is 9000?

--

Adam

ComrzChris
ComrzChrisAuthor
New Participant
December 21, 2012

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

A
Adam Cameron.
Inspiring
December 21, 2012

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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices