How to reclaim storage from a column family in Cassandra -



How to reclaim storage from a column family in Cassandra -

i using datastax 2.1 community version in ec2. dropped big table (column family) in keyspace , ran "nodetool compact " opscenter ui, don't see increment in storage capacity.

i ran "nodetool compactionstats " see whether compaction on-going there nothing: $ nodetool compactionstats pending tasks: 0 active compaction remaining time : n/a

is there other process need follow?

cassandra, in default configuration, keeps snapshot of every column family dropped. design don't lose info of cf if accidentally delete cf.

you can disable snapshot creation in cassandra.yaml. docs (see: http://www.datastax.com/documentation/cassandra/2.1/cassandra/configuration/configcassandra_yaml_r.html ):

auto_snapshot (default: true) enable or disable whether snapshot taken of info before keyspace truncation or dropping of tables. prevent info loss, using default setting advised. if set false, lose info on truncation or drop.

if don't disable auto snapshots can remove generated snapshot via nodetool clearsnapshot. see: http://www.datastax.com/documentation/cassandra/2.0/cassandra/tools/toolsclearsnapshot.html

cassandra

Comments

Popular posts from this blog

assembly - What is the addressing mode for ld, add, and rjmp instructions? -

vowpalwabbit - Interpreting Vowpal Wabbit results: Why are some lines appended by "h"? -

Is there a way to convert an HTML page styled with Bootstrap CSS into email-compatible html? -