correctly set num_sql_sock in sql accoutnig (Erratum)

[Alexandre Chapellon]

Le mardi 15 septembre 2009 à 00:13 +0200, Alan DeKok a écrit :

> Alexandre Chapellon wrote:
> >>   How long do database writes take?
> > insert in acccouting db takes ~ 10ms
> > delete from accouting db takes ~ 25ms
> 
>   So it can handle roughly 40-100 packets per second, depending on the
> traffic.


with a single freeradius process isn't it?
I just notice something strange... I have start_servers set to 5  but
when starting freeradius ps only report one freeradius proccess... is it
something normal?

regards

> 
> > For the authtentication database I have about 10 authentication
> > queries/s but regularly reaches 30/s when problems on BAS or DSLAM
> > outcome (max value since last year is ~80/s).
> 
>   I'd say you're running pretty close to the border of what is stable.
> You're OK for normal traffic, but large spikes might cause problems
> (delays in writes, etc.)
> 
>   If you're planning on growing the number of users you have, I'd take a
> look at upgrading the DB.
> 
> >>   Generally, you should have as many SQL sockets as threads.
> > Thread like in start_servers and max_servers in radiusd.conf?
> 
>   Yes.
> 
>   Alan DeKok.
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090914/37984993/attachment.html>