# \#hot-partition
**URL:** https://forum.scylladb.com/tag/hot-partition/123.md
[Latest](https://forum.scylladb.com/latest.md) · [Categories](https://forum.scylladb.com/categories.md) · [Tags](https://forum.scylladb.com/tags.md)
---
## [Detecting Hot Partitions](https://forum.scylladb.com/t/detecting-hot-partitions/4963)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [July 8, 2025, 5:45am UTC](https://forum.scylladb.com/t/detecting-hot-partitions/4963 "2025-07-08T05:45:14Z")
---
## [P99 and p95 spikes, hot partitions, performance and data modeling](https://forum.scylladb.com/t/p99-and-p95-spikes-hot-partitions-performance-and-data-modeling/4873)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [June 3, 2025, 4:31am UTC](https://forum.scylladb.com/t/p99-and-p95-spikes-hot-partitions-performance-and-data-modeling/4873 "2025-06-03T04:31:48Z")
---
## [Read fails for one node in the cluster, no response received on GCP](https://forum.scylladb.com/t/read-fails-for-one-node-in-the-cluster-no-response-received-on-gcp/4589)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [March 10, 2025, 4:52am UTC](https://forum.scylladb.com/t/read-fails-for-one-node-in-the-cluster-no-response-received-on-gcp/4589 "2025-03-10T04:52:10Z")
---
## [Cluster overloaded? Getting error message: reader\_concurrency\_semaphore - (rate limiting dropped 49 similar messages) Semaphore \_read\_concurrency\_sem with 55/100 count and 13255581/147597557 memory resources: timed out, dumping permit diagnostics:](https://forum.scylladb.com/t/cluster-overloaded-getting-error-message-reader-concurrency-semaphore-rate-limiting-dropped-49-similar-messages-semaphore-read-concurrency-sem-with-55-100-count-and-13255581-147597557-memory-resources-timed-out-dumping-permit-diagnostics/4487)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [February 13, 2025, 10:52am UTC](https://forum.scylladb.com/t/cluster-overloaded-getting-error-message-reader-concurrency-semaphore-rate-limiting-dropped-49-similar-messages-semaphore-read-concurrency-sem-with-55-100-count-and-13255581-147597557-memory-resources-timed-out-dumping-permit-diagnostics/4487 "2025-02-13T10:52:23Z")
---
## [Meaning of reader\_concurrency\_semaphore error, latency spikes and hot partitions](https://forum.scylladb.com/t/meaning-of-reader-concurrency-semaphore-error-latency-spikes-and-hot-partitions/4320)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [January 2, 2025, 7:37am UTC](https://forum.scylladb.com/t/meaning-of-reader-concurrency-semaphore-error-latency-spikes-and-hot-partitions/4320 "2025-01-02T07:37:09Z")
---
## [How to model my data when having subgropus of data with vastly different volumes](https://forum.scylladb.com/t/how-to-model-my-data-when-having-subgropus-of-data-with-vastly-different-volumes/4104)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [December 9, 2024, 4:36am UTC](https://forum.scylladb.com/t/how-to-model-my-data-when-having-subgropus-of-data-with-vastly-different-volumes/4104 "2024-12-09T04:36:09Z")
---
## [Recommendations for partitioning imbalanced data](https://forum.scylladb.com/t/recommendations-for-partitioning-imbalanced-data/3191)
**Author:** [@andres\_rc](https://forum.scylladb.com/u/andres_rc)\
**Replies:** 1\
**Last updated:** [November 22, 2024, 9:08am UTC](https://forum.scylladb.com/t/recommendations-for-partitioning-imbalanced-data/3191 "2024-11-22T09:08:40Z")
Hi all, My team is considering using ScyllaDB (cloud version) to improve cost and efficiency when reading and querying on a couple of our larger datasets. Since we know in advance exactly the kind of queries we want to …
---
## [Limitations of tiny partitions](https://forum.scylladb.com/t/limitations-of-tiny-partitions/3103)
**Author:** [@sandeepm](https://forum.scylladb.com/u/sandeepm)\
**Replies:** 3\
**Last updated:** [October 28, 2024, 2:29pm UTC](https://forum.scylladb.com/t/limitations-of-tiny-partitions/3103 "2024-10-28T14:29:09Z")
I am having around 150 million rows in a table. Each row is a partition which means 150 million partitions. Size of each partition is 24kb. I know that small partitions work perfectly for even distribution of data witho…
---
## [Using a clustering key, impact on performance, data distribution and partition size](https://forum.scylladb.com/t/using-a-clustering-key-impact-on-performance-data-distribution-and-partition-size/2205)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [June 24, 2024, 4:54am UTC](https://forum.scylladb.com/t/using-a-clustering-key-impact-on-performance-data-distribution-and-partition-size/2205 "2024-06-24T04:54:53Z")
---
## [Toppartition from System\_auth keyspace](https://forum.scylladb.com/t/toppartition-from-system-auth-keyspace/1492)
**Author:** [@sdnaffi](https://forum.scylladb.com/u/sdnaffi)\
**Replies:** 7\
**Last updated:** [April 18, 2024, 5:57pm UTC](https://forum.scylladb.com/t/toppartition-from-system-auth-keyspace/1492 "2024-04-18T17:57:28Z")
What could be the reason for system\_auth:roles to become top hot partition? READS Sampler: Cardinality: ~256 (256 capacity) Top 10 partitions: Partition Count …