Proper way to set connection_limit in Prisma Accelerate
Hi, I use Prisma Accelerate and it seems like it has a default connection_limit of 10. I'm at the point where I need to tune some of the configurations due to my load but I don't know how to do this within Prisma Accelerate.
I am on the Pro plan already, so it looks like I'm allowed to set it up to 100.
Can I just add
?connection_limit=100 to the accelerate string? Or to the underlying connection string?
Thanks!2 Replies
You've gone full bot mode! Let me fetch that AI answer for you ASAP.
To change the connection limit in Prisma Accelerate, do not add
- Configuring the connection pool size in Accelerate - Setting the connection limit in Prisma Accelerate Summary:
Set the connection limit for Prisma Accelerate via the Prisma Data Platform UI, not via connection string parameters. 🤔 Alright, thanks for letting us know that there's still some help needed. A team member will reply to you shortly. In the meantime, please let us know any additional info, questions, or which parts of the answer may need clarification.
?connection_limit=100 to your database connection string or the Accelerate connection string. Instead, you must configure the connection limit directly in the Prisma Data Platform UI:
1. Go to your project in the Prisma Data Platform.
2. Find the Accelerate-enabled environment.
3. In the "Connection Pool" section, set the "Connection limit" to your desired value (up to 100 for the Pro plan).
This is the only supported way to change the connection limit for Accelerate. The connection_limit parameter in the connection string is ignored by Accelerate; it only applies to the internal Prisma ORM connection pool when not using Accelerate. For Accelerate, the platform UI setting is authoritative and required for tuning connection pool size.
For more details, see the official docs:- Configuring the connection pool size in Accelerate - Setting the connection limit in Prisma Accelerate Summary:
Set the connection limit for Prisma Accelerate via the Prisma Data Platform UI, not via connection string parameters. 🤔 Alright, thanks for letting us know that there's still some help needed. A team member will reply to you shortly. In the meantime, please let us know any additional info, questions, or which parts of the answer may need clarification.
There is no "Connection Pool" section that I can find within the Accelerate product - maybe I'm just blind but it's not in any of the settings screens whatsoever
AH I FOUND IT. Take this as feedback that having multiple different "Settings" tabs buried around the Data Platform is crazy confusing and it took me legit 20+ minutes to find this setting, even with docs telling me if should be there. I was blind to the small "Settings" tab next to the default selected "Insights" tab under the Accelerate screen, and was incorrectly assuming that the settings on the left pane should have contained what I was looking for