Search code examples
prismaplanetscale

Prisma, increase the connection limit? (Planet Scale)


  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.


Solution

  • 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.