[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Re: FreeBSD+FreeRadius 10k subscribers
From:       Alan DeKok <aland () deployingradius ! com>
Date:       2014-10-28 16:50:24
Message-ID: 544FC950.4080100 () deployingradius ! com
[Download RAW message or body]

Antonio Nunnes wrote:
> My problem :
> 
> My radacct now has 17 million lines, while the freeradius starts closing
> sessions begins to lock the table radacct and processing mysql rises too.

  You should delete old sessions.

  If you don't need the old sessions, delete them from the database.
This is basic database maintenance.

  If you do need to save the old sessions, move them to a historic database.

  It's probably best to *not* use tables named for each month.  Sessions
can cross a month boundary.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[prev in list] [next in list] [prev in thread] [next in thread]