Ambari Server database

Metrics that show operating status for the Ambari server database.

Table 1. Ambari Server database metrics descriptions
Row	Metrics	Description
TOTAL READ ALL QUERY	Total Read All Query Counter (Rate)	Total ReadAllQuery operations performed.
TOTAL READ ALL QUERY	Total Read All Query Timer (Rate)	Total time spent on ReadAllQuery.
TOTAL CACHE HITS & MISSES	Total Cache Hits (Rate)	Total cache hits on Ambari Server with respect to EclipseLink cache.
TOTAL CACHE HITS & MISSES	Total Cache Misses (Rate)	Total cache misses on Ambari Server with respect to EclipseLink cache.
QUERY	Query Stages Timings	Average time spent on every query sub stage by Ambari Server
QUERY	Query Types Avg. Timings	Average time spent on every query type by Ambari Server.
HOST ROLE COMMAND ENTITY	Counter.ReadAllQuery.HostRoleCommandEntity (Rate)	Rate (num operations per second) in which ReadAllQuery operation on HostRoleCommandEntity is performed.
	Timer.ReadAllQuery.HostRoleCommandEntity (Rate)	Rate in which ReadAllQuery operation on HostRoleCommandEntity is performed.
	ReadAllQuery.HostRoleCommandEntity	Average time taken for a ReadAllQuery operation on HostRoleCommandEntity (Timer / Counter).