Radius Perfomance Issure
hi,i am testing performance of my Freeradius using java multi threading and i am facing an issue normaaly acounting start procedure taking less then 1000 miliseconds. and this is my requirment but after some requests free radius takes more then 5000 miliseconds continusly then returns normally... return code in all requests is 0 Accounting Start process times of some requests...Process time IS = 87 Process time IS = 62 Process time IS = 92 Process time IS = 90 Process time IS = 98 Process time IS = 19 Process time IS = 107 Process time IS = 114 Process time IS = 120 Process time IS = 120 Process time IS = 123 Process time IS = 121 Process time IS = 127 Process time IS = 130 Process time IS = 128 Process time IS = 152 Process time IS = 133 Process time IS = 138 Process time IS = 138 Process time IS = 137 Process time IS = 143 Process time IS = 146 Process time IS = 147 Process time IS = 5155 Process time IS = 5156 Process time IS = 5167 Process time IS = 5167 Process time IS = 5176 Process time IS = 5194 Process time IS = 5201 Process time IS = 5207 Process time IS = 5214 Process time IS = 5211 Process time IS = 5213 Process time IS = 5224 Process time IS = 5263 Process time IS = 5233 Process time IS = 5274 Process time IS = 5159 Process time IS = 5015 Process time IS = 5022 Process time IS = 5022 Process time IS = 5025 Process time IS = 5030 Process time IS = 5035 Process time IS = 5041 Process time IS = 5042 Process time IS = 5049 Process time IS = 5050 Process time IS = 5051 Process time IS = 5059 Process time IS = 5060 Process time IS = 5069 Process time IS = 5070 Process time IS = 5079 Process time IS = 5087 Process time IS = 4973 Process time IS = 4878 Process time IS = 4876 Process time IS = 4883 Process time IS = 5086 Process time IS = 4885 Process time IS = 4886 Process time IS = 4890 Process time IS = 4869 Process time IS = 4847 Process time IS = 4848 Process time IS = 4790 Process time IS = 4858 Process time IS = 4802 Process time IS = 4794 Process time IS = 4800 Process time IS = 4642 Process time IS = 4657 Process time IS = 4659 Process time IS = 4661 Process time IS = 4661 Process time IS = 4663 Process time IS = 5508 Process time IS = 5221 Process time IS = 5228 Process time IS = 4978 Process time IS = 4980 Process time IS = 4867 Process time IS = 4766 Process time IS = 6 Process time IS = 6 Process time IS = 9 Process time IS = 10 Process time IS = 16 Process time IS = 7 Process time IS = 16 Process time IS = 10 Process time IS = 11 Process time IS = 25 Process time IS = 49 Process time IS = 49 Process time IS = 48 Process time IS = 45 Process time IS = 46 Process time IS = 47 Process time IS = 56 Process time IS = 52 please help me in this what is wrong in this why it take so long time
On Wed, Oct 17, 2012 at 12:07 PM, QASIM RAO <qasim2490@hotmail.com> wrote:
hi, i am testing performance of my Freeradius using java multi threading and i am facing an issue
normaaly acounting start procedure taking less then 1000 miliseconds. and this is my requirment
but after some requests free radius takes more then 5000 miliseconds continusly then returns normally...
please help me in this what is wrong in this why it take so long time
What backend did you use for accounting? If files, then there's no reason for it to be that slow. If you store accounting data on db, then fix your db, cause that's where the bottleneck is. -- Fajar
: Info: Request Start time is 4440538 User-Name = 12345678 Movie-ID = 5 Group-ID = 0 ACCT TYPE = 1 CALL Proc_Ngi_Acc_Start_IPTV( '12345678', '5','0','1','1','ngi', @ret ); select @ret Return Code = 1 REQUEST END TIME IS 4440685 Process time IS = 147 Acct_Nulti Session ID = ngiTue Oct 16 01:14:05 2012: Info: Request Start time is 4440538 User-Name = 12345678 Movie-ID = 5 Group-ID = 0 ACCT TYPE = 1 CALL Proc_Ngi_Acc_Stop_IPTV( '12345678', '5','0','1', @ret ); select @ret Return Code = 0 REQUEST END TIME IS 4445686 Difference of time IS 5148Tue Oct 16 01:14:05 2012: Info: Request Start time is 4440541 User-Name = 12345678 Movie-ID = 5 Group-ID = 0 ACCT TYPE = 1 CALL Proc_Ngi_Acc_Start_IPTV( '12345678', '5','0','1','1','ngi', @ret ); select @ret Return Code = 1 REQUEST END TIME IS 4445696 Process time IS = 5155 Acct_Nulti Session ID = ngiTue Oct 16 01:14:05 2012 i am sending values procedures "CALL Proc_Ngi_Acc_Start_IPTV" and "CALL Proc_Ngi_Acc_Stop_IPTV" and this is procedues return time... but if this is db issue thn why other queries taking arround 100 miliseconds...
Date: Wed, 17 Oct 2012 12:19:34 +0700 Subject: Re: Radius Perfomance Issure From: list@fajar.net To: freeradius-users@lists.freeradius.org
On Wed, Oct 17, 2012 at 12:07 PM, QASIM RAO <qasim2490@hotmail.com> wrote:
hi, i am testing performance of my Freeradius using java multi threading and i am facing an issue
normaaly acounting start procedure taking less then 1000 miliseconds. and this is my requirment
but after some requests free radius takes more then 5000 miliseconds continusly then returns normally...
please help me in this what is wrong in this why it take so long time
What backend did you use for accounting?
If files, then there's no reason for it to be that slow.
If you store accounting data on db, then fix your db, cause that's where the bottleneck is.
-- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Wed, Oct 17, 2012 at 12:53 PM, QASIM RAO <qasim2490@hotmail.com> wrote:
i am sending values procedures "CALL Proc_Ngi_Acc_Start_IPTV" and "CALL Proc_Ngi_Acc_Stop_IPTV" and this is procedues return time... but if this is db issue thn why other queries taking arround 100 miliseconds...
Hire a dba. Seriously. I can think of several good reasons why your stored procedure is slow, but none of them is useful for you if you DON'T have a qualified DBA. -- Fajar
participants (2)
-
Fajar A. Nugraha -
QASIM RAO