FreeBSD+FreeRadius 10k subscribers
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
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.
participants (2)
-
Alan DeKok -
Antonio Nunnes