db performance

[Peter Nixon]

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