Thanks Alan, I'm using postgresql Le lundi 14 septembre 2009 à 23:15 +0100, Alan Buxey a écrit :
> 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 http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
