cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-8720) Provide tools for finding wide row/partition keys
Date Mon, 24 Aug 2015 20:14:46 GMT

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

Jonathan Ellis commented on CASSANDRA-8720:
-------------------------------------------

As Erick notes, we added the compaction logging in CASSANDRA-9643.  I think that's the best
we can do, because to compute partition size you have to perform the compaction merge across
the different sstables.

We could print partition size from the index file easily enough but that wouldn't tell you
if 100 sstables of 1MB each is a 1MB partition or a 100MB partition.  You need to compact
for that.

> Provide tools for finding wide row/partition keys
> -------------------------------------------------
>
>                 Key: CASSANDRA-8720
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8720
>             Project: Cassandra
>          Issue Type: Improvement
>            Reporter: J.B. Langston
>
> Multiple users have requested some sort of tool to help identify wide row keys. They
get into a situation where they know a wide row/partition has been inserted and it's causing
problems for them but they have no idea what the row key is in order to remove it.  
> Maintaining the widest row key currently encountered and displaying it in cfstats would
be one possible approach.
> Another would be an offline tool (possibly an enhancement to sstablekeys) to show the
number of columns/bytes per key in each sstable. If a tool to aggregate the information at
a CF-level could be provided that would be a bonus, but it shouldn't be too hard to write
a script wrapper to aggregate them if not.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message