Re: freeradius mysql threads configuration questions
Re: freeradius mysql threads configuration questions 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
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
Does freeradius use multi threaded model to increase throughput to mysql ( with buffered-sql)? I'm using only for accounting purpose.
buffered-sql is used to separate authentication from accounting. It uses the same threads as the other virtual servers. Default virtual server does authentication queries at top speed while buffered-sql writes accounting queries at the pace that doesn't interfere with authentication. If you are doing *only* accounting there is not much to be gained by using buffered-sql (it makes sense to use it if your database in unstable). Ivan Kalik Kalik Informatika ISP
ramesh p wrote:
Does freeradius use multi threaded model to increase throughput to mysql ( with buffered-sql)?
No. It reads the packets from the detail file one at a time. It waits for one to finish processing before reading another. You really need to stop trying to play games with FreeRADIUS, and instead fix your DB. There is no good reason why it has horrible performance. Alan DeKok.
Hi,
You really need to stop trying to play games with FreeRADIUS, and instead fix your DB. There is no good reason why it has horrible performance.
indeed. whilst looking at a buffered-sql (detail file ingestion really) issue a coupl eof weeks back, i added some debug print commands and the insertion of records into the DB was hundreds a second. thats on a pretty basic 2.4GHz P4 system (and with printing per entry etc) alan
Hi,
Re: freeradius mysql threads configuration questions
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
read what i said - IIRC there was a logic error with load_factor in pre 2.1.7 you are running 2.1.6 so that is pre 2.1.7 and therefore affected alan
participants (4)
-
Alan Buxey -
Alan DeKok -
Ivan Kalik -
ramesh p