List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 3 2005 6:19pm
Subject:Re: mysql mem usage
View as plain text  
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
Thread
mysql mem usageChris Knipe3 May
  • Re: mysql mem usageDan Nelson3 May
  • Re: mysql mem usageChris Knipe3 May
    • Re: mysql mem usageDan Nelson3 May
  • Re: mysql mem usageChris Knipe3 May