Hi Dmitry, could you tell us which compaction strategy that table is currently using ? Also, what is the compaction max throughput and is auto-compaction correctly enabled on that node ?
Did you recently run repair ? Thanks, On Thu, Apr 5, 2018 at 10:53 AM Dmitry Simonov <dimmobor...@gmail.com> wrote: > Hello! > > Could you please give some ideas on the following problem? > > We have a cluster with 3 nodes, running Cassandra 2.2.11. > > We've recently discovered high CPU usage on one cluster node, after some > investigation we found that number of sstables for one CF on it is very > big: 5800 sstables, on other nodes: 3 sstable. > > Data size in this keyspace was not very big ~100-200Mb per node. > > There is no such problem with other CFs of that keyspace. > > nodetool compact solved the issue as a quick-fix. > > But I'm wondering, what was the cause? How prevent it from repeating? > > -- > Best Regards, > Dmitry Simonov > -- ----------------- Alexander Dejanovski France @alexanderdeja Consultant Apache Cassandra Consulting http://www.thelastpickle.com