On Thu, 18 Dec 2003, Kristina Pfaff-Harris wrote: > > Heya, all. This might be a silly question, but can anyone tell me a rule > of thumb to figure out how many MySQL connections (num_sql_socks in the > config) to configure based on ... heck, I don't know ... something like > number of people dialed up at the same time? It's a bit difficult to say > how many users I have simultaneously using FR, since the logs/debug stuff > is sequential. > > Currently using 24 connections for auth and 24 for accounting. I'm > wondering if I really need that many or if I should add more. > > Any ideas? What I've got seems to work: I'm just trying to be a little > more scientific about it. Pointers to docs appreciated if this is in the > docs and I missed it!
See doc/tuning_guide 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. A more scientific solution is to increase the connection pool if you get 'out of sql sockets' errors radius.log :-) > > Thanks! > > Kristina > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
