Ah - you are correct. auto_snapshot is set to true and there were
recent truncates and drops.
That said, the "Total TrueDiskSpaceUsed: 16.09 GiB" seems to be way
off? Or is that value something else?
Thank you!
-Joe
On 2/16/2021 4:46 PM, Arvinder Dhillon wrote:
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 <mailto: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
<mailto:user-unsubscr...@cassandra.apache.org>
For additional commands, e-mail: user-h...@cassandra.apache.org
<mailto:user-h...@cassandra.apache.org>
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
Virus-free. www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
