Significance of "red" cache regions in the HQ Health plugin?

[bclark_hyperic]

Hello,

I was checking out the new HQ Health plugin console for the first time and I have a question. When viewing the information available on the "Cache" tab. Some of the "cache regions" are colored in red, and some are not.

What is the significance of the red-highlighted cache regions? Is this something that I should be concerned about?

Thanks,
Brian

[ama_hyperic]

It means that the cache size for that region is not large enough and a miss means that it has to go to the database for that information instead of the cache.

It can be a concern for larger environments.

[bclark_hyperic]

OK. Thanks for the response.

Should I increase the cache size for these regions? If so, how do you change the cache size?

Also, what qualifies as a "larger environment"?
The HQ Health plugin helpfully provides statistics on my environment:
# Metrics collected per minute: 1726
# Platforms: 52
# Servers: 193
# Services: 1995
# Agents: 52

Thanks again!

Brian

[admin]

Well, 'larger' just means larger than the cache is configured to work
well for. You obviously want to make sure your miss rate is fairly low.

If you'd like, go to the 'health' screen, click 'print' and copy-n-
paste the section containing the ehcache diagnostics to this thread
and I can go over it with you.

-- Jon




On Feb 14, 2008, at 1:24 PM, Brian Clark wrote:

> OK. Thanks for the response.
>
> Should I increase the cache size for these regions? If so, how do
> you change the cache size?
>
> Also, what qualifies as a "larger environment"?
> The HQ Health plugin helpfully provides statistics on my environment:
> # Metrics collected per minute: 1726
> # Platforms: 52
> # Servers: 193
> # Services: 1995
> # Agents: 52
>
> Thanks again!
>
> Brian

[bclark_hyperic]

Thanks for offering to go over this with me. Here are the EhCache diags that you asked for.

