optimize sqlippool scheme

[Phil Mayers]

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.