FreeBSD+FreeRadius 10k subscribers

[Alan DeKok]

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.