Hello, When you don't have any disk space anymore (or not much), there are things you can do :
*Make some space:* - Remove snapshots (nodetool clearsnapshot) - Remove any heap dump that might be stored there - Remove *old* -tmp- SSTables that could still be around. - Truncate unused table / data: Truncate does not create tombstone, but removes the files, after creating a snapshot (default behavior). Thus truncating/dropping a table and removing the snapshot could produce immediate disk space availability. - Anything else than SSTable in this disk that can be removed? OR *Add some space:* - Add some disk space temporary (EBS, physical disk) - Make sure to clean tombstones ('uncheck_tombstone_compaction: true' often helped) - Wait for tombstones to be compacted with all the data it shadows and disk space to reduce - Remove extra disk OR *Play around, at the edge*: - Look at the biggest SSTables that you can actually compact (be aware of the compressed vs uncompressed sizes when monitoring - I think the thing was that 'nodetool compactionstats -H' shows the values uncompressed) - Use sstablemetadata to determine the ratio of the data that is droppable - Run user defined compaction on these sstables specifically - If it works and there is more disk space available, reproduce with bigger sstables. In some complex cases removing commit logs helped as well, but this is riskier already as it would be playing with consistency/durability considerations. I'm using cassandra on a single node. > I would not play with commit logs with a single-node setup. But I imagine it is not a production 'cluster' either. C*heers, ----------------------- Alain Rodriguez - @arodream - al...@thelastpickle.com France / Spain The Last Pickle - Apache Cassandra Consulting http://www.thelastpickle.com 2018-06-02 8:29 GMT+01:00 Nitan Kainth <nitankai...@gmail.com>: > You can compact selective sstables using jmx Call. > > Sent from my iPhone > > On Jun 2, 2018, at 12:04 AM, onmstester onmstester <onmstes...@zoho.com> > wrote: > > Thanks for your replies > But my current situation is that i do not have enough free disk for my > biggest sstable, so i could not run major compaction or nodetool > garbagecollect > > Sent using Zoho Mail <https://www.zoho.com/mail/> > > > ---- On Thu, 31 May 2018 22:32:32 +0430 *Alain RODRIGUEZ > <arodr...@gmail.com <arodr...@gmail.com>>* wrote ---- > > >