some mysql errors

[alan buxey]

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

first thing I would suggest is to stop doing LIVE inserts of your accounting
- eg use buffered_sql module instead 

second thing - change your DB engine to InnoDB instead of MyISAM

thurd thing - add indexes and start a large number of DB connectors.

alan