Brad Schoening created CASSANDRA-20448:
------------------------------------------

             Summary: 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
            Reporter: Brad Schoening


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