<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.26.3">
</HEAD>
<BODY>
I forgot to include infos in previous mail... sorry about that<BR>
<BR>
Le lundi 14 septembre 2009 à 22:32 +0200, Alan DeKok a écrit :
<BLOCKQUOTE TYPE=CITE>
<PRE>
Alexandre Chapellon wrote:
> Is there a way to know how many sql sockets needs to be open at startup
> for a particular accounting db?
How long do database writes take?
</PRE>
</BLOCKQUOTE>
insert in acccouting db takes ~ 10ms<BR>
delete from accouting db takes ~ 25ms<BR>
<BR>
<BLOCKQUOTE TYPE=CITE>
<PRE>
How many writes can you do
simultaneously?
</PRE>
</BLOCKQUOTE>
<BR>
As many as simultaneous query I guess...
<BLOCKQUOTE TYPE=CITE>
<PRE>
How many packets/s does the server get?
</PRE>
</BLOCKQUOTE>
<BR>
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).
<BLOCKQUOTE TYPE=CITE>
<PRE>
Generally, you should have as many SQL sockets as threads.
</PRE>
</BLOCKQUOTE>
Thread like in start_servers and max_servers in radiusd.conf?
<BLOCKQUOTE TYPE=CITE>
<PRE>
Any more,
and they won't be used. Any less, and the threads might starve.
> I want to have sufficent number of such sockets but don't want to loose
> time and ressources opening too much of them.
The LDAP && SQL modules really need to move to a dynamic connection
pool. It would be much easier for the administrators.
</PRE>
</BLOCKQUOTE>
<BR>
Indeed
<BLOCKQUOTE TYPE=CITE>
<PRE>
Alan DeKok.
-
List info/subscribe/unsubscribe? See <A HREF="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</A>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>