[
https://issues.apache.org/jira/browse/CASSANDRA-18541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726866#comment-17726866
]
Yury Vidineev commented on CASSANDRA-18541:
-------------------------------------------
Hi! [~smiklosovic] thanks for the most detailed explanation!
Yes, what you said makes total sense. I just didn't expect that 100 authsuccess
rps could be a problem, given that Cassandra can tolerate thousands of
read/write rps. I thought that each read/write request has 2 parts: auth and
the actual operation. But it looks like it's not the case.
We changed the settings for our Java driver (setting
CONNECTION_POOL_LOCAL_SIZE/CONNECTION_POOL_REMOTE_SIZE to default values) -
and it's no longer reproducing.
I'll check system_auth.roles to check how many rounds I have. Thanks again!
> 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-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
