question

sunil281984 avatar image
sunil281984 asked Erick Ramirez edited

Disk space not released after compaction

We have deleted some of the partionons of some tables in cassandra database. But after the delete space was not recliamed becuase of size-tiered compaction . Manualy compacted tables with -s options. we have cluster of having 2 data ceneters and each with 6 nodes, we ran compaction both the DC's of all nodes. But Disk usage on DC1 reduced but 6% increase on the other DC2. So please let me know the reason for this and also suggest me on the next steps 2 bring down the usage of disk on Dc2. for your information even load on both DC's are come down.

Even cleared old snapshots of arounf 1.3TB on all nodes

cassandra
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

smadhavan avatar image
smadhavan answered smadhavan edited

Have you looked at https://dba.stackexchange.com/a/314532 post?

These things might help triage this better:

  1. Version of the Cassandra (for e.g. OSS C* `3.11.10`)
  2. Schema of the table
  3. Exact query used to delete data
  4. Also, could you post the output of command?
find /path/to/dir/ -printf '%s %p\n'| sort -nr | head -10

We can continue this in the StaxExchange question as opposed to duplicating at both places.

Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.