On 20 Aug 2012, at 16:40, alan buxey <[email protected]> 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
