CODEWITHSUNDEEP
cassandracassandra-2.0
Jaya
Jaya

Reputation: 11

how to stop snapshot being taken while deleting tables or keyspaces in cassandra

While dropping a table or keyspace, Cassandra takes a backup of all sstables. How to avoid this as I am dropping the table, I no longer need the table? The same snapshot is taken while dropping a keyspace also. Which is easier in terms of work done by Cassandra, a keyspace drop or table drop?

Upvotes: 1

Views: 492

Answers (2)

Guillermo Schwarz
Guillermo Schwarz

Reputation: 21

Dropping the keyspaces doesn't delete the data.

After dropping the keyspaces, to free the memory, you need to go into the data subdirectory and "rm -rf [the individual keyspaces]".

Upvotes: 0

Richard
Richard

Reputation: 11110

To disable the snapshot, set auto_snapshot: true in cassandra.yaml and restart your instances. The snapshot is there to guard against accidental deletion.

To do a keyspace drop, all the tables need to be dropped too.

Upvotes: 1

Related Questions