# Toppartition from System\_auth keyspace **URL:** \ **Category:** ScyllaDB\ **Tags:** authorization, hot-partition\ **Created:** [April 17, 2024, 9:59am UTC](https://forum.scylladb.com/t/toppartition-from-system-auth-keyspace/1492 "2024-04-17T09:59:00Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![sdnaffi](https://avatars.discourse-cdn.com/v4/letter/s/8edcca/32.png) [@sdnaffi](https://forum.scylladb.com/u/sdnaffi)\ **Post date:** [April 17, 2024, 9:59am UTC](https://forum.scylladb.com/t/toppartition-from-system-auth-keyspace/1492/1 "2024-04-17T09:59:00Z")
What could be the reason for system\_auth:roles to become top hot partition? ![image](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/1X/5bfba2bb6a198e0c0e09eebcf3adf815d7db3b3a.png) > READS Sampler: > Cardinality: ~256 (256 capacity) > Top 10 partitions: > Partition Count +/- > (system\_auth:roles) user1 19119 85 ---
**Author:** ![Marcin\_Maliszkiewicz](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/marcin_maliszkiewicz/32/37_2.png) [@Marcin\_Maliszkiewicz](https://forum.scylladb.com/u/Marcin_Maliszkiewicz)\ **Post date:** [April 18, 2024, 9:43am UTC](https://forum.scylladb.com/t/toppartition-from-system-auth-keyspace/1492/2 "2024-04-18T09:43:29Z")
Is it possible that you create lots of connections instead of reusing them? ---
**Author:** ![sdnaffi](https://avatars.discourse-cdn.com/v4/letter/s/8edcca/32.png) [@sdnaffi](https://forum.scylladb.com/u/sdnaffi)\ **Post date:** [April 18, 2024, 2:55pm UTC](https://forum.scylladb.com/t/toppartition-from-system-auth-keyspace/1492/3 "2024-04-18T14:55:07Z")
When we reach to this count ~19119 with system\_auth:roles table, cql connection timeouts. How can we identify the maximum no of connections a cluster can support without timeouts? ---
**Author:** ![Marcin\_Maliszkiewicz](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/marcin_maliszkiewicz/32/37_2.png) [@Marcin\_Maliszkiewicz](https://forum.scylladb.com/u/Marcin_Maliszkiewicz)\ **Post date:** [April 18, 2024, 3:08pm UTC](https://forum.scylladb.com/t/toppartition-from-system-auth-keyspace/1492/4 "2024-04-18T15:08:46Z")
You should be able to observe it in monitoring under “Scylla CQL” dashboard we have " Client CQL new connections by Instance" and “Client CQL connections by Instance”. It’s more about new connection rate than current connection pool, although both have their limits depending on your hardware. ---
**Author:** ![sdnaffi](https://avatars.discourse-cdn.com/v4/letter/s/8edcca/32.png) [@sdnaffi](https://forum.scylladb.com/u/sdnaffi)\ **Post date:** [April 18, 2024, 3:49pm UTC](https://forum.scylladb.com/t/toppartition-from-system-auth-keyspace/1492/5 "2024-04-18T15:49:25Z")
> [@Marcin\_Maliszkiewicz](#): > > Client CQL new connections by Instance I dont see this panel in “Scylla SQL” dashboard. What metrics it checks? ---
**Author:** ![Marcin\_Maliszkiewicz](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/marcin_maliszkiewicz/32/37_2.png) [@Marcin\_Maliszkiewicz](https://forum.scylladb.com/u/Marcin_Maliszkiewicz)\ **Post date:** [April 18, 2024, 5:02pm UTC](https://forum.scylladb.com/t/toppartition-from-system-auth-keyspace/1492/6 "2024-04-18T17:02:28Z")
Perhaps you don’t have the latest version? It checks scylla\_transport\_current\_connections metric (and it’s rate). ---
**Author:** ![sdnaffi](https://avatars.discourse-cdn.com/v4/letter/s/8edcca/32.png) [@sdnaffi](https://forum.scylladb.com/u/sdnaffi)\ **Post date:** [April 18, 2024, 5:29pm UTC](https://forum.scylladb.com/t/toppartition-from-system-auth-keyspace/1492/7 "2024-04-18T17:29:04Z")
Thank you, Added the panel to dashboad. Rate was less than 0 and at some point it goes to 3.7. How to interpret this? ---
**Author:** ![Marcin\_Maliszkiewicz](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/marcin_maliszkiewicz/32/37_2.png) [@Marcin\_Maliszkiewicz](https://forum.scylladb.com/u/Marcin_Maliszkiewicz)\ **Post date:** [April 18, 2024, 5:57pm UTC](https://forum.scylladb.com/t/toppartition-from-system-auth-keyspace/1492/8 "2024-04-18T17:57:28Z")
I’d say it’s rather low value, by default it would mean connections per second. And how many connections do you have? (remember to make sure it’s aggregated over all nodes and shards)