[
https://issues.apache.org/jira/browse/CASSANDRA-20448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936804#comment-17936804
]
Stefan Miklosovic edited comment on CASSANDRA-20448 at 3/19/25 1:13 PM:
------------------------------------------------------------------------
Instead of printing timestamps like that, I introduced new option as the third
parameter (defaults to false) which would make it human-readable. Disk size of
SSTable is introduced too but by default in non-human-readable form. When
human-readable parameter is used, it will print it for humans.
usage like:
{code}
./tools/bin/sstableexpiredblockers true ks tb
./tools/bin/sstableexpiredblockers false ks tb
./tools/bin/sstableexpiredblockers ks tb // same as above line
./tools/bin/sstableexpiredblockers
Usage: sstableexpiredblockers [<human readable>] <keyspace> <table>
<human readable> represents placeholder for string 'true' or 'false'. Defaults
to false.
If set to true, timestamps will be printed out as dates instead of numbers.
{code}
was (Author: smiklosovic):
Instead of printing timestamps like that, I introduced new option as the third
parameter (defaults to false) which would make it human-readable. Disk size of
SSTable is introduced too but by default in non-human-readable form. When
human-readable parameter is used, it will print it for humans.
usage like:
{code}
./tools/bin/sstableexpiredblockers ks tb true
./tools/bin/sstableexpiredblockers ks tb false
./tools/bin/sstableexpiredblockers ks tb // same as above line
./tools/bin/sstableexpiredblockers
Usage: sstableexpiredblockers <keyspace> <table> <human readable>
<human readable> represents placeholder for string 'true' or 'false'. Defaults
to false.
If set to true, timestamps will be printed out as dates instead of numbers.
{code}
> 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: 10m
> 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: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
