(RADIATOR) Question about Radiator/ORACLE performance

[Ricardo Martinez]

Hello List.
I have a Radiator configured exclusively for accounting. All received requests are sent to a database using <AuthBy SQL>.  Communication with the DB and inserts work great but once in a while, when DB is busy, the response to a given insert could take a longer than usual. Please check the debug:

Tue Jun  3 16:53:34 2008: DEBUG: Handling request with Handler 'Request-Type = Accounting-Request, Acct-Status-Type = Stop'
Tue Jun  3 16:53:34 2008: DEBUG: Deleting session for 1234567890, 10.10.10.10, 
Tue Jun  3 16:53:34 2008: DEBUG: Handling with Radius::AuthSQL
Tue Jun  3 16:53:34 2008: DEBUG: Handling accounting with Radius::AuthSQL
Tue Jun  3 16:53:34 2008: DEBUG: do query is: 'insert into VOIPACCOUNTING2 (ACCESS_DEVICE,ACCT_DELAY_TIME,ACCT_INPUT_OCTETS,
ACCT_INPUT_PACKETS,ACCT_OUTPUT_OCTETS,ACCT_OUTPUT_PACKETS,ACCT_SESSION_ID,ACCT_SESSION_TIME,ACCT_STATUS_TYPE,CALLED_STATION_
ID,CALLING_STATION_ID,CALL_LEG_CONNECT_TIME,CALL_LEG_DIRECTION,CALL_LEG_DISCONNECT_CAUSE,CALL_LEG_DISCONNECT_TIME,CALL_LEG_S
ETUP_TIME,CALL_LEG_TYPE,CONNECTION_ID,GATEWAY_IDENTIFIER,LOGGEDAT,NAS_PORT_TYPE,USER_NAME,VOICE_QUALITY) values ('GW_02
','5','3408','142','0','0','0000112B','0',2,'0015552002020','1234567890','16:53:22.000 UTC Tue Jun 03 2008','originate','10','16:
53:22.000 UTC Tue Jun 03 2008','16:53:17.000 UTC Tue Jun 03 2008','Telephony','54754548 9D275A06 810A0002 A40230EE','GW_02',sysdate,0,'1234567890','0')': 
Tue Jun  3 16:53:40 2008: DEBUG: AuthBy SQL result: ACCEPT, 
Tue Jun  3 16:53:40 2008: DEBUG: Accounting accepted 

Please note that in this case the response from DB arrive 6 seconds after the request was sent. The normal behaveor is that our DB respond a few milisecond later but in this case it was busy for a specific reason. This Radiator have a Accounting-Request rate of about 8 request per second so I would like to know what Radiator do with those incoming request while it waits for the DB answer. In this case Radiator should have receive about 48 request while it waits for the answer, are they buffered? or are they discarded?. If Radiator have a buffer, how are the queued requests insert?, can I define the size of that buffer?. I hope you can help to answer these questions, We have detected that when this delayed answer appears some request sent by the NAS are not logged in Radiator or inserted in DB.

Best Regards.
Ricardo Martinez.-
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20080606/bbb120e4/attachment.html>