Thanks for your replies.

I know that radacct is not used for authentication but, its rows contains information (Seconds) to the counters (To allow or not start a session).

So, my problem is that I have all rows in only one table, without historical data. The server is working with NAS (Disk cabin), for this reason sharding and partitioning techniques I think that there are not necessary.

Do you know if are there some technique to implement or if FreeRADIUS allows to work with more than one radacct table?

Thanks in advance.

Regards,

Antonio.

2014/1/17 Antonio Fernández Pérez <antoniofernandez@fabergames.com>

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.