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 ;) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
