Re: Slow DB / outstanding requests

2011-09-16 Thread Johan Meiring
On 2011/09/15 06:35 PM, Alan Buxey wrote: Just a quick question, how many DB connections do you have in your config? 5 Server was a VM with too little RAM. And therefore a simple SQL query could take seconds instead of milliseconds. (Suspect swap meltdown if such a thing exists) Had to

Re: Slow DB / outstanding requests

2011-09-16 Thread Alan DeKok
Johan Meiring wrote: It was just the first time that I didn't see FR recover after the DB eventually finished with slow queries. I made a minor change for 2.1.12 which will clear out the pending queue a lot more quickly. old: for each new request clear out one dead

Re: Slow DB / outstanding requests

2011-09-16 Thread Fajar A. Nugraha
On Fri, Sep 16, 2011 at 1:22 PM, Alan DeKok al...@deployingradius.com wrote: old:        for each new request                clear out one dead request from queue  If the dead requests originally arrived at a higher rate than the new requests, it can take a long time to clean them out.

Re: Slow DB / outstanding requests

2011-09-16 Thread Marinko Tarlać
Alan please do not forget to add this fix to changelog so it will be easier for a new FR users... Best regards On 9/16/2011 8:45 AM, Fajar A. Nugraha wrote: On Fri, Sep 16, 2011 at 1:22 PM, Alan DeKokal...@deployingradius.com wrote: old: for each new request clear

Re: Slow DB / outstanding requests

2011-09-16 Thread Alan DeKok
Marinko Tarlać wrote: Alan please do not forget to add this fix to changelog so it will be easier for a new FR users... to do...? It doesn't require anyone to do anything. There are no configuration changes. It's just code internal to the server. Alan DeKok. - List

Re: Slow DB / outstanding requests

2011-09-16 Thread Marinko Tarlać
Of course we don't need to do anything but if this small change inside code is announced in changelog, more people will upgrade to 2.1.12 and they will stop bothering us on this list with the same questions, over and over again :) On 9/16/2011 9:59 AM, Alan DeKok wrote: Marinko Tarlać

Re: Slow DB / outstanding requests

2011-09-16 Thread Alan DeKok
Marinko Tarlać wrote: Of course we don't need to do anything but if this small change inside code is announced in changelog, more people will upgrade to 2.1.12 and they will stop bothering us on this list with the same questions, over and over again :) Good point. Alan DeKok. - List

Slow DB / outstanding requests

2011-09-15 Thread Johan Meiring
Hi, Seeing as the list is quiet, something that might be of interest. I am running 2.1.12 on a production server. The server is (was) severly underpowered and the database was straining. I was expenting the normal - rejecting duplicate request. (Cant remember exact error). Then the server

RE: Slow DB / outstanding requests

2011-09-15 Thread David Peterson
To: FreeRadius users mailing list Subject: Slow DB / outstanding requests Hi, Seeing as the list is quiet, something that might be of interest. I am running 2.1.12 on a production server. The server is (was) severly underpowered and the database was straining. I was expenting the normal - rejecting

Re: Slow DB / outstanding requests

2011-09-15 Thread Alan DeKok
Johan Meiring wrote: I am running 2.1.12 on a production server. The server is (was) severly underpowered and the database was straining. Don't do that I was expenting the normal - rejecting duplicate request. (Cant remember exact error). Pretty much, yes. Then the server

Re: Slow DB / outstanding requests

2011-09-15 Thread Alan Buxey
Just a quick question, how many DB connections do you have in your config? alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html