(RADIATOR) Easy measurement of SQL performance with Radiator

[Mike McCauley]

Hello Andy,


On Tuesday 07 December 2004 20:49, Andy M wrote:
> Hi,
>
> This sounds very interesting - would you have any ideas on how this might
> be configured to be used in an operational environment, e.g. logged on a 1
> minute basis to a dedicated logfile without the need for terminating the
> main radiusd process?

I havent tried this, but the only thing I can think of would be to HUP 
radiusd.

Cheers.

>
> Rgds,
>
> Andy
>
>
>
> -----Original Message-----
> From: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] On
> Behalf Of Mike McCauley
> Sent: 06 December 2004 22:43
> To: radiator at open.com.au
> Subject: (RADIATOR) Easy measurement of SQL performance with Radiator
>
> Hi all,
>
> We have added some documentation about an easy way to make SQL performance
> measurements on your running Radiator, which will be available in
> goodies/dbiprofile.txt in the patches and next release.
>
> I have also attached it here:
>
> The Perl DBI module includes built-in performance measurement. You can
> set certain environment variables and run your program. When the
> program exits, it will print out details about the time each of your
> SQL queries took to run.
>
> For example, on Unix, you can enable data to be grouped by SQL
> statement with a command like:
>
> DBI_PROFILE=2 ./radiusd -config goodies/radmin.cfg
> ...... program runs
> terminate the program with SIG term (use something like
> kill -TERM nnnn
> where nnnn is the Radiator process ID), and the performance data
> will be printed on STDOUT, something like this:
>
>
> DBI::Profile: 14.151900 seconds 23.90% (8466 method calls) radiusd
> '' =>
>     12.222472s / 6726 = 0.001817s avg (first 0.000012s, min 0.000008s, max
> 0.121580s)
> 'select ATTR_ID, VENDOR_ID, IVALUE, SVALUE, ITEM_TYPE from RADCONFIG where
> NAME='mikem' order by ITEM_TYPE' =>
>     0.681599s / 612 = 0.001114s avg (first 0.000171s, min 0.000005s, max
> 0.031941s)
> 'select NASIDENTIFIER, NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from
> RADONLINE
> where USERNAME='mikem'' =>
>     0.634436s / 510 = 0.001244s avg (first 0.000329s, min 0.000005s, max
> 0.030651s)
> 'select PASS_WORD, STATICADDRESS, TIMELEFT, MAXLOGINS, SERVICENAME,
> BADLOGINS,
> VALIDFROM, VALIDTO from RADUSERS where USERNAME='mikem'' =>
>     0.612525s / 612 = 0.001001s avg (first 0.000175s, min 0.000005s, max
> 0.056257s)
>
>
> Other values of DBI_PROFILE are possible. More details with
> man DBI::Profile

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
9 Bulbul Place Currumbin Waters QLD 4223 Australia   http://www.open.com.au
Phone +61 7 5598-7474                       Fax   +61 7 5598-7070

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 etc on Unix, Windows, MacOS etc.

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.