Agreed tracing will help on a query-by-query basis, but I think we don't have a very good usability story yet. Hence the recommendation of exposing info from JMX into an external system like OpenTSDB or DSM.
On Wed, Feb 11, 2015 at 10:45 AM, Samarth Jain <samarth.j...@gmail.com> wrote: > Hi Pariksheet, > > Phoenix Tracing might help you here. See: > http://phoenix.apache.org/tracing.html > > With tracing on, you can get information on the the scans being executed - > duration of each scan, region server on which it is being executed, query > plan etc. All this is logged in the trace table (default - > SYSTEM.TRACING_STATS). You would want to use our latest release 4.3 (soon > to be out) since it has a critical fix for a bug that was causing region > servers to crash (https://issues.apache.org/jira/browse/PHOENIX-1596). > > We have plans for enhancing our tracing framework. See - > https://issues.apache.org/jira/browse/PHOENIX-1121 > > As far as exposing JDBC metrics through JMX, we have something similar > planned for logging client side metrics: > https://issues.apache.org/jira/browse/PHOENIX-1452 > > Hope this helps. > > - Samarth > > > > On Wed, Feb 11, 2015 at 9:00 AM, Nick Dimiduk <ndimi...@gmail.com> wrote: > > > Hi Pari, > > > > I'm not aware of a Phoenix-aware, end-to-end solution here. You can > > probably write a custom collector for a Phenox application that can > report > > into OpenTSDB; I think JDBC metrics are available via JMX. That would be > a > > great addition for that project! > > > > I've also seen a product demo from HP that does a lot of this for other > > tools on HBase, though I don't think it supports Phoenix yet (cc Rohit). > > > > Thanks, > > Nick > > > > On Wednesday, February 11, 2015, Pariksheet Barapatre < > > pbarapa...@gmail.com> > > wrote: > > > > > Hello All, > > > > > > Can you suggest good monitoring tool for phoenix. Our QA hbase cluster > is > > > crashing randomly. We wanted to know stats like which query causing the > > > issue and how many queries running on that particular time window, > > resource > > > consumption of query etc. > > > > > > Cheers > > > Pari > > > > > >