Pool idle of Ecto adaptator over 400 connections

Hello there! I come here with some question about connection pool.
Today our Phoenix WebAPI connection pool get over 400 connections (more IDLE status connection). This problem crush our system and other services.
My doubts are:

  • If a connection from the pool get error connection and fail, this connection will freeze and then, a new connection will generated, but the freeze connection will stay “idle” without close it (even with pool timeout), this correct or not?
  • Only by config database server, could make a limit of connection (or precisely)? Or is some way to control and clear those idle connections? Setting max limit connection or some plugin?

:wave:

What adapter are you using?

Today our Phoenix WebAPI connection pool get over 400 connections

Do I understand correctly that you mean an ecto connection pool here, and not a connection pool of your web server or something?

1 Like