Memory Creeping Up

[Patrick Larkin]

On Monday, September 15, 2003, at 03:04 PM, Ben Ricker wrote:

> You need to provide much more information here. What process(es) are
> taking the memory that is creeping up? MySQL?

Sorry about the post but I posted it on the newbie list and I suppose 
it was a bit advanced for that list.

I just took a screen shot of TOP and will check it tomorrow to see 
which processes are growing.  I'm just looking at the line:

Mem:   190592K av,   92396K used,   98196K free

The "Free" line was at 4000K this morning.

mysqld seems to stay at 14568 and even when its hit I don't notice it 
go up.  There are only 3 small databases running on it at the moment.   
I just didn't expect to see the memory fluctuate like that.  This setup 
was previously running on MacOS X and I didn't see this issue.

Thanks for the reply.

>
> If it is MySQL, you need to look at possible problems in the
> structure/processes within the database. Have you optimized all of the
> indexes? Do you need adjust some performance parameters? Do you have
> excess connections (i.e., connections to the DB not being closed)?
>
> Ben Ricker
>
> On Mon, 2003-09-15 at 13:58, Patrick Larkin wrote:
>> Hello -
>>
>> I'm running a YDL server running MySQL.  It has 192MB RAM.  when I ran
>> Top on Friday, only 49MB or so was used in non GUI mode.  When I 
>> looked
>> today, it was up to 185MB used with very little free.  What can I do 
>> do
>> prevent this or what can I do to clear memory without rebooting the
>> server?
>>
>> Thanks.
>>
>> Patrick
>>
>> _______________________________________________
>> yellowdog-general mailing list
>> yellowdog-general@lists.terrasoftsolutions.com
>> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-general
>
> _______________________________________________
> yellowdog-general mailing list
> yellowdog-general@lists.terrasoftsolutions.com
> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-general
>
>
Patrick Larkin
Bethlehem Area School District