On Mon, Sep 28, 2015 at 2:59 AM, Erick Ramirez <er...@ramirez.com.au> wrote:
> have many tables like this, and I'd like to reclaim those spaces sooner. > What would be the best way to do it? Should I run "nodetool compact" when I > see two large files that are 2 weeks old? Is there configuration parameters > I can tune to achieve the same effect? I looked through all the CQL > Compaction Subproperties for STCS, but I am not sure how they can help > here. Any suggestion is welcome. You can use the JMX org.apache.cassandra.db:type=StorageService forceTableCompaction to compact a single table. Last time this came up, Robert Coli also indicated he thought nodetool cleanup would trigger the same thing, but I never got a chance to confirm that as I'd already done something with forceTableCompaction. If you have the data and try a cleanup, please report back your findings.
