On Fri, 19 Dec 2003, Kostas Kalevras wrote:

> See doc/tuning_guide

Thanks! I did check that out, but all it said was to make num_sql_socks
larger than the number of simultaneous requests. (Hehe! Of course!) I'm
still using 0.8.1, though: is tuning_guide updated in the latest?

> In any case it depends on how fast your sql server responds to queries.
> One way is to do a 'SHOW PROCESSLIST;' in mysql during radius peek time
> If you see active threads put in a few sql connections more than the
> maximum number of active threads. 

So, if I understand you correctly, if during peak times only 5 connections 
are active, and the rest are sleeping, then I could get away with 10 
connections? If so, then that makes a lot of sense. Most of my connections 
are sleeping at any given time.

> A more scientific solution is to increase the connection pool if you get
> 'out of sql sockets' errors radius.log :-)

Haha! The people answering the tech support calls will not like that 
option, I think. :-)

Kristina


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to