Reputation: 11
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
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
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