[CASSANDRA-8720] Provide tools for finding wide row/partition keys

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 5.0-alpha1, 5.0
• Component/s: Legacy/Tools

Source Control Link

https://github.com/apache/cassandra/commit/e72ec4e82835cef80cf9e9d8c58b25801d4af8c8

Test and Documentation Plan

PR	CI
trunk	j8 j11

• Assignee: Andres de la Peña
• Reporter: J.B. Langston

Authors

Andres de la Peña

Reviewers

Brandon Williams

• Created: 02/Feb/15 21:48
• Updated: 12/Sep/23 13:02
• Resolved: 04/May/23 12:44

Description

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.

Issue Links

• is a parent of: CASSANDRA-18498 Add option to sstablepartitions for aggregating stats
• is related to: CASSANDRA-9643 Warn when an extra-large partition is compacted
• is related to: CASSANDRA-16310 Track top partitions (by size and tombstone count) and display in nodetool tablestats
• relates to: CASSANDRA-18500 Add guardrail for partition size
• Testing discovered: CASSANDRA-18499 Test Failure: upgrade_through_versions_test.py::TestUpgrade::test_rolling_upgrade_with_internode_ssl
• links to: GitHub Pull Request #2303