Please help me sort out this memory/serverload problem...

I just got this server today, and I have 1 site on it that needs to run really well, and the memory loads are spiking, and I have only had the site on the server for a matter of hours. MySQL is tearing up memory.

Here is my TOP which only reflects high memory usage.

It's a P4 2.6 with 512MB RAM - Only the one site needs to run on it.

Code:
 12:51:13  up  2:19,  1 user,  load average: 0.19, 0.22, 0.18
141 processes: 140 sleeping, 1 running, 0 zombie, 0 stopped
CPU states:   1.3% user   8.7% system   0.0% nice   0.0% iowait  89.8% idle
Mem:   512784k av,  506404k used,    6380k free,       0k shrd,   46548k buff
                    350972k actv,   44588k in_d,   34356k in_c
Swap: 1020088k av,   11072k used, 1009016k free                  274804k cached

  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME CPU COMMAND
 2110 root      15   0  1004 1004    76 S     3.3  0.1   2:00   0 httpd
 1052 named     25   0  2804 2804   884 S     0.6  0.5   0:07   0 named
 7536 root      21   0  1164 1164   868 R     0.6  0.2   0:00   0 top
    1 root      15   0   112   88    56 S     0.0  0.0   0:05   0 init
    2 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 keventd
    3 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 kapmd
    4 root      34  19     0    0     0 SWN   0.0  0.0   0:00   0 ksoftirqd_CPU0
    9 root      25   0     0    0     0 SW    0.0  0.0   0:00   0 bdflush
    5 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 kswapd
    6 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 kscand/DMA
    7 root      15   0     0    0     0 SW    0.0  0.0   0:03   0 kscand/Normal
    8 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 kscand/HighMem
   10 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 kupdated
   11 root      25   0     0    0     0 SW    0.0  0.0   0:00   0 mdrecoveryd
   15 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 kjournald
   73 root      25   0     0    0     0 SW    0.0  0.0   0:00   0 khubd
  281 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 kjournald
  282 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 kjournald
  283 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 kjournald
  284 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 kjournald
  530 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 eth0
  776 root      15   0   236  204   156 S     0.0  0.0   0:00   0 syslogd
  780 root      15   0   172  160   120 S     0.0  0.0   0:00   0 klogd
  876 nobody    15   0   672  248   148 S     0.0  0.0   0:00   0 proftpd
  886 root      15   0   372  228   140 S     0.0  0.0   0:00   0 sshd
  900 root      15   0   432  352   280 S     0.0  0.0   0:00   0 xinetd
  909 root      15   0   712  680   504 S     0.0  0.1   0:00   0 antirelayd
  919 root      18   0  1880 1020   616 S     0.0  0.1   0:00   0 chkservd
  932 mailnull  15   0   496  256   180 S     0.0  0.0   0:00   0 exim
  936 mailnull  25   0   316    4     0 S     0.0  0.0   0:00   0 exim
  940 root      15   0   716  648   504 S     0.0  0.1   0:00   0 antirelayd
  958 root      15   0 16544  12M     0 S     0.0  2.5   0:00   0 spamd
  967 root      15   0   156  156    88 S     0.0  0.0   0:00   0 crond
 1064 root      15   0   720  720   236 S     0.0  0.1   0:00   0 cupsd
 1353 mailnull  15   0  2780 2780   436 S     0.0  0.5   0:00   0 eximstats
 1410 root      15   0  1568 1568   140 S     0.0  0.3   0:00   0 webmaild
 1447 nobody    24   0   728  728     0 S     0.0  0.1   0:00   0 entropychat
 1451 nobody    25   0   236  236     0 S     0.0  0.0   0:00   0 melange
 1488 cpanel    25   0   268  268     0 S     0.0  0.0   0:00   0 stunnel-4.04loc
 1525 root      17   0  1672 1672   140 S     0.0  0.3   0:00   0 whostmgrd
 1535 root      25   0    52   52     0 S     0.0  0.0   0:00   0 rhnsd
 1556 root      25   0    72   72     0 S     0.0  0.0   0:00   0 portsentry
 1588 root      20   0    52   52     0 S     0.0  0.0   0:00   0 mingetty
 1589 root      20   0    48   48     0 S     0.0  0.0   0:00   0 mingetty
 1590 root      20   0    52   52     0 S     0.0  0.0   0:00   0 mingetty
 1591 root      20   0    52   52     0 S     0.0  0.0   0:00   0 mingetty
 1592 root      20   0    52   52     0 S     0.0  0.0   0:00   0 mingetty
 1593 root      20   0    52   52     0 S     0.0  0.0   0:00   0 mingetty
 5541 root      18   0  2428 2428   856 S     0.0  0.4   0:00   0 whostmgrd
 5547 mailman   25   0  4732 4732  1980 S     0.0  0.9   0:00   0 mailmanctl
 5551 mailman   15   0  4688 4688  1904 S     0.0  0.9   0:00   0 python2
 5552 mailman   15   0  4688 4688  1904 S     0.0  0.9   0:00   0 python2
 5553 mailman   15   0  4684 4684  1904 S     0.0  0.9   0:00   0 python2
 5554 mailman   15   0  4688 4688  1904 S     0.0  0.9   0:00   0 python2

 

 

 

 

Top