optimize sqlippool scheme

Phil Mayers p.mayers at imperial.ac.uk
Thu Jan 12 16:19:13 CET 2012

On 01/12/2012 01:40 PM, Alexander Kosykh wrote:
> I have interim accounting value 10 minutes and IP lease time is 30 minutes.

So you should be getting, what, ~40 accounting packets/second with 25k 
users online. Does this correspond to the query load you're seeing?

40 SQL updates/second is not a lot...

If you increase your interim accounting to 1800 seconds, you'll decrease 
that load to about 15 queries/second, which might be a quick and easy 
win. But it shouldn't be going that slow with that load IMHO.

More information about the Freeradius-Users mailing list