<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
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.<br>
<br>
Regards,<br>
<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 17/01/14 08:18, Antonio Fernández
Pérez wrote:<br>
</div>
<blockquote
cite="mid:CANz54joeyD8rXnDwEgUY7+k-wLmN820tz=6F+wx9wi1BS8-sxA@mail.gmail.com"
type="cite">
<div dir="ltr">Hi everybody,<br>
<br>
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?<br>
<br>
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.<br>
<br>
Any ideas?<br>
<br>
Thanks in advance.<br>
<br>
Regards,<br>
<br>
Antonio.</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">-
List info/subscribe/unsubscribe? See <a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
......................................
Eduardo Costa
Centro de Comunicações - Instituto Politécnico de Bragança
raposo at ipb.pt
<a class="moz-txt-link-freetext" href="http://www.ipb.pt/~raposo/">http://www.ipb.pt/~raposo/</a>
......................................
</pre>
</body>
</html>