[RADIATOR] Radiator 4.9 with Postgres 8.4 on FreeBSD 8.2: Performance Analysis and Tuning

[Hugh Irvine]

Hello Traiano -

Comments below.


On 3 Jan 2012, at 22:22, Traiano Welcome wrote:

> 
> Hi List
> 
> I'm trying to determine if there might be a performance bottleneck between
> my radiator instance and the postgresql database it writes accounting
> records to.
> 

This is usually slow database performance.

> 1) How would I trace / detect a bottleneck in inserting accounting records
> from radiator into Postgresql ? I.e what tools does Radiator provide for
> me to analyse this, and are there some guides on how to use them ?
> 

Run Radiator with Trace 4 and LogMicroseconds (requires Time::HiRes from CPAN).

See sections 5.6.3 and 5.6.38 in the Radiator 4.9 reference manual ("doc/ref.pdf").

This will show you timestamps with microseconds resolution on all DEBUG lines in the log file.

You will immediately see how long each processing step is taking.

> 2) What are the configuration options, on the Radiator end of things, for
> optimising the communications between Radiator and Postgresql accounting
> DB ?
> 

There are none.

> I note that my current Radiator configuration results in only one
> connection to the backend postgresql db. Might there be some performance
> gains to be made in parallelising connections from radiator to the db? If
> so, how would I configure this in Radiator ?
> 

You would run multiple instances of Radiator - the easiest way to do this is with "FarmSize n".

See section 5.6.39 in the Radiator 4.9 reference manual ("doc/ref.pdf").

regards

Hugh


> Many thanks in Advance,
> Traiano Welcome
> 
> 
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator


--

Hugh Irvine
hugh at open.com.au

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER etc. 
Full source on Unix, Windows, MacOSX, Solaris, VMS, NetWare etc.