[ https://issues.apache.org/jira/browse/PHOENIX-5281?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17225738#comment-17225738 ]
Elias Adhanom commented on PHOENIX-5281: ---------------------------------------- We are experiencing similar issue. Any thing new here? Were you able to find resolution for this [~laran]. > 95%+ of request time spent in Phoenix driver > -------------------------------------------- > > Key: PHOENIX-5281 > URL: https://issues.apache.org/jira/browse/PHOENIX-5281 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.7.0 > Environment: We're running on Azure using HDInsight for HBase. > Reporter: Laran Evans > Priority: Major > Attachments: Screen Shot 2019-05-14 at 6.14.29 PM.png, Screen Shot > 2019-05-14 at 6.14.29 PM.png, Screen Shot 2019-05-14 at 6.38.39 PM.png > > > Our application consistently spends 95% of it's time in what shows up in New > Relic as "Reading database result". From what I've read, this usually means > that the time is being spent in the database driver, which in our case is > org.apache.phoenix:phoenix-core:4.7.0-HBase-1.1 > I have profiled the application and all I see is this: > !Screen Shot 2019-05-14 at 6.14.29 PM.png! > All I see is lots of time in poll(). > Here's the line of code from Phoenix: > [https://github.com/apache/phoenix/blob/4.7.0-HBase-1.1/phoenix-core/src/main/java/org/apache/phoenix/job/AbstractRoundRobinQueue.java#L136] > It isn't clear to me why this takes so long? > Here you see that 96% of the response time is stuck in that one section. It > seems that the two select queries themselves are very fast. All the time is > spent in reading the result set. > !Screen Shot 2019-05-14 at 6.38.39 PM.png! > What are some likely reasons why this might be happening? And how can we fix > it? > Thanks. -- This message was sent by Atlassian Jira (v8.3.4#803005)