cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joseph Tech <jaalex.t...@gmail.com>
Subject LeveledCompaction sstable counts
Date Fri, 06 May 2016 13:15:22 GMT
Hi,

Please let me know how to interpret the below output from cfstats,
especially the entry in bold.

SSTable count: 947
SSTables in each level: [1, 10, *104/100*, 832, 0, 0, 0, 0, 0]

We are using C* 2.0.14.459 (DSE version 4.6.7). and the table has been
created with :

compaction={'sstable_size_in_mb':* '50',* 'class':
'LeveledCompactionStrategy'}

I checked the data directory for this table, and as expected, there are 947
sstables, most of them about 50 MB in size, and around 350 of them that are
3 months old (going by file timestamp).

This table has just 1 partition key and 1 column (both string type). The
column holds a JSON string and the pattern involving multiple updates and
reads (b/n 100-500). The row has a TTL of 6 months to 1 year (depending on
kind of record).

We are not experiencing any issues at the moment, but wanted to know if
these stats indicate anything good/bad. When can we expect the old sstable
files to be deleted?

Thanks,
Joseph

Mime
View raw message