get statistics for sql connection pool

[Alan DeKok]

On Jun 17, 2019, at 5:39 AM, Daniel Finger <daniel.finger at ewetel.de> wrote:
> If the radius server is running for about a month, I get messages like "No connections available and at max connection limit".

  Whoops/

> Looking at the database, only very few connections are really connected (for example 2 out of 50), there are no slow queries, not much traffic (maybe one or two packets per second) and I really don't see a reason for this.
> Restarting freeRADIUS immediately fixes the problem.
> 
> I suspect I am using a module (I have 2 own modules running) which does not return a connection to the connection pool under some circumstances.

  Which version are you running?

> Is it possible to get statistics about the sql connection pool usage? This could help me size the number of connections I need and get a hint, if I am reaching the limit, before I hit it.

  There aren't stats available like that.  The connection pool code will print log messages about how many connections are free / open / used.

  Alan DeKok.