optimize sqlippool scheme
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