[ 
https://issues.apache.org/jira/browse/CASSANDRA-20448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937087#comment-17937087
 ] 

Stefan Miklosovic commented on CASSANDRA-20448:
-----------------------------------------------

I will park this ticket for a while. We should do (1) first. I wanted to base 
the parsing on classes / same logic we are using elsewhere and without (1) I 
would do the same refactoring around "CmdLineOptions" as done in that PR. There 
is a set of tools which are using CmdLineOptions already and doing the same 
here and parsing it via "new GnuParser()" (again used at multiple places 
already) is the cleanest way of doing this.

(1) https://github.com/apache/cassandra/pull/3899

> Utility sstableexpiredblockers should report the size of expired tables
> -----------------------------------------------------------------------
>
>                 Key: CASSANDRA-20448
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-20448
>             Project: Apache Cassandra
>          Issue Type: Improvement
>          Components: Legacy/Tools
>            Reporter: Brad Schoening
>            Assignee: Stefan Miklosovic
>            Priority: Normal
>             Fix For: 5.x
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> A key reason to run sstableexpiredblockers is that you have disk space 
> accumulating and you wish to investigate what's consuming the disk space.
> If size was included in the output (as shown below), it would make the output 
> more useful. Generally, when you find a blocked expired table, the first step 
> is to check what size it is to see if it's large enough to be a problem.
> {quote}[BigTableReader(path='/var/lib/cassandra/data/keyspace1/standard1-0665ae80b2d711e886c66d2c86545d91/mc-2-big-Data.db')
>  (minTS = 5, maxTS = 5, maxLDT = 2147483647)], blocks 1 expired sstables from 
> getting dropped: 
> [BigTableReader(path='/var/lib/cassandra/data/keyspace1/standard1-0665ae80b2d711e886c66d2c86545d91/mc-3-big-Data.db')
>  (\{*}diskSize = 135.7 GB\{*}, minTS = 1536349775157606, maxTS = 
> 1536349780311159, maxLDT = 1536349780)],
> {quote}
> Also, it would be preferable to report min/max timestamp in date-time format 
> e.g.:
> {quote}        diskSize =134.3 GB, minTimestamp = 
> 2025-03-10T00:00:00.000+00:00
> {quote}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to