Kazaz
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