t; compactions as you write to the system compared to STCS because LCS is
> always trying to keep a 1 to 10 ratio between levels. While LCS will
> involve more compaction in general(more I/o, more cpu), I am not sure on
> update vs. insert though From what I understand STCS will happily dup
will constantly compact….well, that is my understanding. Have you tried
>> STCS out at all? (ps. This is just from what I understand so take with a
>> grain of salt).
>>
>> Also, there are some great tools in the nodetool tool as well so you can get
>> nodetool compac
t;> get nodetool compactionstats, etc. etc. and see how backlogged you are in
>> pending tasks….how many pending?
>>
>> Later,
>> Dean
>>
>> From: Jay Svc mailto:jaytechg...@gmail.com>>
>> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.ap
tc. etc. and see how backlogged you are in pending
> tasks….how many pending?
>
> Later,
> Dean
>
> From: Jay Svc mailto:jaytechg...@gmail.com>>
> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>"
> mailto:user@cassandra.apache.o
g<mailto:user@cassandra.apache.org>>
> Date: Tuesday, March 26, 2013 6:08 PM
> To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <
> user@cassandra.apache.org<mailto:user@cassandra.apache.org>>
> Subject: Re: Insert v/s Update performanc
mailto:jaytechg...@gmail.com>>
Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>"
mailto:user@cassandra.apache.org>>
Date: Tuesday, March 26, 2013 6:08 PM
To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>"
mailto:user@ca
Thanks Dean,
I have used LCS with sstable_size_in_mb of 15. I have also tried bigger
sstable_size_in_mb and observed simillar behavior.
Does compaction works differently for update v/s Insert? I belive all keys
goes to single SST. What other options I should look into?
Thanks,
Jay
On Tue, Ma
Most likely compaction kicks in as updates cause duplicated rows in STCS and
compaction causes load that may not have been there before(check your logs).
Also, you can increase the number of nodes in your cluster as well to better
handle the load.
Later,
Dean
From: Jay Svc mailto:jaytechg...@
