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
