freeradius mysql threads configuration questions

[ramesh p]

I have asked this questions several times but i didn't get definite answer.
Forgive me for posting again.


Does freeradius use multi threaded model to increase throughput to mysql (
with buffered-sql)?
I'm using only for accounting purpose.

[my configurations are 2.1.6, MYSQL+INNODB.]

Without buffered-sql FR using 5 DB handles(sockets) at time. Incase of
buffered-sql why it's not.

---
Rams.
On Fri, Sep 11, 2009 at 12:04 PM, ramesh p <rock786143 at gmail.com> wrote:

>
>
> Does this change is for 2.1.6 version also. I'm using 2.1.6.
>
> Hi,
> > We migrated to INNODB.
> > But still the no of packets inserted in db are like 20 per min using
> > buffered-sql in my test system.
> > buffered-sql configuration:
> > server buffered-sql {
> >         listen {
> >                 type = detail
> >                 load_factor = 100
>
> IIRC there was a logic error with load_factor in pre 2.1.7 versions
> just change that to 1 or 10 and it shoukd tick along a little better
>
> alan
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090911/8b1631b4/attachment.html>