get statistics for sql connection pool
Hi! If the radius server is running for about a month, I get messages like "No connections available and at max connection limit". 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. 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. Greetings, Daniel Finger
On Jun 17, 2019, at 5:39 AM, Daniel Finger <daniel.finger@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.
Am 17.06.2019 um 21:37 schrieb Alan DeKok:
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?
I am running version 3.0.19
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.
Now that you are saying it: I'm not having those messages in my log. I can see them them, when running with -X in debug mode, but not in my regular logfile: rlm_sql (sql_os): Opening additional connection (0), 1 of 90 pending slots used I will double check that I did not break the source code. There should not be any changes except my own modules, but I will check and look into it. Greetings, Daniel
participants (2)
-
Alan DeKok -
Daniel Finger