Prisma, increase the connection limit? (Planet Scale)

Question

  Timed out fetching a new connection from the connection pool. More info: http://pris.ly/d/connection-pool (Current connection pool timeout: 10, connection limit: 17)

I query the database through prisma and suddenly that error appears. How should I handle it?

On the planet scale, it is stated that up to 250,000 connections are possible.

Answer 1

To specify the connection limit, you would need to set the connection_limit connection string parameter: Reference.

For example you can set your connection string like this:

mysql://tpuf2:*****@ap-south.connect.psdb.cloud/db?sslaccept=strict&connection_limit=100

In this case Prisma could have maximum 100 connections with the database.