[
https://issues.apache.org/jira/browse/PHOENIX-1118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14351749#comment-14351749
]
James Taylor commented on PHOENIX-1118:
---------------------------------------
Hello [~nishani],
Welcome aboard. This task is an interesting one, but it's also somewhat open
ended and exploratory in nature. Most folks involved in Phoenix are back-end
database developers, so visualization is outside of our area of expertise. The
way I'd approach this JIRA is as follows:
- Familiarize yourself with the nature of the tracing data (see
http://phoenix.apache.org/tracing.html) and understand the schema of the
SYSTEM.TRACING_STATS table. Keep in mind that this trace information is
measuring: the overall wall clock time that a query took to execute, the per
region server wall clock time that the query took to execute (i.e. the query is
parallelized on the client and run across many different machines on your
cluster). Sounds like you're already familiar with PHOENIX-1115 and the new
mechanism to turn tracing on and off (note this is not released yet, so I'd
recommend using the 4.0 branch that contains this feature).
- Take a look at how other database tools visualize trace information. For
example, Postgres, MySQL, SQLServer, Cassandra, etc.
- Make a proposal for how you're thinking to visualize this information.
Perhaps a good first step would be some kind of charting using D3 over the
SYSTEM.TRACING_STATS table. Hopefully you're familiar with SQL, as that's what
you'll use to query this table.
- The Phoenix community will give you feedback on your proposal, so we can
iterate on that.
If this sounds good to you, please follow all of the steps outlined in
PHOENIX-1660 to get set up.
> Provide a tool for visualizing Phoenix tracing information
> ----------------------------------------------------------
>
> Key: PHOENIX-1118
> URL: https://issues.apache.org/jira/browse/PHOENIX-1118
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: James Taylor
> Labels: Java, SQL, Visualization, gsoc2015, mentor
>
> Currently there's no means of visualizing the trace information provided by
> Phoenix. We should provide some simple charting over our metrics tables. Take
> a look at the following JIRA for sample queries:
> https://issues.apache.org/jira/browse/PHOENIX-1115?focusedCommentId=14323151&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14323151
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
