Kazaz
PPrisma
•Created by daniel on 9/2/2024 in #help-and-questions
Connection Pool Timeout Issue Despite Custom Limit
@Nurul (Prisma) Let's continue the chat here instead: https://discord.com/channels/937751382725886062/1280433844314574870/1280855789703135262
@daniel please also follow the conversation there (me and Daniel know each other, so it's cool)
7 replies
PPrisma
•Created by daniel on 9/2/2024 in #help-and-questions
Connection Pool Timeout Issue Despite Custom Limit
Thanks @Nurul ! We'll give it a try and report
7 replies
PPrisma
•Created by daniel on 9/2/2024 in #help-and-questions
Connection Pool Timeout Issue Despite Custom Limit
I'm actually having the same issue!
Can someone help me understand it?
More info I can share:
1. The DB can handle the connections. I have about 200+ connections on RDS that can handle about 900 connections.
2. I have 2 vCPU on my machine, but I've set the connection pool to 70. From what I can see the default behavior is
num of cores * 2 + 1
- why is that? I saw that the query engine is not opening multiple threads, so why is there even a connection between the cores and the connections?
3. There are no long running queries. Checked that.
Could number 2 be the reason I'm seeing the timeout error? The fact the query engine can't handle so many connections in the pool for such low end machine with only 2 vCPU?7 replies