<div>I have asked this questions several times but i didn't get definite answer. Forgive me for posting again.</div>
<div> </div>
<div> </div>
<div>Does freeradius use multi threaded model to increase throughput to mysql ( with buffered-sql)?<br>I'm using only for accounting purpose.</div>
<div> </div>
<div>[my configurations are 2.1.6, MYSQL+INNODB.]</div>
<div> </div>
<div>Without buffered-sql FR using 5 DB handles(sockets) at time. Incase of buffered-sql why it's not.</div>
<div> </div>
<div>---</div>
<div>Rams.<br></div>
<div class="gmail_quote">On Fri, Sep 11, 2009 at 12:04 PM, ramesh p <span dir="ltr"><<a href="mailto:rock786143@gmail.com">rock786143@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<h1><span></span> </h1>
<p><span>Does this change is for 2.1.6 version also. I'm using 2.1.6.</span></p></div>
<div><pre>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
</pre></div></blockquote></div><br>