[
https://issues.apache.org/jira/browse/CASSANDRA-18541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724612#comment-17724612
]
Stefan Miklosovic commented on CASSANDRA-18541:
-----------------------------------------------
I think this is a question more for Datastax Java driver Jira rather than for
Cassandra itself.
Have you read all of this here?
https://docs.datastax.com/en/developer/java-driver/4.4/manual/core/pooling/
https://docs.datastax.com/en/developer/java-driver/4.4/manual/core/pooling/#heartbeat
> AUTH requests use too much resources
> ------------------------------------
>
> Key: CASSANDRA-18541
> URL: https://issues.apache.org/jira/browse/CASSANDRA-18541
> Project: Cassandra
> Issue Type: Bug
> Reporter: Yury Vidineev
> Priority: Normal
> Attachments: Screenshot_20230520_000633.png,
> Screenshot_20230520_000654.png
>
>
> Hello. I see unexpected CPU usage in a rare situation that may be worth
> digging into.
> We have C* 4.0.9 on Debian running on Java 11.0.18.
> It's a small cluster of 3 nodes on commodity hardware (6 cores CPU, 32 Gb
> RAM, 2 x 512 Gb SSD NVME).
> This ring has about 35 clients using Datastax Java Driver for Apache
> Cassandra.
> In the driver connection settings, we use the following:
> CONNECTION_POOL_LOCAL_SIZE = 400
> CONNECTION_POOL_REMOTE_SIZE = 100
>
> And for some reason, from time to time, it causes hundreds of AUTH requests
> per second that leads to an enormous CPU usage.
> And yes, it's easy not to use these settings in the driver, leaving defaults
> that don't produce such an amount of AUTHs. But isn't it weird that ~150 AUTH
> rps consume ~1200% CPU?
> Please see attached graphs.
> I have the following in the settings:
> authenticator: PasswordAuthenticator
> authorizer: CassandraAuthorizer
> roles_validity_in_ms: 600000
> permissions_validity_in_ms: 600000
> credentials_validity_in_ms: 600000
> Please let me know if I can provide any other necessary information.
> Thanks for your work. Cassandra is amazing :)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
