if you are on Cassandra 2.2, it is probably this: https://issues.apache.org/jira/browse/CASSANDRA-10270
On Tue, Sep 15, 2015 at 4:37 AM, Saladi Naidu <naidusp2...@yahoo.com> wrote: > We are using Level Tiered Compaction Strategy on a Column Family. Below > are CFSTATS from two nodes in same cluster, one node has 880 SStables in L0 > whereas one node just has 1 SSTable in L0. In the node where there are > multiple SStables, all of them are small size and created same time stamp. > We ran Compaction, it did not result in much change, node remained with > huge number of SStables. Due to this large number of SSTables, Read > performance is being impacted > > In same cluster, under same keyspace, we are observing this discrepancy in > other column families as well. What is going wrong? What is the solution to > fix this > > *---*NODE1*---* > * Table: category_ranking_dedup* > * SSTable count: 1* > * SSTables in each level: [1, 0, 0, 0, 0, > 0, 0, 0, 0]* > * Space used (live): 2012037* > * Space used (total): 2012037* > * Space used by snapshots (total): 0* > * SSTable Compression Ratio: > 0.07677216119569073* > * Memtable cell count: 990* > * Memtable data size: 32082* > * Memtable switch count: 11* > * Local read count: 2842* > * Local read latency: 3.215 ms* > * Local write count: 18309* > * Local write latency: 5.008 ms* > * Pending flushes: 0* > * Bloom filter false positives: 0* > * Bloom filter false ratio: 0.00000* > * Bloom filter space used: 816* > * Compacted partition minimum bytes: 87* > * Compacted partition maximum bytes: > 25109160* > * Compacted partition mean bytes: 22844* > * Average live cells per slice (last five > minutes): 338.84588318085855* > * Maximum live cells per slice (last five > minutes): 10002.0* > * Average tombstones per slice (last five > minutes): 36.53307529908515* > * Maximum tombstones per slice (last five > minutes): 36895.0* > > *----NODE2--- * > *Table: category_ranking_dedup* > * SSTable count: 808* > * SSTables in each level: [808/4, 0, 0, 0, > 0, 0, 0, 0, 0]* > * Space used (live): 291641980* > * Space used (total): 291641980* > * Space used by snapshots (total): 0* > * SSTable Compression Ratio: > 0.1431106696818256* > * Memtable cell count: 4365293* > * Memtable data size: 3742375* > * Memtable switch count: 44* > * Local read count: 2061* > * Local read latency: 31.983 ms* > * Local write count: 30096* > * Local write latency: 27.449 ms* > * Pending flushes: 0* > * Bloom filter false positives: 0* > * Bloom filter false ratio: 0.00000* > * Bloom filter space used: 54544* > * Compacted partition minimum bytes: 87* > * Compacted partition maximum bytes: > 25109160* > * Compacted partition mean bytes: 634491* > * Average live cells per slice (last five > minutes): 416.1780688985929* > * Maximum live cells per slice (last five > minutes): 10002.0* > * Average tombstones per slice (last five > minutes): 45.11547792333818* > * Maximum tombstones per slice (last five > minutes): 36895.0* > > > > > Naidu Saladi >
