Slow "update radacct ..." query

[Marinko Tarlac]

Hi

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
acctsessiontime,
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
(average)

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...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090601/122ba066/attachment.html>