One solution may be to change your insert statements in sql.conf from "Insert" to "Insert Delayed".
you can read some here: http://www.mysql.com/doc/en/INSERT_DELAYED.html Post back to the list if it works..... I'm no guru, so back up your sql.conf before making changes :) -Mike ----- Original Message ----- From: "Mike Sturdee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 11, 2004 3:31 PM Subject: accounting to mysql database > I have radius set up to log accounting to a MySQL database. It currently > holds a couple years worth of logging from several thousand users, so it's > quite large.. Problem I'm having is if I do a select that will return a > couple hundred entries, or anything other than the simplest of queries, > radius will freeze until the query is sql complete, resulting in any auth > requests essentially to be rejected. > > FreeRadius 0.9.3 > MySQL Server 4.0.17 (MyISAM tables) > > What might be causing this, or what could I do to resolve this? > > Thanks, > > -Mike > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
