question

suujana.naga16_165607 avatar image
suujana.naga16_165607 asked Erick Ramirez answered

How do I find out the key of a large partition?

I observed one of the table in production has a large partition of size 13.8 gb. How do i find the partition key of that?

data modeling
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

For older versions of Apache Cassandra, you should see message in the logs indicating that a large partition got compacted. For example:

WARN  [CompactionExecutor:21653] 2020-11-30 03:39:14,795  SSTableWriter.java:241 - Compacting large partition acmeKS/veryWideTable:key5678 (45262476248 bytes)

Here's an example output for newer versions:

WARN  [CompactionExecutor:21653] 2021-01-03 02:28:03,684  BigTableWriter.java:248 - Writing large partition acmeKS/veryWideTable:key5678 (45262476248 bytes) to sstable ...

Cheers!

Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.