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