First, optimize your database, add indexes and use storage engines which will give you the best performance... Increase interim-update interval

After that, try to add more handlers and see what will happen.

If you're using mysql, check tuning-primer.sh and mysqltuner.pl scripts.

On Thu, Feb 26, 2009 at 10:23 AM, magicboiz <magicboiz@gmail.com> wrote:
HI again Ivan

Do you know how can I modify the source code, in order to print in the error
message the exact time when the child was created/forked? If I want to find
errors in my sql backend server, I need to know the exact time when the
requests are lost...... checking the code, It looks like this error message is
printed only when the server detects threads that are
stalled.....................


Thx again.
Regards









On Miércoles 25 Febrero 2009 14:09:44 tnt@kalik.net wrote:
> >I facing this problem with my Freeradius 2.1.3, and I don't know how to
> > solve it :(
> >
> >My NAS is sending only accounting registers to my freeradius server. My
> >freeradius server, is configured to store these registers into a MySQL
> > server. I have configured "max_request_time = 120", in the case of MySQL
> > slow performance, but the problem perssits.
>
> No, you don't have a problem with radius server but with sql one.
> Perhaps you should look into the server that does have a problem (sql)
> and not the one that doesn't (radius). There is nothing radius server
> can tell you about why are sql queries running slow.
>
> Ivan Kalik
> Kalik Informatika ISP
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html