0% idle
Think MySQL is bout to kill the server...4:05pm up 1 day, 1:20, 1 user, load average: 3.35, 3.41, 2.23
140 processes: 136 sleeping, 3 running, 1 zombie, 0 stopped
CPU states: 74.6% user, 25.3% system, 0.0% nice, 0.0% idle
Mem: 1001400K av, 981584K used, 19816K free, 0K shrd, 134628K buff
Swap: 522072K av, 23872K used, 498200K free 604216K cached
1033 mysql 19 0 32084 15M 1580 R 46.2 1.6 2:38 mysqld
1733 nobody 9 0 ****8 12M 11136 S 6.5 1.2 0:00 httpd
2067 root 19 0 972 972 716 R 6.5 0.0 0:00 top
1586 nobody 14 0 15464 14M 11348 R 6.1 1.4 0:00 httpd
322 nobody 18 0 15492 14M 11200 R 4.9 1.4 0:01 httpd
2083 mysql 17 0 31952 15M 1580 R 3.6 1.6 0:00 mysqld
2081 mysql 12 0 31952 15M 1580 S 2.4 1.6 0:00 mysqld
328 nobody 9 0 13708 12M 11164 S 1.2 1.3 0:01 httpd
1699 nobody 10 0 12484 11M 11316 S 1.2 1.1 0:00 httpd
1823 nobody 9 0 13736 12M 11296 S 1.2 1.3 0:00 httpd
2082 mysql 12 0 31952 15M 1580 S 1.2 1.6 0:00 mysqld
1793 nobody 9 0 12560 11M 11272 S 0.8 1.1 0:00 httpd
2009 named 9 0 16696 16M 1916 S 0.4 1.6 6:39 named
2619 mysql 14 0 32272 16M 1580 S 0.4 1.6 0:30 mysqld
Ever since this upgrade on cpanel from MySQL 3 to 4 it really uses up some resources.
service mysql stop
4:07pm up 1 day, 1:22, 1 user, load average: 2.37, 3.12, 2.30
123 processes: 122 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: 0.6% user, 10.2% system, 0.0% nice, 89.1% idle
Mem: 1001400K av, 953152K used, 48248K free, 0K shrd, 132444K buff
Swap: 522072K av, 8616K used, 513456K free 582196K cached

Usually after a stop and start idle % usually runs around 60% but it wont last long. Any suggestions?