some mysql errors

[Tony Peña]

Hi...

i'm getting some many errors like this...


Mon Aug 20 11:27:26 2012 : Error: [sql] Couldn't update SQL accounting STOP
record - Lock wait timeout exceeded; try restarting transaction
Mon Aug 20 11:27:26 2012 : Error: rlm_sql_mysql: Cannot store result
Mon Aug 20 11:27:26 2012 : Error: rlm_sql_mysql: MySQL error 'Lock wait
timeout exceeded; try restarting transaction'

and other lines with Logins OK... but have more errors sql than logins ok...

i guess missing some tunning parameters...
i have, 15 NAS vs 2 freeradius-servers ..... this do AA vs 2 LDAP balanced
and A vs cluster-mysql
can help me more less to up or down some numbers to tune efficient the
requests about some experience ?

thx any way

-- 
Antonio Peña
Secure email with PGP 0x8B021001 available at http://pgp.mit.edu
Fingerprint: 74E6 2974 B090 366D CE71  7BB2 6476 FA09 8B02 1001
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120820/4f749a57/attachment.html>