Where am I wasting resources? How to fix this problem?

[VeeJay]

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