Radacct table is growing and growing

[Antonio Fernández Pérez]

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 at 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140117/75a7e91e/attachment.html>