Date: Thu, 30 Apr 2009 21:02:38 +0200 From: VeeJay <maanjee@gmail.com> To: Mel Flynn <mel.flynn+fbsd.questions@mailing.thruhere.net> Cc: Peter <peterpub2@aboutsupport.com>, freebsd-questions@freebsd.org Subject: Re: Where am I wasting resources? How to fix this problem? Message-ID: <2cd0a0da0904301202n1edaea1du5bba7e8b34266d70@mail.gmail.com> In-Reply-To: <2cd0a0da0904280640r12f0028fq9beb49ee0dce5fc7@mail.gmail.com> References: <2cd0a0da0904280122x5416837re97255dc37283dc5@mail.gmail.com> <49F6E261.6040808@aboutsupport.com> <2cd0a0da0904280521u125b4180s4e626670b67b73d5@mail.gmail.com> <200904281519.12945.mel.flynn%2Bfbsd.questions@mailing.thruhere.net> <2cd0a0da0904280640r12f0028fq9beb49ee0dce5fc7@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi Mel
I tried your suggestions by giving values
vm.kmem_size_max="1024M"
vm.kmem_size="1024M"
but still got mysql hung.... without any luck.... here is the top output:
even though there is plenty of free memory....
Guys, I am not very good on freebsd, its you guys who help me to keeping my
server up... I hope you can spare a few minutes to sort this problem...
last pid: 19656; load averages: 1.00, 1.00,
1.00
up 2+05:00:12 19:18:47
3049 processes:2 running, 3047 sleeping
CPU: 12.5% user, 0.0% nice, 0.1% system, 0.0% interrupt, 87.4% idle
Mem: 6253M Active, 3810M Inact, 921M Wired, 128K Cache, 214M Buf, 4683M Free
Swap: 32G Total, 32G Free
PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND
830 mysql 1500 44 0 1670M 813M ucond 1 0:00 100.00% mysqld
19649 sshUser 1 44 0 16304K 8340K CPU1 1 0:00 0.39% top
18277 sshUser 1 44 0 26448K 2756K select 0 0:28 0.00% sshd
841 root 1 44 0 115M 17132K select 0 0:24 0.00%
httpd
790 postfix 1 4 0 4600K 1972K kqread 1 0:07 0.00% qmgr
14353 apache 1 4 0 117M 50896K sbwait 0 0:05 0.00% httpd
17564 apache 1 4 0 119M 16084K sbwait 0 0:05 0.00% httpd
18320 sshUser 1 44 0 21560K 5920K select 1 0:04 0.00%
sftp-server
14395 apache 1 4 0 117M 51684K sbwait 0 0:04 0.00% httpd
782 root 1 4 0 4604K 1548K kqread 5 0:04 0.00%
master
14456 apache 1 4 0 120M 52440K sbwait 0 0:03 0.00% httpd
629 root 1 44 0 5688K 1252K select 2 0:02 0.00%
syslogd
18687 apache 1 4 0 116M 21528K sbwait 1 0:02 0.00% httpd
17759 apache 1 4 0 118M 15852K sbwait 3 0:02 0.00% httpd
17561 apache 1 4 0 117M 19368K sbwait 5 0:02 0.00% httpd
14609 apache 1 4 0 116M 50696K sbwait 2 0:02 0.00% httpd
14623 apache 1 4 0 117M 46444K sbwait 0 0:02 0.00% httpd
17599 apache 1 4 0 118M 14884K sbwait 1 0:02 0.00% httpd
16262 apache 1 4 0 119M 37000K sbwait 5 0:02 0.00% httpd
15176 apache 1 4 0 119M 32660K sbwait 3 0:01 0.00% httpd
16147 apache 1 4 0 118M 37540K sbwait 3 0:01 0.00% httpd
14624 apache 1 4 0 118M 45248K sbwait 2 0:01 0.00% httpd
18696 apache 1 4 0 116M 13544K sbwait 3 0:01 0.00% httpd
15694 apache 1 4 0 118M 31304K sbwait 2 0:01 0.00% httpd
17442 apache 1 4 0 118M 17872K sbwait 5 0:01 0.00% httpd
14621 apache 1 4 0 117M 45496K sbwait 4 0:01 0.00% httpd
17412 apache 1 4 0 118M 21500K sbwait 0 0:01 0.00% httpd
17504 apache 1 4 0 118M 16052K sbwait 0 0:01 0.00% httpd
14626 apache 1 4 0 118M 50984K sbwait 0 0:01 0.00% httpd
17448 apache 1 4 0 119M 19772K sbwait 5 0:01 0.00% httpd
12204 apache 1 4 0 116M 43588K sbwait 4 0:01 0.00% httpd
17560 apache 1 4 0 118M 15300K sbwait 0 0:01 0.00% httpd
17729 apache 1 4 0 119M 19828K sbwait 3 0:01 0.00% httpd
18017 apache 1 4 0 119M 17808K sbwait 3 0:01 0.00% httpd
16802 apache 1 4 0 118M 37124K sbwait 4 0:01 0.00% httpd
15640 apache 1 4 0 118M 31864K sbwait 4 0:01 0.00% httpd
18411 apache 1 4 0 119M 15084K sbwait 0 0:01 0.00% httpd
--
Thanks!
BR / vj
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?2cd0a0da0904301202n1edaea1du5bba7e8b34266d70>