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@open.com.au
> http://www.open.com.au/mailman/listinfo/radiator
--
Hugh Irvine
h...@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.
_______________________________________________
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
