On 20 Aug 2012, at 16:40, alan buxey <A.L.M.Buxey@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