db performance

[Angelos Karageorgiou]

Alan is right ,
    under www.unix.gr you can find some stats phps I wrote for FR+mysql ,
small reports are fine indeed, large multi table selects with mYIsam 
tables lock the tables
and freeradius starts timing requests out.

The reports are nice though :-)

You see , I know FR,mysql,posgres,postfix and all the OSS incantations I 
need a power point presentation
of all this knowledge, and no Peter I cannot hire you.

O/H Peter Nixon έγραψε:
> On Thu 17 May 2007, A.L.M.Buxey at lboro.ac.uk wrote:
>   
>> Hi,
>>
>>     
>>> 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 a DB that can handle non-blocking selects? <ducks> ;-)
>>     
>
> I use PostgreSQL... I didnt say that it stops the DB or queries.. Just that 
> it "works" it in a way the FreeRADIUS will not. If the report is big enough 
> and you have a heavy enough RADIUS load, it _can_ be enough load to push 
> your box over the limit and start timing out requests...
>
>