Karthik Manamcheri created HIVE-21045:
-----------------------------------------
Summary: Add connection pool info and rolling performance info to
the metrics system
Key: HIVE-21045
URL: https://issues.apache.org/jira/browse/HIVE-21045
Project: Hive
Issue Type: Improvement
Components: Standalone Metastore
Reporter: Karthik Manamcheri
Assignee: Karthik Manamcheri
There are two key metrics which I think we lack and which would be really great
to help with scaling visibility in HMS.
*Average API duration for the past 'n' minutes*
We already compute and log the duration of API calls in the {{PerfLogger}}. We
don't have any gauge on what the average duration of an API call is for the
past some bucket of time. This will give us an insight into if there is load on
the server which is increasing the average API response time.
*RDBMS Connection wait time*
We can use different connection pooling libraries such as bonecp or hikaricp.
These pool managers expose statistics such as average time waiting to get a
connection, number of connections active, etc. We should expose this as a
metric so that we can track if the the connection pool size configured is too
small and we are saturating!
These metrics would help catch problems with HMS resource contention before
they actually have jobs failing.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
