Page History

...

Config Name	Default Value	Explanation
source.database.class	org.apache.ambari.server.metrics.system.impl.DatabaseMetricsSource	Class used to collect Database Metrics from extended Performance Monitor class - org.apache.ambari.server.metrics.system.impl.AmbariPerformanceMonitor.
source.database.performance.monitor.query.weight	HEAVY	EclipseLink Performance monitor granularity : NONE / NORMAL / HEAVY / ALL
source.database.monitor.dumptime	60000	Collection interval in milliseconds
source.database.monitor.entities	Cluster(.)Entity,Host(.)Entity,ExecutionCommandEntity, ServiceComponentDesiredStateEntity,Alert(.*)Entity,StackEntity,StageEntity	Only these entities' metrics will be collected and tracked. (org.apache.ambari.server.orm.entities).
source.database.monitor.query.keywords.include	CacheMisses	Include some metrics which have the keyword even if they are not part of requested Entities.

Ambari database metrics have been represented in 2 Grafana dashboards.

'Ambari Server - Database' dashboard
- An aggregate dashboard that displays Total ReadAllQuery, Cache Hits, Cache Misses, Query Stages, Query Types across all entities.
- It also contains an example of how to visualize Timer, Counter and Avg Timing data for a specific entity - HostRoleCommandEntity.
'Ambari Server - Top N Entities' dashboard
- Shows Top N entities that have maximum number of ReadAllQuery operations done on them.
- Shows Top N entities that the database spent the most time in ReadAllQuery operations.
- Shows Top N entities that have maximum Cache Misses

These dashboard graphs are meant to provide an example of how to create graphs to query specific entities or operations in an Ad Hoc manner.

Disabling Ambari Server metrics globally

...