Freeradius 3.0 - SQL - spare connections?

[Andre Schwarzer]

Hello There,

as is the flow then exactly.

a) When you start the server it will automatically open the "Start"
respectively "min" connections. If the min connections to a particular
set of% are full, he opens the spare connections for the next
requests.

Correctly or when he opens his spare connections?


b) Can run multiple requests over a Connection?
or
c) Or he takes per client request a Connection, block the connections
and when the request is complete, the next client can use the
Connection?

d) The spare connections have a higher idle timer? I have set for idle
60 seconds in config but see the log in part Close Connection after
respectively 230 seconds?

Regardes

Andre


2015-07-15 14:41 GMT+02:00 Arran Cudbard-Bell <a.cudbardb at freeradius.org>:
>
>> On 15 Jul 2015, at 08:15, Andre Schwarzer <andreschwarzer at gmail.com> wrote:
>>
>> Hello,
>>
>> have installed a new freeradius 3.0, bevor i worked with the Version 1.
>>
>> I see in my Test´s, in the radius.log the Messages below. I don´t know
>> what are spare Connections, what they do and for what the radius use
>> this.
>> Additional i don´t know why i get this messeges with the Default
>> Settings.
>>
>> Can some one explain me the usage of the spare Connections, best by an example.
>>
>> Wed Jul 15 13:34:25 2015 : Info: rlm_sql (sql): 0 of 5 connections in
>> use.  Need more spares
>> Wed Jul 15 13:34:25 2015 : Info: rlm_sql (sql): Opening additional
>> connection (12)
>
> The connection pool will attempt to find the minimum number of connections required to service the current load.
>
> It will also open a number of spare connections to absorb any sudden increases in that load.
>
> Without spare connections the server would have to open new connections when dealing with the load spike.  This could potentially cause a number of worker threads to block, and would affect the servers ability to 'ramp up' to deal with the new load level.
>
> -Arran
>
> Arran Cudbard-Bell <a.cudbardb at freeradius.org>
> FreeRADIUS development team
>
> FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html