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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]