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