Hi,

you can do rotation of that table by month, using a script at crontab for example, must change in file sql.conf the name of table radacct for radacct%Y%m.

Regards,

On 17/01/14 08:18, Antonio Fernández Pérez wrote:

Hi everybody,

I have a radacct table with more than 12300000 rows. I have increased RAM memory recently because the data base is working with InnoDB engine and was necessary to load data into the buffer. But, anybody knows some technique that allows freeradius makes authentications with radacct historical tables?

I have thought in grouping rows using the UserName, keeping only one row for each user. Also I thought in make quarterly tables but this is a proble to authenticate users.

Any ideas?

Thanks in advance.

Regards,

Antonio.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- 
......................................
 Eduardo Costa
 Centro de Comunicações - Instituto Politécnico de Bragança    
 raposo at ipb.pt               
 http://www.ipb.pt/~raposo/    
......................................