CPU/RAM Overload - Issues with MySql/Exim
Cpanel 10.8.1
Dont remember how to get app versions in ssh (im a noob sorry) if you guys need them tell me how and I will get them
CPU p4 2.0ghz
1G Ram
CPU stays constant 2-3off peak 6-7during peak
Memory 60%off peak 70-80%during peak
WHM cpu/mysql usage
mysql - 8%cpu 99%ram (have seen it up to 150%)
top process - 3% /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/mail.mbychosting.com.pid --skip-locking --socket/var/lib/mysql/mysql.sock
root - 5%cpu 5%ram
top process - 50% /usr/sbin/exim -q
Top:
15:51:59 up 2 days, 22:36, 1 user, load average: 5.67, 5.18, 5.03
192 processes: 187 sleeping, 4 running, 0 zombie, 1 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 0.2% 54.5% 7.4% 0.0% 2.4% 4.3% 30.9%
Mem: 1027480k av, 1015952k used, 11528k free, 0k shrd, 37776k buff
779016k actv, 147068k in_d, 20912k in_c
Swap: 2048276k av, 913556k used, 1134720k free 275668k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
12791 mysql 22 6 35088 28M 1288 S N 5.7 2.8 0:03 0 mysqld
12128 nobody 19 4 15400 11M 2760 S N 5.3 1.1 5:53 0 httpd
32309 mysql 22 6 35088 28M 1288 S N 5.3 2.8 0:23 0 mysqld
12138 nobody 19 4 15460 11M 2768 S N 4.7 1.1 6:20 0 httpd
12164 nobody 19 4 16056 12M 2752 S N 3.3 1.2 5:56 0 httpd
12111 nobody 19 4 15616 11M 2740 S N 3.1 1.1 6:43 0 httpd
12154 nobody 19 4 15660 11M 2756 S N 2.6 1.1 6:03 0 httpd
12126 nobody 19 4 15136 11M 2888 S N 2.4 1.1 6:14 0 httpd
12109 nobody 19 4 15844 12M 2908 S N 2.2 1.2 6:23 0 httpd
30642 mysql 22 6 35088 28M 1288 S N 2.2 2.8 0:30 0 mysqld
18858 nobody 19 4 18704 14M 2612 S N 1.8 1.4 0:10 0 httpd
12118 nobody 19 4 15188 12M 2788 S N 1.2 1.2 6:42 0 httpd
12167 nobody 19 4 15500 11M 2696 S N 1.2 1.1 6:22 0 httpd
32306 mysql 21 6 35088 28M 1288 S N 1.2 2.8 0:23 0 mysqld
393 nobody 19 4 13280 10M 2812 S N 1.2 1.0 0:10 0 httpd
12116 nobody 19 4 17756 12M 2836 S N 1.0 1.2 6:00 0 httpd
12156 nobody 19 4 15136 11M 2748 S N 1.0 1.1 5:49 0 httpd
12165 nobody 19 4 15372 12M 2904 S N 1.0 1.2 6:26 0 httpd
12150 nobody 19 4 15284 12M 2744 S N 0.8 1.2 6:12 0 httpd
10034 nobody 19 4 13128 9.9M 2592 S N 0.8 0.9 0:05 0 httpd
12798 nobody 19 4 11552 9940 2616 S N 0.8 0.9 0:06 0 httpd
12142 nobody 19 4 18224 12M 2800 S N 0.6 1.2 5:54 0 httpd
12155 nobody 20 4 15532 11M 2764 R N 0.6 1.1 5:50 0 httpd
12163 nobody 20 4 16036 12M 2760 S N 0.6 1.2 5:52 0 httpd
12431 nobody 19 4 14764 10M 2620 S N 0.6 1.0 0:33 0 httpd
392 nobody 19 4 10500 8788 2600 S N 0.6 0.8 0:09 0 httpd
15871 root 16 0 1248 1216 888 R 0.6 0.1 0:01 0 top
12106 nobody 19 4 15508 11M 2684 S N 0.4 1.1 6:02 0 httpd
12108 nobody 19 4 15432 11M 2780 S N 0.4 1.1 6:23 0 httpd
12130 nobody 19 4 15848 11M 2780 R N 0.4 1.1 5:59 0 httpd
12134 nobody 19 4 15784 11M 2780 S N 0.4 1.1 6:08 0 httpd
12146 nobody 19 4 15600 12M 2888 S N 0.4 1.1 5:49 0 httpd
12172 nobody 19 4 15456 11M 2704 S N 0.4 1.1 5:48 0 httpd
1644 mysql 22 6 35088 28M 1288 S N 0.4 2.8 0:21 0 mysqld
6 root 15 0 0 0 0 SW 0.2 0.0 2:10 0 kscand
6075 mailman 23 8 3952 1452 1152 S N 0.2 0.1 0:45 0 mailmanctl
my.cnf setup
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections = 125
connect_timeout=15
interactive_timeout=100
join_buffer_size=1M
key_buffer=64M
max_allowed_packet=16M
max_connect_errors=10
myisam_sort_buffer_size=32M
read_buffer_size=1M
read_rnd_buffer_size=1M
sort_buffer_size=1M
table_cache=1024
thread_cache_size=100
thread_concurrency=2
wait_timeout=300
query_cache_size=32M
query_cache_limit=1M
query_cache_type=1
skip-innodb
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
httpd.conf setup
timeout 45
keepalive on
maxkeepaliverequests 150
keepalivetimeout 3
minspareservers 16
maxspareservers 64
startservers 15
maxclients 200
maxrequestsperchild 0
Is there any more I can do to lessen the load on my CPU and memory?
Why is exim using 50% of my CPU, how can I fix that?
I appreciate any help! Thank you!
