[
https://issues.apache.org/jira/browse/PHOENIX-1118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14370997#comment-14370997
]
Nishani commented on PHOENIX-1118:
-----------------------------------
Hi,
I have gone through some resources regarding visualization of trace info on
database servers (Postgres/MySQL, MSSQL).
The DTrace function in MySQL is a profiler that creates flame graphs. [1]
A tool for visualizations of a database system [2]
Generates images with help of GraphViz for
Some data modeling tools [4]
DBVisualizer Tool [5]
Data Visualization Application where data is input from a database or a file
and exported as image or a customized template [6]
Visualizing Postgres [7]
A Research Paper on Modeling Trace Information[8]
A Tool for visualizing Trace Info
Given above is a brief summary of the details I found. Hope it would help me to
better understand the formats and values of the input traces and different
available methods of graphically representing them.
Based on them I hope to come up with the most suitable method of Visually
representing the said data.
Regarding the installation I presume that the HBase version that is needed to
run Phoenix for visualizing trace info can be as Standalone and that cluster
view is not needed(Distributed Version).
Thank you.
BR,
Nishani
[1] http://www.brendangregg.com/FlameGraphs/cpuflamegraphs.html
[2] http://docs.cartodb.com/cartodb-editor.html#visualizations
[3] https://bitbucket.org/zzzeek/sqlalchemy/wiki/UsageRecipes/SchemaDisplay
[4] http://www.databaseanswers.org/modelling_tools.htm
[5] http://www.dbvis.com/
[6] https://sites.google.com/site/datavisualizationapplication/
[7] http://www.pgcon.org/2013/schedule/track/Performance/588.en.html
[8] http://link.springer.com/chapter/10.1007%2F978-3-642-40787-1_13
[9]
http://www.upscene.com/documentation/fbtm3/index.html?qsg_trace_data_visualization.htm
> 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
> Assignee: Nishani
> 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)
