Need Help- Server load too High 27.35, 20.27, 19.10

etrendwinner

Registered
Nov 4, 2011
2
0
51
cPanel Access Level
Root Administrator
Having issue with my VPS server, server load is too high and my Apache server keeps rebooting due to this load.

here are the details of my server and config files.

Really need help to resolve this issue, please let me know what is causing this issue and how to resolve the this.

cat /proc/cpuinfo | grep 'model name'
model name : Intel(R) Xeon(R) CPU E5440 @ 2.83GHz
model name : Intel(R) Xeon(R) CPU E5440 @ 2.83GHz
model name : Intel(R) Xeon(R) CPU E5440 @ 2.83GHz
model name : Intel(R) Xeon(R) CPU E5440 @ 2.83GHz

iostat
Linux 2.6.18-028stab092.1 (twin.trendwinner.com) 11/04/2011


avg-cpu: %user %nice %system %iowait %steal %idle
57.99 1.13 12.03 2.93 0.00 25.92


Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn



free -m
total used free shared buffers cached
Mem: 4092 581 3510 0 0 0
-/+ buffers/cache: 581 3510
Swap: 0 0 0

my.cnf

[mysqld]
skip-federated
skip-innodb
port = 3306
socket = /var/lib/mysql/mysql.sock
key_buffer = 256M
max_allowed_packet = 16M
table_cache = 384
sort_buffer_size = 32M
read_buffer_size = 4M
read_rnd_buffer_size = 4M
record_buffer=4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 192M
tmp_table_size=192M
join_buffer=32M
max_heap_table_size=192M
max_connections=500
log-slow-queries=/var/lib/mysql/slow_sql.log


[mysqldump]
quick
max_allowed_packet = 16M

ax_allowed_packet = 16M


[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M


[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M


[mysqlhotcopy]
interactive-timeout


Apache.conf

Timeout 300
TraceEnable On
ServerSignature Off
ServerTokens Full
FileETag All
StartServers 5
<IfModule prefork.c>
MinSpareServers 5
MaxSpareServers 10
</IfModule>
ServerLimit 256
MaxClients 150
MaxRequestsPerChild 10000
KeepAlive On
KeepAliveTimeout 10
MaxKeepAliveRequests 10

Top

top - 01:41:06 up 9 days, 19:36, 1 user, load average: 27.35, 20.27, 19.10
Tasks: 94 total, 35 running, 45 sleeping, 1 stopped, 13 zombie
Cpu(s): 86.8%us, 13.2%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 4190208k total, 857808k used, 3332400k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached


PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
7613 mysql 15 0 602m 220m 3804 S 3.6 5.4 31:18.62 mysqld
14069 trendwin 17 0 159m 17m 8892 R 3.3 0.4 0:00.29 php
14052 trendwin 18 0 158m 28m 20m R 2.9 0.7 0:00.20 php
14073 trendwin 18 0 159m 17m 8804 R 2.6 0.4 0:00.29 php
14077 trendwin 16 0 164m 24m 10m R 2.3 0.6 0:00.77 php
14089 trendwin 15 0 158m 23m 14m R 1.6 0.6 0:00.15 php
14068 trendwin 17 0 160m 18m 8944 R 1.3 0.4 0:00.31 php
14085 trendwin 16 0 159m 27m 19m R 1.3 0.7 0:00.18 php
14097 trendwin 18 0 156m 14m 8648 R 1.3 0.4 0:00.07 php
14072 trendwin 16 0 158m 22m 14m R 1.0 0.6 0:00.13 php
7542 nobody 15 0 421m 15m 6360 S 0.7 0.4 0:02.34 httpd
14074 trendwin 18 0 159m 16m 8356 R 0.7 0.4 0:00.23 php
14080 trendwin 16 0 162m 35m 24m R 0.7 0.9 0:00.29 php
5939 nobody 15 0 356m 14m 6380 S 0.3 0.3 0:02.63 httpd
14041 root 15 0 12720 1256 936 R 0.3 0.0 0:00.06 top
14078 vanartsc 17 0 163m 36m 24m R 0.3 0.9 0:00.41 php
14083 vanartsc 15 0 162m 34m 24m S 0.3 0.9 0:00.27 php
14099 trendwin 18 0 130m 6720 4744 R 0.3 0.2 0:00.01 php
1 root 15 0 10356 732 608 S 0.0 0.0 0:04.85 init
1136 root 15 -4 12624 676 356 S 0.0 0.0 0:00.00 udevd
1234 root 25 0 38860 608 480 S 0.0 0.0 0:00.00 brcm_iscsiuio
1462 root 15 0 5916 612 488 S 0.0 0.0 0:03.23 syslogd
1516 named 18 0 6564 768 528 S 0.0 0.0 0:00.12 nsd
 

Eric

Well-Known Member
Nov 25, 2007
753
12
143
Texas
cPanel Access Level
Root Administrator
Twitter
Howdy,

You should look at the trendwin user's php. It could be bad code causing the zombies you show in your top output or it could have just gotten popular. I suspect suspending the user would make the load go down. Check your apache error log for more. A server this active should have errors spewing to the log file, if there are problems.

Thanks!
 

etrendwinner

Registered
Nov 4, 2011
2
0
51
cPanel Access Level
Root Administrator
Hi, thanks for your reply.
I have moved one of my very active site to other server it is working fine on that server and i have only server load .30 ,.45, .50

Now question is why this server that i gave details above is not able to take up the load. After i moved that site still i see load is around 2.32, 2.34. 2.39 on this server.

details of server where site is working fine :

Server load 0.57 (4 CPUs)
Memory Used 57.16% (1,195,032 of 2,090,844)
Swap Used 21.35% (447,824 of 2,097,144)

only difference i see is this server is using more memory and swap space then my other server.
If this is the case can some one help me how to use buffer and swap memory to improve the performance?