(Sorry, I couldn't figure out how to make these appear mono-spaced in this forum post. I attached a text file with the data as it appears in the Health report. It is much easier to read that way)

-- Diagnostics: EhCache Diagnostics --

Cache Size Hits Misses
===== ==== ==== =====
Agent.findByAgentToken 61 407625 63
AgentScheduleInQueue 0 0 519
Alert.findByCreateTime 10 481 511
Alert.findByEntity 0 0 0
Application.findByServiceId_orderName 305 61 305
AuthzSubject.findByAuth 3 2024 3
AuthzSubject.findByName 1 181 1
AvailabilitySummary 432 27108 487
Baseline.findByMeasurementId 0 0 0
ConfigReponseDB.findByPlatformId 18 729 18
ConfigReponseDB.findByServerId 248 6096 248
ConfigReponseDB.findByServiceId 616 295 616
CpropKey.findByKey 409 623 409
DerivedMeasurement.findByCategory 1 899 1
DerivedMeasurement.findByInstance 529 44 529
DerivedMeasurement.findByInstance_with_interval 544 7006 544
DerivedMeasurement.findByTemplateForInstance 2683 580 2683
DerivedMeasurement.findDesignatedByInstance 61 10087 61
DerivedMeasurement.findDesignatedByInstanceForCategory 0 0 0
DerivedMeasurement.findIdsByTemplateForInstances 37 210 37
DownMetricsCache 1914 542060 2332064
EscalationState.findByTypeAndDef 0 0 0
GalertLog.findByCreateTime 100 0 530
LiveData 0 0 0
MeasurementTemplate.findTemplates 0 0 0
MetricDataCache 10593 2902025 11115
MetricViewer 39 5863 39
Operation.findByTypeAndName 5 4309 5
PermissionCache 0 0 0
Platform.findAll_orderName 1 9 1
RawMeasurement.findByTemplateForInstance 2708 2651 2708
Resource.findByInstanceId 119 619 119
ResourceGroup.findByName 1 53 1
ResourceGroup.getMaxCollectionInterval 0 0 0
ResourceGroup.getMetricsCollecting 0 0 0
ResourceType.findByName 8 9682 8
RoleDashboardConfig.findAllRoleDashboards 0 0 0
RoleDashboardConfig.findDashboard 0 0 0
SRNCache 2215 4001174 0
Server.findAll_orderName 0 0 0
Server.findByPlatformAndType_orderName 29 95 29
Server.findByPlatform_orderName 20 90 20
Service.findAll_orderName 0 0 0
Service.findByServerAndType 1 1 1
Service.findPlatformServices 20 180 20
ServiceMergerWorking 7 390 17
ServiceType.findByName 303 205 303
UserDashboardConfig.findDashboard 2 2177 2
Virtual.findVirtualByPhysicalId 8 24 8
org.hibernate.cache.StandardQueryCache 0 0 0
org.hibernate.cache.UpdateTimestampsCache 51 481580 21577
org.hyperic.hq.appdef.Agent 52 206539 52
org.hyperic.hq.appdef.AgentType 1 810 2
org.hyperic.hq.appdef.ConfigResponseDB 1119 6428 4503
org.hyperic.hq.appdef.Ip 113 3567 113
org.hyperic.hq.appdef.ServiceCluster 1 17 1
org.hyperic.hq.appdef.server.session.Platform 52 31269 52
org.hyperic.hq.appdef.server.session.Platform.ips 52 1471 105
org.hyperic.hq.appdef.server.session.Platform.servers 43 22662 88
org.hyperic.hq.appdef.server.session.PlatformType 11 1398 11
org.hyperic.hq.appdef.ser...latformType.serverTypesBag 7 66 7
org.hyperic.hq.appdef.server.session.ResourceAuxLogPojo 0 0 0
org.hyperic.hq.appdef.server.session.Server 474 220848 474
org.hyperic.hq.appdef.server.session.Server.services 377 211536 808
org.hyperic.hq.appdef.server.session.ServerType 115 1742 115
org.hyperic.hq.appdef.ser...on.ServerType.serviceTypes 5 5 5
org.hyperic.hq.appdef.server.session.Service 1995 1093057 1995
org.hyperic.hq.appdef.server.session.ServiceType 385 1413 385
org.hyperic.hq.authz.server.session.AuthzSubject 16 4066 19
org.hyperic.hq.authz.server.session.Operation 53 35747 0
org.hyperic.hq.authz.server.session.ResGrpResMap 0 0 0
org.hyperic.hq.authz.server.session.Resource 3075 28966 3075
org.hyperic.hq.authz.server.session.ResourceGroup 7 101 7
org.hyperic.hq.authz.serv...n.ResourceGroup.resourceSet 2 147 4
org.hyperic.hq.authz.server.session.ResourceGroup.roles 0 0 0
org.hyperic.hq.authz.server.session.ResourceType 14 5063 14
org.hyperic.hq.authz.serv...ssion.ResourceType.findAll 1 2 2
org.hyperic.hq.authz.serv...ResourceType.operationsBag 14 5063 28
org.hyperic.hq.authz.server.session.Role.calendarBag 0 0 0
org.hyperic.hq.authz.server.session.RoleCalendar 0 0 0
org.hyperic.hq.authz.server.session.UserConfigResp 0 0 0
org.hyperic.hq.bizapp.server.session.UpdateStatus 1 41 1
org.hyperic.hq.common.ConfigProperty 57 29070 57
org.hyperic.hq.common.ConfigProperty.findAll 1 632 1
org.hyperic.hq.common.server.session.Calendar 0 0 0
org.hyperic.hq.common.ser...ession.Calendar.entriesBag 0 0 0
org.hyperic.hq.common.server.session.CalendarEntry 0 0 0
org.hyperic.hq.common.server.session.Crispo 5 2035 10
org.hyperic.hq.common.server.session.Crispo.optsSet 5 2063 10
org.hyperic.hq.common.server.session.CrispoOption 145 128064 145
org.hyperic.hq.common.server.session.CrispoOption.array 145 128773 415
org.hyperic.hq.escalation.server.session.Escalation 1 3 1
org.hyperic.hq.escalation...sion.Escalation.actionsList 0 0 0
org.hyperic.hq.escalation...er.session.EscalationState 0 0 0
org.hyperic.hq.events.server.session.Action 6 26 8
org.hyperic.hq.events.ser...ession.Action.logEntriesBag 1 1 1
org.hyperic.hq.events.server.session.Alert 9 4336 90
org.hyperic.hq.events.server.session.Alert.actionLogBag 7 26 8
org.hyperic.hq.events.ser...sion.Alert.conditionLogBag 10 4384 17
org.hyperic.hq.events.server.session.AlertCondition 6 1534 11
org.hyperic.hq.events.ser...lertCondition.logEntriesBag 1 1 1
org.hyperic.hq.events.server.session.AlertConditionLog 10 4354 10
org.hyperic.hq.events.server.session.AlertDefinition 20 1943 25
org.hyperic.hq.events.ser....AlertDefinition.actionsBag 4 30 7
org.hyperic.hq.events.ser...rtDefinition.conditionsBag 4 27 7
org.hyperic.hq.events.ser...lertDefinition.triggersBag 4 23 7
org.hyperic.hq.events.ser...ession.AlertDefinitionState 20 1943 34
org.hyperic.hq.events.server.session.RegisteredTrigger 96 404 96
org.hyperic.hq.galerts.se...ssion.ExecutionStrategyInfo 0 0 0
org.hyperic.hq.galerts.se...ionStrategyInfo.triggerList 0 0 0
org.hyperic.hq.galerts.se...n.ExecutionStrategyTypeInfo 0 0 0
org.hyperic.hq.galerts.server.session.GalertActionLog 0 0 0
org.hyperic.hq.galerts.server.session.GalertAuxLog 0 0 0
org.hyperic.hq.galerts.se...n.GalertAuxLog.childrenBag 0 0 0
org.hyperic.hq.galerts.server.session.GalertDef 0 0 0
org.hyperic.hq.galerts.se...ssion.GalertDef.strategySet 0 0 0
org.hyperic.hq.galerts.server.session.GalertLog 0 0 0
org.hyperic.hq.galerts.se...ion.GalertLog.actionLogBag 0 0 0
org.hyperic.hq.galerts.se...session.GalertLog.auxLogBag 0 0 0
org.hyperic.hq.galerts.server.session.GtriggerInfo 0 0 0
org.hyperic.hq.hqu.server.session.Attachment 13 501 13
org.hyperic.hq.hqu.server.session.UIPlugin 9 513 9
org.hyperic.hq.hqu.server.session.View 6 503 6
org.hyperic.hq.measurement.server.session.Baseline 0 0 0
org.hyperic.hq.measurement.server.session.Category 4 89729 0
org.hyperic.hq.measuremen...vedMeasurement.baselinesBag 302 406 444
org.hyperic.hq.measurement.server.session.Measurement 42818 4876400 61518
org.hyperic.hq.measuremen...session.MeasurementTemplate 14872 958642 21117
org.hyperic.hq.measuremen...r.session.MetricAuxLogPojo 0 0 0
org.hyperic.hq.measuremen...ver.session.MonitorableType 502 50750 502
org.hyperic.hq.ui.server.session.DashboardConfig 2 1935 2

[admin]

Well, when I look at this, I'm primarily looking at the last column,
the # of misses. If that # is high, it means it's doing a lot of
database roundtrips.

There are a few where large values are expected (down metrics,
timestamps).

In your case, it looks like your caches are performing well.

-- Jon



On Feb 14, 2008, at 10:11 PM, Brian Clark wrote:

> Thanks for offering to go over this with me. Here are the EhCache
> diags that you asked for.
>
> (Sorry, I couldn't figure out how to make these appear mono-spaced
> in this forum post. I attached a text file with the data as it
> appears in the Health report. It is much easier to read that way)
>
> -- Diagnostics: EhCache Diagnostics --
>
> Cache Size
> Hits Misses
> ===== ====
> ==== =====
> Agent.findByAgentToken 61
> 407625 63
> AgentScheduleInQueue 0
> 0 519
> Alert.findByCreateTime 10
> 481 511
> Alert.findByEntity 0
> 0 0
> Application.findByServiceId_orderName 305
> 61 305
> AuthzSubject.findByAuth 3
> 2024 3
> AuthzSubject.findByName 1
> 181 1
> AvailabilitySummary 432
> 27108 487
> Baseline.findByMeasurementId 0
> 0 0
> ConfigReponseDB.findByPlatformId 18
> 729 18
> ConfigReponseDB.findByServerId 248
> 6096 248
> ConfigReponseDB.findByServiceId 616
> 295 616
> CpropKey.findByKey 409
> 623 409
> DerivedMeasurement.findByCategory 1
> 899 1
> DerivedMeasurement.findByInstance 529
> 44 529
> DerivedMeasurement.findByInstance_with_interval 544
> 7006 544
> DerivedMeasurement.findByTemplateForInstance 2683
> 580 2683
> DerivedMeasurement.findDesignatedByInstance 61
> 10087 61
> DerivedMeasurement.findDesignatedByInstanceForCategory 0
> 0 0
> DerivedMeasurement.findIdsByTemplateForInstances 37
> 210 37
> DownMetricsCache 1914
> 542060 2332064
> EscalationState.findByTypeAndDef 0
> 0 0
> GalertLog.findByCreateTime 100
> 0 530
> LiveData 0
> 0 0
> MeasurementTemplate.findTemplates 0
> 0 0
> MetricDataCache 10593
> 2902025 11115
> MetricViewer 39
> 5863 39
> Operation.findByTypeAndName 5
> 4309 5
> PermissionCache 0
> 0 0
> Platform.findAll_orderName 1
> 9 1
> RawMeasurement.findByTemplateForInstance 2708
> 2651 2708
> Resource.findByInstanceId 119
> 619 119
> ResourceGroup.findByName 1
> 53 1
> ResourceGroup.getMaxCollectionInterval 0
> 0 0
> ResourceGroup.getMetricsCollecting 0
> 0 0
> ResourceType.findByName 8
> 9682 8
> RoleDashboardConfig.findAllRoleDashboards 0
> 0 0
> RoleDashboardConfig.findDashboard 0
> 0 0
> SRNCache 2215
> 4001174 0
> Server.findAll_orderName 0
> 0 0
> Server.findByPlatformAndType_orderName 29
> 95 29
> Server.findByPlatform_orderName 20
> 90 20
> Service.findAll_orderName 0
> 0 0
> Service.findByServerAndType 1
> 1 1
> Service.findPlatformServices 20
> 180 20
> ServiceMergerWorking 7
> 390 17
> ServiceType.findByName 303
> 205 303
> UserDashboardConfig.findDashboard 2
> 2177 2
> Virtual.findVirtualByPhysicalId 8
> 24 8
> org.hibernate.cache.StandardQueryCache 0
> 0 0
> org.hibernate.cache.UpdateTimestampsCache 51
> 481580 21577
> org.hyperic.hq.appdef.Agent 52
> 206539 52
> org.hyperic.hq.appdef.AgentType 1
> 810 2
> org.hyperic.hq.appdef.ConfigResponseDB 1119
> 6428 4503
> org.hyperic.hq.appdef.Ip 113
> 3567 113
> org.hyperic.hq.appdef.ServiceCluster 1
> 17 1
> org.hyperic.hq.appdef.server.session.Platform 52
> 31269 52
> org.hyperic.hq.appdef.server.session.Platform.ips 52
> 1471 105
> org.hyperic.hq.appdef.server.session.Platform.servers 43
> 22662 88
> org.hyperic.hq.appdef.server.session.PlatformType 11
> 1398 11
> org.hyperic.hq.appdef.ser...latformType.serverTypesBag 7
> 66 7
> org.hyperic.hq.appdef.server.session.ResourceAuxLogPojo 0
> 0 0
> org.hyperic.hq.appdef.server.session.Server 474
> 220848 474
> org.hyperic.hq.appdef.server.session.Server.services 377
> 211536 808
> org.hyperic.hq.appdef.server.session.ServerType 115
> 1742 115
> org.hyperic.hq.appdef.ser...on.ServerType.serviceTypes 5
> 5 5
> org.hyperic.hq.appdef.server.session.Service 1995
> 1093057 1995
> org.hyperic.hq.appdef.server.session.ServiceType 385
> 1413 385
> org.hyperic.hq.authz.server.session.AuthzSubject 16
> 4066 19
> org.hyperic.hq.authz.server.session.Operation 53
> 35747 0
> org.hyperic.hq.authz.server.session.ResGrpResMap 0
> 0 0
> org.hyperic.hq.authz.server.session.Resource 3075
> 28966 3075
> org.hyperic.hq.authz.server.session.ResourceGroup 7
> 101 7
> org.hyperic.hq.authz.serv...n.ResourceGroup.resourceSet 2
> 147 4
> org.hyperic.hq.authz.server.session.ResourceGroup.roles 0
> 0 0
> org.hyperic.hq.authz.server.session.ResourceType 14
> 5063 14
> org.hyperic.hq.authz.serv...ssion.ResourceType.findAll 1
> 2 2
> org.hyperic.hq.authz.serv...ResourceType.operationsBag 14
> 5063 28
> org.hyperic.hq.authz.server.session.Role.calendarBag 0
> 0 0
> org.hyperic.hq.authz.server.session.RoleCalendar 0
> 0 0
> org.hyperic.hq.authz.server.session.UserConfigResp 0
> 0 0
> org.hyperic.hq.bizapp.server.session.UpdateStatus 1
> 41 1
> org.hyperic.hq.common.ConfigProperty 57
> 29070 57
> org.hyperic.hq.common.ConfigProperty.findAll 1
> 632 1
> org.hyperic.hq.common.server.session.Calendar 0
> 0 0
> org.hyperic.hq.common.ser...ession.Calendar.entriesBag 0
> 0 0
> org.hyperic.hq.common.server.session.CalendarEntry 0
> 0 0
> org.hyperic.hq.common.server.session.Crispo 5
> 2035 10
> org.hyperic.hq.common.server.session.Crispo.optsSet 5
> 2063 10
> org.hyperic.hq.common.server.session.CrispoOption 145
> 128064 145
> org.hyperic.hq.common.server.session.CrispoOption.array 145
> 128773 415
> org.hyperic.hq.escalation.server.session.Escalation 1
> 3 1
> org.hyperic.hq.escalation...sion.Escalation.actionsList 0
> 0 0
> org.hyperic.hq.escalation...er.session.EscalationState 0
> 0 0
> org.hyperic.hq.events.server.session.Action 6
> 26 8
> org.hyperic.hq.events.ser...ession.Action.logEntriesBag 1
> 1 1
> org.hyperic.hq.events.server.session.Alert 9
> 4336 90
> org.hyperic.hq.events.server.session.Alert.actionLogBag 7
> 26 8
> org.hyperic.hq.events.ser...sion.Alert.conditionLogBag 10
> 4384 17
> org.hyperic.hq.events.server.session.AlertCondition 6
> 1534 11
> org.hyperic.hq.events.ser...lertCondition.logEntriesBag 1
> 1 1
> org.hyperic.hq.events.server.session.AlertConditionLog 10
> 4354 10
> org.hyperic.hq.events.server.session.AlertDefinition 20
> 1943 25
> org.hyperic.hq.events.ser....AlertDefinition.actionsBag 4
> 30 7
> org.hyperic.hq.events.ser...rtDefinition.conditionsBag 4
> 27 7
> org.hyperic.hq.events.ser...lertDefinition.triggersBag 4
> 23 7
> org.hyperic.hq.events.ser...ession.AlertDefinitionState 20
> 1943 34
> org.hyperic.hq.events.server.session.RegisteredTrigger 96
> 404 96
> org.hyperic.hq.galerts.se...ssion.ExecutionStrategyInfo 0
> 0 0
> org.hyperic.hq.galerts.se...ionStrategyInfo.triggerList 0
> 0 0
> org.hyperic.hq.galerts.se...n.ExecutionStrategyTypeInfo 0
> 0 0
> org.hyperic.hq.galerts.server.session.GalertActionLog 0
> 0 0
> org.hyperic.hq.galerts.server.session.GalertAuxLog 0
> 0 0
> org.hyperic.hq.galerts.se...n.GalertAuxLog.childrenBag 0
> 0 0
> org.hyperic.hq.galerts.server.session.GalertDef 0
> 0 0
> org.hyperic.hq.galerts.se...ssion.GalertDef.strategySet 0
> 0 0
> org.hyperic.hq.galerts.server.session.GalertLog 0
> 0 0
> org.hyperic.hq.galerts.se...ion.GalertLog.actionLogBag 0
> 0 0
> org.hyperic.hq.galerts.se...session.GalertLog.auxLogBag 0
> 0 0
> org.hyperic.hq.galerts.server.session.GtriggerInfo 0
> 0 0
> org.hyperic.hq.hqu.server.session.Attachment 13
> 501 13
> org.hyperic.hq.hqu.server.session.UIPlugin 9
> 513 9
> org.hyperic.hq.hqu.server.session.View 6
> 503 6
> org.hyperic.hq.measurement.server.session.Baseline 0
> 0 0
> org.hyperic.hq.measurement.server.session.Category 4
> 89729 0
> org.hyperic.hq.measuremen...vedMeasurement.baselinesBag 302
> 406 444
> org.hyperic.hq.measurement.server.session.Measurement 42818
> 4876400 61518
> org.hyperic.hq.measuremen...session.MeasurementTemplate 14872
> 958642 21117
> org.hyperic.hq.measuremen...r.session.MetricAuxLogPojo 0
> 0 0
> org.hyperic.hq.measuremen...ver.session.MonitorableType 502
> 50750 502
> org.hyperic.hq.ui.server.session.DashboardConfig 2
> 1935 2

[bclark_hyperic]

That's good to know. Thanks for looking.

Brian