[jira] [Commented] (CASSANDRA-18541) AUTH requests use too much resources

["Stefan Miklosovic (Jira)" <ji...@apache.org>]

    [ 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: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org