Lyubo Kamenov <k...@heroku.com> writes: > Maybe increase the number of tables that can be compacted by minor > compactions[1], > i.e. max_threshold (default is set to 32). > > 1. > https://docs.datastax.com/en/cql/3.1/cql/cql_reference/compactSubprop.html?scroll=compactSubprop__compactionSubpropertiesDTCS >
I see that after the timestamp_resolution change to MICROSECONDS, slowly the count is decreasing. I will give it some more time and if not helping I will try putting higher value for max_threshold. Thanks and Regards Noorul > On Mon, Feb 29, 2016 at 9:28 PM, Noorul Islam Kamal Malmiyoda < > noo...@noorul.com> wrote: > >> Hello Marcus, >> >> I altered the table to set timestamp_resolution to 'MICROSECONDS'. I >> waited for sometime, but the sstable count did not come down. Do you >> think I should specific command to reduce the count of sstables after >> setting this? >> >> Thanks and Regards >> Noorul >> >> >> On Mon, Feb 29, 2016 at 7:22 PM, Marcus Eriksson <krum...@gmail.com> >> wrote: >> > why do you have 'timestamp_resolution': 'MILLISECONDS'? It should be >> left as >> > default (MICROSECONDS) unless you do "USING TIMESTAMP >> > <milliseconds>"-inserts, see >> > https://issues.apache.org/jira/browse/CASSANDRA-11041 >> > >> > On Mon, Feb 29, 2016 at 2:36 PM, Noorul Islam K M <noo...@noorul.com> >> wrote: >> >> >> >> >> >> Hi all, >> >> >> >> We are using below compaction settings for a table >> >> >> >> compaction = {'timestamp_resolution': 'MILLISECONDS', >> >> 'max_sstable_age_days': '365', 'base_time_seconds': '60', 'class': >> >> 'org.apache.cassandra.db.compaction.DateTieredCompactionStrategy'} >> >> >> >> But it is creating too many sstables. Currently number of sstables >> >> is 40000. We have been injecting data for the last three days. >> >> >> >> We have set the compactionthroughput to 128 MB/s >> >> >> >> $ nodetool getcompactionthroughput >> >> >> >> Current compaction throughput: 128 MB/s >> >> >> >> But this is not helping. >> >> >> >> How can we control the number of sstables in this case? >> >> >> >> Thanks and Regards >> >> Noorul >> > >> > >>
