db performance

[Arran Cudbard-Bell]

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 ;)