On Thu, 23 May 2002 16:37:09 -0500, Chris Parker wrote:
>At 06:28 PM 5/23/2002 -0300, Alexandre Strube wrote:
>>My machine (a athlon 1000 with 512mb ram) begins to run slower afer two
>>days of radius
>>operation... and mysql begins to take more and more cpu..
>>I've been using mysql on this machine for more than a year now, and this
>>begun only
>>with freeradius-0.5. Now I'm using a four-days ago snapshot, and had to
>>boot the machine
>>today..
>Most likely your mysql server/table definitions do not contain proper
>or sufficient indexes. The fact that it slows over time strongly indicates
>this.
>You should look at your mysql tables, and investigate creating additional
>indexes. Use the 'explain' function of mysql.
>More docs on tuning mysql available at: www.mysql.com.
I`m using the standard radius tables as described on rlm_sql_mysql schema.
And this happens only when freeradius is running on the machine. I've closed
freeradius and nothing happened, inspite of intensive use of mysql thoughout
the day.
As opini�es formuladas neste e-mail s�o de car�ter
exclusivamente pessoal. Minha opini�o n�o necessariamente
representa a opini�o do meu Moto Grupo nem da empresa onde
trabalho.
Mene Sakkhet ur-seveh
Alexandre Ganso - Diretor Steel Goose Moto Group
6, 7 e 8 de setembro - Aniversario 10 anos Steel Goose - Ouro Branco - MG
500 Four Vermelha
[EMAIL PROTECTED]
ICQ# 3778773
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
