phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Kowalczyk <ma...@cloudability.com>
Subject Re: stats table causing slow queries
Date Wed, 14 Oct 2015 19:30:29 GMT
Oh yeah,

hbase-1.1.2
phoenix-4.5.1

Thanks!

On Wed, Oct 14, 2015 at 12:29 PM, Matt Kowalczyk <mattk@cloudability.com>
wrote:

> Hi,
>
> I have a large phoenix table with ~1800 regions. After running a
> compaction, I noticed degraded query performance. After purging the
> system.stat table, query performance returned back to normal.
>
> Surprisingly, using sqlline.py does not cause this slow down. Here are
> some numbers,
>
> (before and after purging system.stat):
>
> sqlline query took: 1 row selected (2.869 seconds)
>
> after compaction, before purging system.stat table:
>
>               mean = 47536.55 milliseconds
>             stddev = 2657.65 milliseconds
>
> after purging system.stat table:
>
>               mean = 57.63 milliseconds
>             stddev = 39.82 milliseconds
>
> Purging the system.stat table removed about ~1755 records.
>
> I have the following related configuration in my hbase-site.xml:
>
>   <property>
>     <name>phoenix.stats.guidepost.per.region</name>
>     <value>10</value>
>   </property>
>
> Any thoughts?
>
> Thanks!
>

Mime
View raw message