phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mujtaba Chohan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-1693) Stats sometimes cause query to execute more slowly
Date Tue, 03 Mar 2015 18:47:04 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-1693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14345483#comment-14345483
] 

Mujtaba Chohan commented on PHOENIX-1693:
-----------------------------------------

Sure James. I'll get more info. on this soon.

> Stats sometimes cause query to execute more slowly
> --------------------------------------------------
>
>                 Key: PHOENIX-1693
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1693
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Mujtaba Chohan
>
> After initial data load with Phoenix 4.3.0 with stats enabled for 500M FHA table using
Pherf, aggregate count queries over 5% or 15% of total rows are some times 2-5X slow compared
to queries without stats. Needs to investigate the root cause. 
> Observations:
> * After major compaction with new stats are re-generated and queries become fast compared
to tables without stats.
> * Trucating stats table after initial data load also makes queries perf. comparable to
previous Phoenix release with stats disabled.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message