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 _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"