Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-8720

Provide tools for finding wide row/partition keys

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 5.0-alpha1, 5.0
    • Legacy/Tools
    • None

    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.

      Attachments

        1. 8720.txt
          1 kB
          Brandon Williams

        Issue Links

          is a parent of

          Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-18498 Add option to sstablepartitions for aggregating stats

          • Normal -
          • Triage Needed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CASSANDRA-9643 Warn when an extra-large partition is compacted

          • Normal -
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-16310 Track top partitions (by size and tombstone count) and display in nodetool tablestats

          • Normal -
          • Resolved
          relates to

          New Feature - A new feature of the product, which has yet to be developed. CASSANDRA-18500 Add guardrail for partition size

          • Normal -
          • Resolved
          Testing discovered

          Bug - A problem which impairs or prevents the functions of the product. CASSANDRA-18499 Test Failure: upgrade_through_versions_test.py::TestUpgrade::test_rolling_upgrade_with_internode_ssl

          • Normal -
          • Resolved
          links to

          Web Link GitHub Pull Request #2303

          Activity

            People

              adelapena Andres de la Peña
              jblangston@datastax.com J.B. Langston
              Andres de la Peña
              Brandon Williams
              Votes:
              12 Vote for this issue
              Watchers:
              30 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h
                  1h