freeradius load and message handling
lirankessel at gmail.com
Tue Jun 14 23:15:12 CEST 2016
Can the Freeradius be configured to cache data and write to DB in batches?
I could possibly stop writing to Mysql and logging the data to file, then parse the log files and load them to DB at a latter stage.
> On 14 Jun 2016, at 11:48 PM, Alan DeKok <aland at deployingradius.com> wrote:
> On Jun 14, 2016, at 4:00 PM, liran kessel <lirankessel at gmail.com> wrote:
>> we have a freeradius server collecting accounting events from a few Nokia GGSN’s and are storing them into the MySQL DB.
>> Now that we have activated all messages we are receiving around 20K messages a minute, and have started seeing these events in the radius.log
>> Tue Jun 14 22:53:33 2016 : Info: WARNING: Please check the configuration file. The value for 'max_requests' is probably set too low.
>> it was originally set to 1024, when we increased it and set it to 4096 the amount of such events was reduced but still didn’t disappear.
>> If we set it higher (6100 for example) we start getting these errors
>> Tue Jun 14 21:30:02 2016 : Error: Received conflicting packet from client localhost port 41935 - ID: 200 due to unfinished request 192178. Giving up on old request.
>> why does this event appear? what would be the best way to manage this situation?
> It appears because your database is overloaded. It can't write the records quickly enough.
>> The server has 8 Cores and 4GB of RAM.
>> It seems that the CPU isn’t overly loaded, but our RAM is almost completely used by the Radius and Mysql processes.
>> Will adding RAM to this server help us? or isn’t it the bottleneck for this issue?
> The bottleneck is the database. Typically it's waiting on "sync to disk". And there's very little you can do about that.
> Alan DeKok.
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
More information about the Freeradius-Users