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@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...