Shrinjay
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
Ok - thank you - please keep me posted
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
but it seems to holding at 4 which is good, previously it would rapidly climb to 20 and then 30 and then 80
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
the behvaiour was that I would restart the db but then the number of connections would start climbing
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
it was not coming down otherwise
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
that's because I restarted our db
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
its holding at 4 connections now
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
observing for the same behaviour again
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
I deployed the change
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
why is accelerate not abiding by the connection limit we set for it. Is this something we need to do every time I change pool settings?
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
ok - I don't think that sounds like a long term fix though
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
right, so the 10 query engines being opened is being opened by prisma due to load, not by my source code?
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
so is the connection limit I set in accelerate on a per-query-engine basis? if I have a connection limit of 20, will prisma spawn 10 query engines depending on load, and then open 200 connections? Or do you just open 1 query engine per 10-connection increment, so if I specify 20 connections, I get 2 query engines opened by accelerate?
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
I'm currently up to 126 connections from prisma accelerate
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
Interesting - so even if I have one prisma client instance, it could instantiate multiple prisma query engines in accelerate?
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
Right, so when does a new one get instantiated?
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
We have two heroku processes, each of which is declaring prismaClient once
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
how would we have 10 query engines?
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
and its still climbing, up to 80 now
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
In case it helps, here's the pg_stat_activity output
37 replies
PPrisma
•Created by Shrinjay on 1/30/2025 in #help-and-questions
Prisma Accelerate using >100 connections when configured to use 10
sorry forgot to use reply - yes this absolutely is
37 replies