Re: Snapshots space question

[Arvinder Dhillon]

You need to check if something/someone create snapshots.
Maybe your application drops and recreate tables, and "create snapshot
before drop" setting is enabled in your Cassandra setup?

-Arvi

On Tue, Feb 16, 2021, 1:04 PM Joe Obernberger <joseph.obernber...@gmail.com>
wrote:

> Hello all - I'm seeing a lot of disk usage by snapshots.  On this
> particular node /data/1/cassandra, and /data/2/cassandra are the mount
> points Cassandra is using for disk storage:
>
> du -s -h /data/1/cassandra
> 211G    /data/1/cassandra
> du -s -h /data/2/cassandra
> 343G    /data/2/cassandra
>
> nodetool listsnapshots
>
> Snapshot Details:
> Snapshot name
> Keyspace name Column family name True size  Size on disk
> truncated-1613059667093-extractedmetadata doc         Â
> extractedmetadata  6.46 GiB   9.62 GiB
> truncated-1613171359910-datasources       doc         Â
> datasources        5.35 KiB   6.34 KiB
> truncated-1604519912217-extractedmetadata doc         Â
> extractedmetadata  0 bytes    1.37 KiB
> truncated-1613171349850-seq
> doc         Â seq                19.64 KiB
> 20.53 KiB
> truncated-1609811731202-ftametrics        doc         Â
> ftametrics         2.25 MiB   2.25 MiB
> truncated-1613399333453-datasources       doc         Â
> datasources        10.64 KiB  11.66 KiB
> truncated-1607634106229-ftametrics        doc         Â
> ftametrics         260.83 KiB 262.22 KiB
> truncated-1602601520243-events            system_traces
> events             445.59 KiB 445.68 KiB
> truncated-1613059536491-binary_data       doc         Â
> binary_data        8.42 GiB   8.42 GiB
> truncated-1613399357140-seq
> doc         Â seq                9.83 KiB
> 10.69 KiB
> truncated-1602601654401-events            system_traces
> events             0 bytes    13 bytes
> truncated-1602601536768-events            system_traces
> events             0 bytes    13 bytes
> truncated-1605902489665-binary_data       doc         Â
> binary_data        1.19 GiB   1.19 GiB
> truncated-1602697810806-events            system_traces
> events             0 bytes    13 bytes
> truncated-1613059547371-binary_docs       doc         Â
> binary_docs        2.26 MiB   2.26 MiB
> truncated-1605902490413-binary_docs       doc         Â
> binary_docs        70.69 KiB  71.67 KiB
> truncated-1609796926674-ftametrics        doc         Â
> ftametrics         2.11 MiB   2.11 MiB
>
> Total TrueDiskSpaceUsed: 16.09 GiB
>
> Now I execute:
> nodetool clearsnapshot
>
> Disk usage dropped by 488G.Â
>
> du -s -h /data/1/cassandra
> 30G     /data/1/cassandra
> du -s -h /data/2/cassandra
> 36G     /data/2/cassandra
>
> Could there be something wrong with my setup (Cassandra 3.11.9). Thanks!
>
> -Joe
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
> For additional commands, e-mail: user-h...@cassandra.apache.org
>
>