On Fri, 25 Oct 2002, Karl Pielorz wrote: > > Hi All, > > I'm running FreeRADIUS 0.7.1 under FreeBSD 4.6. I'm also using MySQL as a > source for the radius details. > > Recently, the server has kept dieing at random points in the day - which we > tracked down to it running out of mysql socket connections. > > So, we doubled the number of connections it could have (from admitadly the > default 10 to 20). It still ran out, so we doubled it again to 40, it still > ran out - so, we've now set it to 100. > > Does anyone have any recomendations for a value for this? [I can hear the > cries of 'how busy is the server?' :)] - the server handles about 20-30 > thousand auth requests a day, according to some quick checks, it's peak > 'rate' seem to be about 5 requests a second. > > radiusd.conf now sets max_requests to 1024, max_servers = 32, > min_spare_servers = 3 and max_spare_servers = 10. > > With that in mind, a limit of 100 connections seems to be a little high? - > I'm just checking 100 isn't an outrageous number for max_servers of 32, and > with the loading on the system.
Having more sql connections than threads will not gain you much, each thread will use just one sql connection at a time. There is a bug which has been fixed in the current cvs which most probably is the reason of your server crashes. So try upgrading to the latest cvs. > > -Karl Pielorz > > - > 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
