MySQL connection setup

[Marinko Tarlac]

According to experiences on this list, 15-20 will be good.

Also, no matter how many sql_socks do you set, it won't work if 
something blocks your database.

Check your mysql on daily basis with tunning_primer and mysqltuner. 
Those two scripts will help you a lot to find a potential problems.

On 12/12/2010 4:33 PM, Alan DeKok wrote:
> Robin wrote:
>> There is a configuration in SQL.conf.
>>
>> Num_sql_socks=
>>
>> I would like to know if this value is set to smaller, fx. 20, can it
>> cause breaking stream or disconnecting for DSL users?
>    No.  There is *nothing* you can do to the RADIUS server to cause DSL
> users to disconnect mid-session.
>
>> If I set it to
>> larger, can it cause MySQL problem of “Too many connection”.
>    Yes.
>
>    Alan DeKok.
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html