RES: FreeRadius + MySQL | radacct: Errors and Warnings
listas at dmnzs.com.br
Wed Oct 26 19:13:07 CEST 2011
Yes, there is a large number of rows in the radacct and radposauth tables.
The attribute 'Acct-Interim-Interval' works very well but makes many
I rotate these tables to archive old records, I think I'll do this every
Of course, the script wouldn't solve all my problems, but it was very
Maybe I really need some customization to the backend, I'll think about it.
De: freeradius-users-bounces+listas=dmnzs.com.br at lists.freeradius.org
[mailto:freeradius-users-bounces+listas=dmnzs.com.br at lists.freeradius.org]
Em nome de Fajar A. Nugraha
Enviada em: quarta-feira, 26 de outubro de 2011 13:17
Para: FreeRadius users mailing list
Assunto: Re: FreeRadius + MySQL | radacct: Errors and Warnings
On Wed, Oct 26, 2011 at 10:08 PM, Daniel Menezes <listas at dmnzs.com.br>
> I read something about slow backend, tables indexes and other things.
> I've used the backend script 'mysqltuner.pl' to adjust the performance.
> It's better now, but the warnings and erros persists.
> Can anyone help me on this?
Obviously the automated script-based adjustment isn't enough.
Get a dba. I haven't seen a script that's good enough to magically
solve all problems that it can replace an actual expert.
A dba would be able to do a deep dive into your configuration and come
up with the best solution based on your particular situation. Who
knows, one of the advices might be "delete these indexes" (no, I'm not
kidding) or "you need to archive accounting records older than x
List info/subscribe/unsubscribe? See
More information about the Freeradius-Users