Hi all, we're working on a Cassandra 0.7.0 production enviroment with a store of data near to 500 GB. We need to periodically remove the tombstones from deleted/expired data performing a major compaction operation through nodetool. After invoking the compaction on a single column family we can see from JConsole that the LiveSSTableCount is going from 15 to 3 while the LiveDiskSpaceUsed is going from 90GB to 50GB. The problem now is that the space on the file system is been taken from Cassandra (I assumed from the old SSTable) and it isn't freed. We have tried to perform a full GC from the JConsole as described in http://wiki.apache.org/cassandra/MemtableSSTable without any success. The space is freed only after a database restart.
How can we free this disk space without restart the db? Thanks you very much, Roberto Bentivoglio