FreeBSD+FreeRadius 10k subscribers

Alan DeKok aland at deployingradius.com
Tue Oct 28 17:50:24 CET 2014


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.


More information about the Freeradius-Users mailing list