tracker issue : CF-3659774

select a category, or use search below
(searches all categories and all time range)
Title:

Query cache hit count statistics always show as zero

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/NotABug

Reporter/Name(from Bugbase): David Stockton / David Stockton (David J Stockton)

Created: 11/07/2013

Components: Server Monitoring

Versions: 10.0

Failure Type: Data Loss

Found In Build/Fixed In Build: Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Platforms All

Vote Count: 0

Problem Description:

Result of calling getQueryCacheStats() should show the calculated querycache hit ratio. However, it's always zero.

Steps to Reproduce:

<cfset sf = createObject("java", "coldfusion.server.ServiceFactory") />
<cfset ms = sf.getMonitoringService() />
<cfset cs = ms.getQueryCacheStats() />

<cfdump var="#cs#" />

Actual Result:

HitRatio is always 0

Expected Result:

HitRatio reflects the real hit ratio (between 0 and 1)

Any Workarounds:

No workarounds. Value is visible in Server Monitoring UI, but not programatically accessible through API

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3659774

External Customer Info:
External Company:  
External Customer Name: David J Stockton
External Customer Email:  
External Test Config: My Hardware and Environment details:



Happens on all environments

Attachments:

Comments:

GetQueryCacheStats() gives data about the query cache as a whole. So it includes data like Query cache size and count. To get hit count for individual queries correct API to use would be getCachedQueries() on MonitoringService instance. (Comment added from ex-user id:sandeepp)
Comment by Adobe D.
14026 | May 12, 2014 06:41:17 AM GMT