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
