Radacct table is growing and growing

[Eduardo Costa]

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/    
......................................

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140117/4124219d/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3268 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140117/4124219d/attachment-0001.bin>