Re: How to deal with too many sstables

2015-02-02 Thread 曹志富
You are right.I have already change cold_reads_to_omit to 0.0. -- 曹志富 手机:18611121927 邮箱:caozf.zh...@gmail.com 微博:http://weibo.com/boliza/ 2015-02-03 14:15 GMT+08:00 Roland Etzenhammer : > Hi, > > maybe you are running into an issue that I also had on my test

Re: How to deal with too many sstables

2015-02-02 Thread Roland Etzenhammer
Hi, maybe you are running into an issue that I also had on my test cluster. Since there were almost no reads on it cassandra did not run any minor compactions at all. Solution for me (in this case) was: ALTER TABLE WITH compaction = {'class': 'SizeTieredCompactionStrategy', 'min_threshold':

Re: How to deal with too many sstables

2015-02-02 Thread Marcus Eriksson
https://issues.apache.org/jira/browse/CASSANDRA-8635 On Tue, Feb 3, 2015 at 5:47 AM, 曹志富 wrote: > Just run nodetool repair. > > The nodes witch has many sstables are newest in my cluster.Before add > these nodes to my cluster ,my cluster have not compaction automaticly > because my cluster is an

Re: How to deal with too many sstables

2015-02-02 Thread 曹志富
Just run nodetool repair. The nodes witch has many sstables are newest in my cluster.Before add these nodes to my cluster ,my cluster have not compaction automaticly because my cluster is an only write cluster. thanks. -- 曹志富 手机:18611121927 邮箱:caozf.zh...@gmai

Re: How to deal with too many sstables

2015-02-02 Thread Flavien Charlon
Did you run incremental repair? Incremental repair is broken in 2.1 and tends to create way too many SSTables. On 2 February 2015 at 18:05, 曹志富 wrote: > Hi,all: > I have 18 nodes C* cluster with cassandra2.1.2.Some nodes have aboud > 40,000+ sstables. > > my compaction strategy is STCS. > > Coul

How to deal with too many sstables

2015-02-02 Thread 曹志富
Hi,all: I have 18 nodes C* cluster with cassandra2.1.2.Some nodes have aboud 40,000+ sstables. my compaction strategy is STCS. Could someone give me some solution to deal with this situation. Thanks. -- 曹志富 手机:18611121927 邮箱:caozf.zh...@gmail.com 微博:http://wei