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