<!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>
Thanks Alan, I'm using postgresql<BR>
<BR>
Le lundi 14 septembre 2009 à 23:15 +0100, Alan Buxey a écrit :
<BLOCKQUOTE TYPE=CITE>
<PRE>
Hi,
> > How long do database writes take?
>
> insert in acccouting db takes ~ 10ms
> delete from accouting db takes ~ 25ms
>
> 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).
from those details it looks like you could handle 100 inserts
per seond with a single process and 40 deletes per second.
worse case you came up with was 80/s - which is fine for inserts
but tricky for deletes - so you'd need just 2 sockets on a rainy day.
- but then you've got things like table locking if using MySQL
with eg myISAM engine so you'd have to probably double that to deal
with the slower queries - make it 4 sockets.
I've only made FreeRADIUS cry with mySQL when hitting it with
really big slow queries at which point it choked all its handles
and started to get really angry but a couple of optimisations later
with some indexes and a change of DB engine (InnoDB) and things
were fine - to ensure future happiness a migration to postgres
was undertaken (pretty painless on the FR side of things...updating
other code was more ...interesting... lets say) and we then moved
to buffered_sql for the heavy stuff - that thread chugs along in
the background inserting/updating table values when it needs to.
FreeRADIUS and accouting DB took up too much time a while back..
a distraction that I could have done without but since the move to a
better DB (I know..i'm stirring now..) and moving to 'out of band'
DB updates its 'just done its job(tm)'
PS there is an upcoming webcast about FreeRADIUS and mysql clusters
- if you are into MySQL and performance/reliability I'd wholely
recommend getting onto that.
alan
-
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>