What is the purpose of the default accounting-on/off queries?

Alan DeKok aland at deployingradius.com
Sun Oct 10 13:16:05 CEST 2021


On Oct 9, 2021, at 10:28 PM, Nathan Ward <lists+freeradius at daork.net> wrote:
>> As well as the VRF issue, you can experience this in global context if
>> the database connection is configured with a query timeout and the
>> bulk session update does not complete in time.
> 
> It seems very odd to me that you would have an Accounting-On/Off query taking anywhere near what a DB query timeout is. That doesn’t sound like an MX issue - that sounds like some index tuning is required, or perhaps the query is doing a large amount of work that could be handled another way?

  If it's a big GGSN, then updating 100K rows can take time.  Doing that update in an asynchronous transaction would be better, perhaps.

  Alan DeKok.




More information about the Freeradius-Users mailing list