From: Dan Nelson
Date: May 3 2005 6:19pm
Subject: Re: mysql mem usage
List-Archive: http://lists.mysql.com/mysql/183569
Message-Id: <20050503181944.GB49336@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (May 03), Chris Knipe said:
> top...
> FreeBSD 5.4-STABLE, linuxthreads
> 
> last pid: 56803;  load averages:  0.29,  0.31,  0.14  up 5+11:10:10  20:09:05
> 174 processes: 1 running, 169 sleeping, 4 zombie
> CPU states:  0.0% user,  2.3% nice,  1.2% system,  0.0% interrupt, 96.5%  idle
> Mem: 422M Active, 237M Inact, 217M Wired, 43M Cache, 111M Buf, 73M Free
> Swap: 512M Total, 297M Used, 215M Free, 58% Inuse, 16K In
> 
>  PID USERNAME PRI NICE   SIZE    RES STATE    TIME   WCPU    CPU COMMAND
> 55651 mysql      8   12   138M 33524K nanslp   0:21  0.00%  0.00% mysqld
> 55649 mysql     20   14   138M 33524K pause    0:21  0.00%  0.00% mysqld
> 55866 mysql      4   14   138M 33524K sbwait   0:12  0.00%  0.00% mysqld

Ya, since you're using linuxthreads, these are all really one process
with one single 138MB address space; note that SIZE and RES are
identical all the way down.

> 76746 squid     96    0 90756K 38016K select   4:16  0.00%  0.00% squid
> 56725 pmx4      96    0 36524K 34908K select   0:01  0.00%  0.00% perl
> 56724 pmx4      96    0 36172K 34560K select   0:00  0.00%  0.00% perl

Try running "ps axlm", which will show all the processes sorted by
memory usage.  If there are more of those perl scripts running, they
may be a contributing factor.  Apache with script modules (perl/php
etc) can also suck up lots of memory if you get lots of hits at once.

-- 
	Dan Nelson
	dnelson@stripped