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@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