Mike Sturdee <[EMAIL PROTECTED]> wrote:
> 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.

  Have two accounting databases: One used by your RADIUS server for
daily/weekly/monthly accounting for "live" sessions, and another for
multi-year backups.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to