Slow "update radacct ..." query
mangia81 at gmail.com
Mon Jun 1 16:35:09 CEST 2009
I know that this maybe is not FreeRadius related question...
I have some problems with freeradius and mysql as a database. radacct table
is InnoDB and update queries (interim-updates) are terrible slow (10 - 50
sec). Interim-updates are triggered every 8 minutes so it isn't under heavy
load. (max 500 users online @ same time)
After I wrote a small benchmark script for testing this kind of queries (10
000 queries "UPDATE radacct SET ... " with random integer values for
acctinputoctets and acctoutputoctets) I can't reproduce this problem. My
script takes 10 000 random rows from radacct table (table has almost 600 000
rows) and it is finished in 130-180 seconds (executed 5 times and all
results are between 130 and 180 seconds). That means 0,013-0,018s/query
Slow query log is empty after this benchm. script. I checked radacct table
later and I have exaclty 10 000 updated rows so the script is OK.
Any ideas how to trace this problem ?
FreeRadius is 2.1.6 and the same problem I had with FR1.1.7 and FR2.1.3
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Freeradius-Users