phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-1118) Provide a tool for visualizing Phoenix tracing information
Date Sat, 07 Mar 2015 19:17:38 GMT

    [ 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)

Mime
View raw message