Re: freeradius mysql threads configuration questions
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 poll_interval = 1 retry_interval = 5 } preacct { preprocess acct_unique files } accounting { sql } }
Please advice on threading configuration from Radius to MySQL to determine optimal configuration; Radius is configurred to use five threads, but we observe only one process on the database server at any one time.
Because you're using the wrong database back-end. If you used InnoDB, this wouldn't be a problem. Follow the instructions on this list. If you intend to run a system with a million users, it's a good idea to listen to the advice of people who have experience building such systems. Alan DeKok.
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.
Insert a single accounting record into mysql by hand. Does it take several seconds to complete? If it does something is seriously wrong with your *database*. Ivan Kalik Kalik Informatika ISP
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
ramesh p wrote:
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.
You have a million users, and you haven't tested it prior to deploying it in a live environment? And I have *no* idea how you get it to behave so poorly. If you install FR + MySQL on a stock Linux box, you should be able to get 100's of accounting writes per second. It's what I do every week. Alan DeKok.
participants (4)
-
Alan Buxey -
Alan DeKok -
Ivan Kalik -
ramesh p