how to immediately delete tombstones

Hi, I've deleted 50% of my data row by row now disk usage of cassandra data is more than 80%. The gc_grace of table was default (10 days), now i set that to 0, although many compactions finished but no space reclaimed so far. How could i force deletion of tombstones in sstables and reclaim th

Re: how to immediately delete tombstones

Hi, You need to manually force compaction if you do not care ending up with one big sstable (nodetool compact) On 31 May 2018 at 11:07, onmstester onmstester wrote: > Hi, > I've deleted 50% of my data row by row now disk usage of cassandra data is > more than 80%. > The gc_grace of table was de

Re: how to immediately delete tombstones

Hello, It's a very common but somewhat complex topic. We wrote about it 2 years ago and I really think this post might have answers you are looking for: http://thelastpickle.com/blog/2016/07/27/about-deletes-and-tombstones.html Something that you could try (if you do care ending up with one big s

Re: how to immediately delete tombstones

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 On Thu, 31 May 2018 22:32:32 +0430 Alain RODRIGUEZ wrote

Re: how to immediately delete tombstones

You can compact selective sstables using jmx Call. Sent from my iPhone > On Jun 2, 2018, at 12:04 AM, onmstester onmstester > 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 n

Re: how to immediately delete tombstones

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 / dat