Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to set pool size #1679

Open
mojixcoder opened this issue Feb 24, 2023 · 5 comments · May be fixed by #1747
Open

How to set pool size #1679

mojixcoder opened this issue Feb 24, 2023 · 5 comments · May be fixed by #1747

Comments

@mojixcoder
Copy link

mojixcoder commented Feb 24, 2023

Hey,
I wanted to know how can we explicitly set max pool size in gocql?

I mean changing the number of queries which will be run simultaneously.

We are having 150ms avg response time in our monitoring in client side, but we are seeing 24ms avg read latency in Cassansra exporter. Can it be related to pool size?

EDIT: I think that's the function in Java driver: poolingOptions.setMaxRequestsPerConnection(num). What is the equivalent function in gocql?

@cptdom
Copy link

cptdom commented Feb 27, 2023

Hey, maybe not related, but when we were migrating to cassandra and tinkering with the gocql client, we saw similar latency difference due to the client not properly discovering all nodes and using the same node as the coordinator node for all the requests, resulting in the requests getting queued on a single node and thus slowing down on the client side. Internally, everything seemed fine.
Note: it was on k8s

@martin-sucha
Copy link
Contributor

Hi!

Just recently scylladb#113 was merged to the ScyllaDB fork. It is not available in gocql/gocql yet.

scylladb#114 is also related.

@mojixcoder
Copy link
Author

Hey, maybe not related, but when we were migrating to cassandra and tinkering with the gocql client, we saw similar latency difference due to the client not properly discovering all nodes and using the same node as the coordinator node for all the requests, resulting in the requests getting queued on a single node and thus slowing down on the client side. Internally, everything seemed fine. Note: it was on k8s

How did u understand such problem?

@cptdom
Copy link

cptdom commented Feb 27, 2023

Hey, maybe not related, but when we were migrating to cassandra and tinkering with the gocql client, we saw similar latency difference due to the client not properly discovering all nodes and using the same node as the coordinator node for all the requests, resulting in the requests getting queued on a single node and thus slowing down on the client side. Internally, everything seemed fine. Note: it was on k8s

How did u understand such problem?

We had metrics which allowed us to see which nodes act as coordinators. Also we had query tracing set on gocql which confirmed it.

@mojixcoder
Copy link
Author

Hi!

Just recently scylladb#113 was merged to the ScyllaDB fork. It is not available in gocql/gocql yet.

scylladb#114 is also related.

Do you have any idea when is it going to be available in gocql?

@testisnullus testisnullus linked a pull request May 2, 2024 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants