Re: Too many SSTables after rebalancing cluster (LCS)

2014-08-29 Thread Paulo Ricardo Motta Gomes
Deleting the json manifest worked like a charm. After 2 days of compactions I've got 50GB extra space! :) Just a quick addendum, after deleting the json metadata file, I needed to restart the node, otherwise it just reloads the file from memory. Version: 1.2.16 On Wed, Aug 27, 2014 at 8:13 PM, R

Re: Too many SSTables after rebalancing cluster (LCS)

2014-08-27 Thread Robert Coli
On Wed, Aug 27, 2014 at 3:27 PM, Nate McCall wrote: > Another option to force things - deleting the json metadata file for that > table will cause LCS to put all SSTables in level 0 and begin recompacting > them. > That's possible in versions where the level is in a JSON file, which is versions

Re: Too many SSTables after rebalancing cluster (LCS)

2014-08-27 Thread Nate McCall
Another option to force things - deleting the json metadata file for that table will cause LCS to put all SSTables in level 0 and begin recompacting them. On Wed, Aug 27, 2014 at 5:15 PM, Paulo Ricardo Motta Gomes < paulo.mo...@chaordicsystems.com> wrote: > Great idea, will try that (right now i

Re: Too many SSTables after rebalancing cluster (LCS)

2014-08-27 Thread Paulo Ricardo Motta Gomes
Great idea, will try that (right now is 10%, but being more aggressive should hopefully work). Cheers! On Wed, Aug 27, 2014 at 7:02 PM, Nate McCall wrote: > Try turning down 'tombstone_threshold' to something like '0.05' from it's > default of '0.2.' This will cause the SSTable to be considere

Re: Too many SSTables after rebalancing cluster (LCS)

2014-08-27 Thread Nate McCall
Try turning down 'tombstone_threshold' to something like '0.05' from it's default of '0.2.' This will cause the SSTable to be considered for tombstone only compactions more frequently (if %5 of the columns are tombstones instead of 20%). For a bit more info, see: http://www.datastax.com/documentat

Re: Too many SSTables after rebalancing cluster (LCS)

2014-08-26 Thread Robert Coli
On Tue, Aug 26, 2014 at 11:38 AM, Paulo Ricardo Motta Gomes < paulo.mo...@chaordicsystems.com> wrote: > What is the solution here? The good old "change to STCS and then back to > LCS", or is there something less brute force? > In theory you could use user defined compaction via JMX, but I'd proba

Too many SSTables after rebalancing cluster (LCS)

2014-08-26 Thread Paulo Ricardo Motta Gomes
Hey folks, After adding more nodes and moving tokens of "old" nodes to rebalance the ring, I noticed that the "old" nodes had significant more data then the newly bootstrapped nodes, even after cleanup. I noticed that the old nodes had a much larger number of SSTables on LCS CFs, and most of them

Re: Rebalancing cluster

2012-10-01 Thread Darvin Denmian
Hey, now I got it. I'll try it this night :) Thanks for all replies. Regards. On Mon, Oct 1, 2012 at 11:08 AM, Hiller, Dean wrote: > Nodetool has a move command so you can move to a new better token. Read > up on the documentation there. I have not used it yet myselfÅ .good idea > to test it o

Re: Rebalancing cluster

2012-10-01 Thread Hiller, Dean
Nodetool has a move command so you can move to a new better token. Read up on the documentation there. I have not used it yet myselfÅ .good idea to test it on your test cluster first. Dean On 10/1/12 8:03 AM, "Darvin Denmian" wrote: >as you can see there is no "Zero Token". Maybe I did somethi

Re: Rebalancing cluster

2012-10-01 Thread Darvin Denmian
; Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" > mailto:user@cassandra.apache.org>> > Date: Monday, October 1, 2012 6:56 AM > To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" > mailto:user@cassandra.apache.org>> > Subject: Re: Rebalancing cluster > > Did you set up the tokens the way > the manual says?

Re: Rebalancing cluster

2012-10-01 Thread Hiller, Dean
Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Date: Monday, October 1, 2012 6:56 AM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject

Re: Rebalancing cluster

2012-10-01 Thread Darvin Denmian
Hi, 1) Yes. I'm using Random Partitioner 2) All 3 nodes in the cluster have used "auto_bootstrap" to acquire their part of data (I really don't know if this is correct). Regards. On Sat, Sep 29, 2012 at 5:56 AM, Bradford Toney wrote: > Are you using the random partitoner? Did you set up the tok

Re: Rebalancing cluster

2012-09-29 Thread Bradford Toney
Are you using the random partitoner? Did you set up the tokens the way the manual says? Sent from my iPhone On Sep 28, 2012, at 7:55 AM, Darvin Denmian wrote: > Hi, > > currently my Cassandra cluster has 3 nodes and I'm facing a very common > problem... Rebalance the data of the cluster. > At