MySQL connection setup

Hi Friends, 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? If I set it to larger, can it cause MySQL problem of “Too many connection”. I can’t find

Re: MySQL connection setup

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

Re: MySQL connection setup

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.