cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Ellis <jbel...@gmail.com>
Subject Re: Performance deterioration while building secondary index
Date Sat, 09 Jul 2011 01:51:09 GMT
My guess: index build isn't respecting the background i/o throttle.

On Fri, Jul 8, 2011 at 5:55 PM, Maxim Potekhin <potekhin@bnl.gov> wrote:
> I have roughly 150 million rows in my database, which will grow as I
> continue testing. I'm building an index on a particular column, via
> cassandra-cli, something of the sort:
> update column family jobs with column_metadata = [{column_name : 'DATE',
>   validation_class : AsciiType, index_type : 0, index_name : 'date'}]
>
> At this point, the cluster just becomes unresponsive -- just doing "list" on
> a CF takes a while. Random query test I used to run rather quickly, becomes
> terribly slow (hasn't returned since I started typing this).
>
> Is that normal? I can' imagine this happening in a production situation,
> when I decided to add an index for some valid reasons. Really scratching my
> head now. TIA.
>
> The version is 0.8.1
>
> Thanks!
>



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com

Mime
View raw message