Re: Disastrous profusion of SSTables

2015-03-26 Thread Anishek Agarwal
Are you frequently updating same rows ? What is the memtable flush size ? can you post the table create query here in please. On Thu, Mar 26, 2015 at 1:21 PM, Dave Galbraith david92galbra...@gmail.com wrote: Hey! So I'm running Cassandra 2.1.2 and using the SizeTieredCompactionStrategy. I'm

Re: Disastrous profusion of SSTables

2015-03-26 Thread graham sanderson
you may be seeing https://issues.apache.org/jira/browse/CASSANDRA-8860 https://issues.apache.org/jira/browse/CASSANDRA-8860 https://issues.apache.org/jira/browse/CASSANDRA-8635 https://issues.apache.org/jira/browse/CASSANDRA-8635 related issues (which ends up with excessive numbers of

Re: Disastrous profusion of SSTables

2015-03-26 Thread Dave Galbraith
It looks like it was CASSANDRA-8860, setting that cold reads to omit thing down to zero took my SSTable count from 641 to 1 and made all my queries work. Thank you!! On Thu, Mar 26, 2015 at 4:55 AM, graham sanderson gra...@vast.com wrote: you may be seeing

Re: Disastrous profusion of SSTables

2015-03-26 Thread Robert Coli
On Thu, Mar 26, 2015 at 12:51 AM, Dave Galbraith david92galbra...@gmail.com wrote: Hey! So I'm running Cassandra 2.1.2 and using the SizeTieredCompactionStrategy. I'm doing about 3k writes/sec on a single node. My read performance is terrible, all my queries just time out. So I do nodetool

Disastrous profusion of SSTables

2015-03-26 Thread Dave Galbraith
Hey! So I'm running Cassandra 2.1.2 and using the SizeTieredCompactionStrategy. I'm doing about 3k writes/sec on a single node. My read performance is terrible, all my queries just time out. So I do nodetool cfstats: Read Count: 42071 Read Latency: 67.47804242827601 ms. Write Count: