On Tue, 15 Jun 2004, Matthew Schumacher wrote:
> Alan DeKok wrote:
> > "Gary McKinney" <[EMAIL PROTECTED]> wrote:
> >
> >>From following this thread I am wondering how many transactions a
> >>second can a DB handle successfully perform before the system starts
> >>to lose information???
> >
> >
> > That depends on the DB. Oracle is fast, PostGreSQL is fast, MySQL
> > is less fast.
> >
> >
> >>I am wondering for a given platform and OS (such as linux or FreeBSD
> >>running on a 2.0Ghz based system with 1-Gig of RAM and fast SCSI
> >>hard-drive subsystem) how many transactions can the FreeRadius
> >>system handle in a second???
> >
> >
>
> I use postgres and have done a bit of tuning so it's as fast as it's
> going to be on this hardware, but even with very fast servers there is
> only so much inserts you can do at a time before you run out of DB
> connection handles and this is almost always going to happen long before
> radius reaches it's processing limits, especially when you have several
> million rows like I do.
>
> I think the most graceful way to handle this would be to add a function
> to rlm_sql that writes the accounting packet to a detail log then call
> that before returning RLM_MODULE_FAIL. The name of the file could be
> defined in the sql {} part of the config file. This way any sql based
> failures will at least be written somewhere instead of lost forever.
> This detail file could be fed back to the server at some other point in
> time.
You don't need to do code changes. Just use configurable failover with the sql
and detail modules.
>
> I'm a very poor C programmer so before I start looking into this further
> perhaps Alan and comment on any problems he sees with this and describe
> any problems I may run into with calling rlm_detail from rlm_sql.
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED] National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
