On Fri 18 May 2007, Arran Cudbard-Bell wrote: > Peter Nixon wrote: > > On Thu 17 May 2007, Alan DeKok wrote: > >> Angelos Karageorgiou wrote: > >>> Has anyone had the time to do a DB performance comparison for heavily > >>> loaded freeradius servers ? > >> > >> If your server is busy enough to be heavily loaded, you need multiple > >> machines to maintain quality service. Once you have multiple machines, > >> DB performance matters a lot less, because the load is spread across > >> multiple machines. > >> > >> For DB specific issues, look for DB performance on google. > >> PostgreSQL usually has better performance than MySQL. The application > >> using the DB (radius, web, etc.) has very little effect on DB > >> performance. > > > > Unless you are doing monthly or yearly summary reports which can take a > > lightly loaded DB server and peg it for minutes at a time... > > > > The lesson.. Keep a second DB for reporting :-) > > Or use clustering :p > > What kind of performance are people getting in general ? > > On our test servers we get about 460 pap req/s using LDAP + SQL + SQL > xlat for authorisation, > and around 800ish when just using LDAP.... > > Which isn't that bad really... 1 LDAP lookup 5 sql selects and 1 sql > insert per query ... > > Flat out using pap only and users file we only get 4600 req/s ... must > be something weird with the G5s .... > > Would be nice if someone altered the make file to pass the G5 > optimisation flags by default ;)
Patches are gratefully accepted :-) -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
