FreeRadius makes MySQL 100% CPU loading

2002-05-23 Thread Patrick Chan 
Title: FreeRadius makes MySQL 100% CPU loading





Dear all,


When I use FreeRadius 0.5 and use MySQL module,
the CPU loading of MySQL server is extremely high.


radiusd.conf has only sql in authorize section
authorize {
 sql
}


Thanks.


Patrick

Re: FreeRadius makes MySQL 100% CPU loading

2002-05-23 Thread Alexandre Strube 


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

--Original Message Text---
From: Patrick Chan
Date: Thu, 23 May 2002 17:33:48 +0800

FreeRadius makes MySQL 100% CPU loading 

Dear all, 

When I use FreeRadius 0.5 and use MySQL module, 
the CPU loading of MySQL server is extremely high. 

radiusd.conf has only sql in authorize section 
authorize { 
sql 
} 

Thanks. 

Patrick 







Asopiniõesformuladasnestee-mailsãodecaráter
exclusivamentepessoal.Minhaopiniãonãonecessariamente
representaaopiniãodomeuMotoGruponemdaempresaonde
trabalho.

MeneSakkhetur-seveh
AlexandreGanso-DiretorSteelGooseMotoGroup
6,7e8desetembro-Aniversario10anosSteelGoose-OuroBranco-MG
500FourVermelha
[EMAIL PROTECTED]
ICQ#3778773

Re: FreeRadius makes MySQL 100% CPU loading

2002-05-23 Thread Chris Parker 

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.

-Chris
--
\\\|||///  \  StarNet Inc.  \ Chris Parker
\ ~   ~ /   \   WX *is* Wireless!\   Director, Engineering
| |\   http://www.starnetwx.net \  (847) 963-0116
oOo---(_)---oOo--\--
   \ Wholesale Internet Services - http://www.megapop.net



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: FreeRadius makes MySQL 100% CPU loading

2002-05-23 Thread Alan DeKok 

Alexandre Strube [EMAIL PROTECTED] 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..

  Have you tried indexing your MySQL database?

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: FreeRadius makes MySQL 100% CPU loading

2002-05-23 Thread Alexandre Strube 

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