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
