12 Jan
2012
12 Jan
'12
10:19 a.m.
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.