[
https://issues.apache.org/jira/browse/PHOENIX-2178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15196740#comment-15196740
]
Ashish Tiwari commented on PHOENIX-2178:
----------------------------------------
[~mujtabachohan] [~giacomotaylor]
Hi All,
My name is Ashish and I am very interested in working on this project. First
of all, I would like to thank you for mentoring the project. I have started
working on the proposal and would like some inputs on it:
1. I would like to reproduce the inconsistencies in SQL trace results. I am
setting up my local dev environments by following
(https://phoenix.apache.org/develop.html). Are there any performance tests that
I can use to reproduce this?
2. Is there a doc on how the tracing works? What modules are responsible to
report stats and how these stats are collected?
3. How should I go about dividing the tasks for this project?
About me:
I have an undergraduate degree in computer science and starting my master's
degree in computer science from Arizona State University. I also have 5 years
of professional experience developing enterprise web applications in J2EE.
Thanks,
Ashish
> Tracing - total time listed for a certain trace does not correlate with query
> wall clock time
> ---------------------------------------------------------------------------------------------
>
> Key: PHOENIX-2178
> URL: https://issues.apache.org/jira/browse/PHOENIX-2178
> Project: Phoenix
> Issue Type: Sub-task
> Affects Versions: 4.5.0
> Reporter: Mujtaba Chohan
> Labels: gsoc2016, tracing
>
> Wall clock for a count * takes over a large table takes 30000+ms however
> total sum(end_time - start_time) is less than 250ms for trace_id generated
> for this count * query.
> {code}
> Output of trace table:
> select sum(end_time - start_time),count(*), description from
> SYSTEM.TRACING_STATS WHERE TRACE_ID=X group by description;
> +------------------------------------------+------------------------------------------+------------------------------------------+
> | SUM((END_TIME - START_TIME)) | COUNT(1)
> | DESCRIPTION |
> +------------------------------------------+------------------------------------------+------------------------------------------+
> | 0 | 3
> | ClientService.Scan |
> | 240 | 253879
> | HFileReaderV2.readBlock |
> | 1 | 1
> | Scanner opened on server |
> +------------------------------------------+------------------------------------------+------------------------------------------+
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
