FreeBSD+FreeRadius 10k subscribers

[Antonio Nunnes]

I have on average 5k a day online subscribers.

My freeradius and mysql-server:
Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz
2*4GB DDR3 1333MHz
3*1TB SAMSUNG BLUE in RAID 0

Mysql: mysql  Ver 14.14 Distrib 5.5.40, for FreeBSD10.1 (amd64) using  5.2

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.

I thought I'd share the radacct in radacct __% Y_% M has any better
solutions?

Sorry my bad english,
Antonio Nunness
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20141028/21f5aaab/attachment-0001.html>