Memory Creeping Up

[Ben Ricker]

On Mon, 2003-09-15 at 14:26, Patrick Larkin wrote:
> 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?
> 
> 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.

You still have plenty of memory left. You might also want to look at
installing sar (I believe it comes in the 'sysstat' rpm. You may be
looking at "dirty memory", that is, RAM that is available for use, but
is temporarily marked as not free. When and if the system needs it, the
system will clean up the dirty memory and use it for currently needed
allocation. Also, you may be looking at cached memory. Memory take up by
cached data can also be claimed if need be.

You may just be looking at a difference between the memory allocation
"styles" of Linux and OS X. I myself run Linux servers almost
exclusively. My desktop shares OS X and YellowDog.

Ben Ricker

> 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
> 
> _______________________________________________
> yellowdog-general mailing list
> yellowdog-general@lists.terrasoftsolutions.com
> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-general