some mysql errors

[Arran Cudbard-Bell]

On 20 Aug 2012, at 16:40, alan buxey <A.L.M.Buxey at LBORO.AC.UK> wrote:

> 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

It's NDB (he's running cluster). 

-Arran