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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
