reducing disk space consumption

[Ted Yu <yu...@gmail.com>]

Hi,
I am using DSE 4.8.4
On one node, disk space is low where:

42G /var/lib/cassandra/data/usertable/data-0abea7f0cf9211e5a355bf8dafbfa99c

Using CLI, I dropped keyspace usertable but the data dir above still
consumes 42G.

What action would free this part of disk (I don't need the data) ?

Thanks

Re: reducing disk space consumption

[Ted Yu <yu...@gmail.com>]

Thanks, Mohammed and Romain.

On Thu, Feb 11, 2016 at 12:54 AM, Romain Hardouin <ro...@yahoo.fr>
wrote:

> As Mohammed said "nodetool clearsnaphost" will do the trick.
> Cassandra takes a snapshot by default before keyspace/table dropping or
> truncation.
> You can disable this feature if it's a dev node (see auto_snapshot in
> cassandra.yaml) but if it's a production node is a good thing to keep auto
> snapshots.
>
> Best,
>
> Romain
>

Re: reducing disk space consumption

[Romain Hardouin <ro...@yahoo.fr>]

As Mohammed said "nodetool clearsnaphost" will do the trick.
Cassandra takes a snapshot by default before keyspace/table dropping or truncation.
You can disable this feature if it's a dev node (see auto_snapshot in cassandra.yaml) but if it's a production node is a good thing to keep auto snapshots.

Best,

Romain

RE: reducing disk space consumption

[Mohammed Guller <mo...@glassbeam.com>]

If I remember it correctly, C* creates a snapshot when you drop a keyspace. Run the following command to get rid of the snapshot:
nodetool clearsnapshot

Mohammed
Author: Big Data Analytics with Spark<http://www.amazon.com/Big-Data-Analytics-Spark-Practitioners/dp/1484209656/>

From: Ted Yu [mailto:yuzhihong@gmail.com]
Sent: Wednesday, February 10, 2016 6:59 AM
To: user@cassandra.apache.org
Subject: reducing disk space consumption

Hi,
I am using DSE 4.8.4
On one node, disk space is low where:

42G     /var/lib/cassandra/data/usertable/data-0abea7f0cf9211e5a355bf8dafbfa99c

Using CLI, I dropped keyspace usertable but the data dir above still consumes 42G.

What action would free this part of disk (I don't need the data) ?

Thanks

Re: reducing disk space consumption

[sai krishnam raju potturi <ps...@gmail.com>]

suggestion :  try the following command  "lsof | grep DEL". If in the
output if you see a lot of SSTable files; restart the node. The disk space
will be claimed back.


thanks
Sai

On Wed, Feb 10, 2016 at 9:59 AM, Ted Yu <yu...@gmail.com> wrote:

> Hi,
> I am using DSE 4.8.4
> On one node, disk space is low where:
>
> 42G
> /var/lib/cassandra/data/usertable/data-0abea7f0cf9211e5a355bf8dafbfa99c
>
> Using CLI, I dropped keyspace usertable but the data dir above still
> consumes 42G.
>
> What action would free this part of disk (I don't need the data) ?
>
> Thanks
>