Hi admin,

Please help me to optimize this server. my problem is suddently server load is become high (load average: 256,150,121) and getting error network error. once i restart http then server will work fine and there is no more load issue. We did Os reload also in this server but still server hangs. please help me to fix.

Os. Rhel-3
cpanel
Intel® Celeron® CPU 2.40GHz
mysql-4.1 ( updated from 4.0 )
apache-1.36

top ( now it is very cool)
---

19:15:48 up 23:11, 1 user, load average: 0.00, 0.16, 1.87
172 processes: 171 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 24.3% 0.0% 2.7% 0.0% 0.0% 4.5% 68.4%
Mem: 1026976k av, 816120k used, 210856k free, 0k shrd, 143488k buff
540792k actv, 24064k in_d, 1328k in_c
Swap: 2040212k av, 122044k used, 1918168k free 162444k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
17556 nobody 16 0 13468 13M 3516 S 23.4 1.3 0:02 0 httpd
16885 mysql 16 0 59476 43M 2212 S 1.8 4.3 0:00 0 mysqld
22938 root 20 0 1200 1200 884 R 1.8 0.1 0:00 0 top
1 root 15 0 184 148 124 S 0.0 0.0 0:05 0 init
2 root 15 0 0 0 0 SW 0.0 0.0 0:01 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/0
7 root 15 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:22 0 kswapd
6 root 15 0 0 0 0 SW 0.0 0.0 4:00 0 kscand
8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kupdated
9 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
17 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 scsi_eh_0
18 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 scsi_eh_1
21 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald

free -m
-------

total used free shared buffers cached
Mem: 1002 856 146 0 144 174
-/+ buffers/cache: 538 464
Swap: 1992 119 1873

my.cnf
------
total used free shared buffers cached
Mem: 1002 856 146 0 144 174
-/+ buffers/cache: 538 464
Swap: 1992 119 1873
root@glob2 [/home/uaenaco/public_html]# cat /etc/my.cnf
[mysqld]
socket=/var/lib/mysql/mysql.sock
skip-innodb
max_connections = 650
key_buffer = 24M
myisam_sort_buffer_size = 32M
join_buffer_size = 512K
read_buffer_size = 512K
sort_buffer_size = 256K
table_cache = 1248
thread_cache_size = 64
wait_timeout = 10800
connect_timeout = 10
tmp_table_size = 16M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
thread_concurrency=8
old-passwords = 1

[mysqld_safe]
err-log=/var/log/mysqld.log
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
-------

http.conf

Timeout 60
KeepAlive On
MaxKeepAliveRequests 250
KeepAliveTimeout 2
MinSpareServers 20
MaxSpareServers 40
StartServers 15
MaxClients 200
MaxRequestsPerChild 1000

ps -aux | grep -c http
33
ps -aux | grep -c mysql
3

20:46:09 up 1 day, 41 min, 1 user, load average: 1.07, 40.59, 41.54
181 processes: 178 sleeping, 2 running, 0 zombie, 1 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 0.0% 0.0% 0.7% 0.0% 0.0% 0.0% 99.2%
Mem: 1026976k av, 327356k used, 699620k free, 0k shrd, 12044k buff
253788k actv, 16412k in_d, 280k in_c
Swap: 2040212k av, 91840k used, 1948372k free 58296k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
6 root 15 0 0 0 0 SW 0.3 0.0 4:34 0 kscand
30984 root 16 0 1216 1216 892 R 0.3 0.1 0:00 0 top
1 root 15 0 184 148 124 S 0.0 0.0 0:05 0 init
2 root 15 0 0 0 0 SW 0.0 0.0 0:01 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/0
7 root 15 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:25 0 kswapd
8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kupdated
9 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
17 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 scsi_eh_0
18 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 scsi_eh_1
21 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
76 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 khubd
1824 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
1837 root 15 0 0 0 0 SW 0.0 0.0 0:17 0 kjournald
1866 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
1918 root 15 0 0 0 0 SW 0.0 0.0 0:01 0 kjournald
1924 root 15 0 0 0 0 SW 0.0 0.0 0:09 0 kjournald
2682 root 15 0 276 240 196 S 0.0 0.0 0:00 0 syslogd -m 0
2686 root 15 0 144 88 84 S 0.0 0.0 0:00 0 klogd -x
2722 root 25 0 148 92 88 S 0.0 0.0 0:00 0 /usr/sbin/courierlogger -pid=/var/spool/authdaemon/pid -facility=mail -start /usr/libexec/c
2723 root 15 0 204 136 108 S 0.0 0.0 0:00 0 /usr/libexec/courier-authlib/authdaemond
2733 root 15 0 184 164 124 S 0.0 0.0 0:00 0 mdadm --monitor --scan -f
2736 root 15 0 204 136 108 S 0.0 0.0 0:00 0 /usr/libexec/courier-authlib/authdaemond
2737 root 15 0 204 136 108 S 0.0 0.0 0:00 0 /usr/libexec/courier-authlib/authdaemond
2738 root 15 0 204 136 108 S 0.0 0.0 0:00 0 /usr/libexec/courier-authlib/authdaemond
2739 root 15 0 204 136 108 S 0.0 0.0 0:00 0 /usr/libexec/courier-authlib/authdaemond
2740 root 15 0 204 136 108 S 0.0 0.0 0:00 0 /usr/libexec/courier-authlib/authdaemond
2831 root 16 0 400 148 144 S 0.0 0.0 0:00 0 /usr/sbin/sshd
2845 root 24 0 216 100 96 S 0.0 0.0 0:00 0 xinetd -stayalive -pidfile /var/run/xinetd.pid
2920 root 15 0 288 232 228 S 0.0 0.0 0:00 0 /usr/sbin/courierlogger -pid=/var/run/imapd.pid -start -name=imapd /usr/lib/courier-imap/li
2921 root 15 0 232 176 172 S 0.0 0.0 0:00 0 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup
2930 root 25 0 128 80 76 S 0.0 0.0 0:00 0 /usr/sbin/courierlogger -pid=/var/run/imapd-ssl.pid -start -name=imapd-ssl /usr/lib/courier
2931 root 25 0 132 72 68 S 0.0 0.0 0:00 0 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup
2944 root 15 0 284 232 228 S 0.0 0.0 0:00 0 /usr/sbin/courierlogger -pid=/var/run/pop3d.pid -start -name=pop3d /usr/lib/courier-imap/li
2945 root 15 0 236 176 172 S 0.0 0.0 0:00 0 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup
2951 root 25 0 128 80 76 S 0.0 0.0 0:00 0 /usr/sbin/courierlogger -pid=/var/run/pop3d-ssl.pid -start -name=pop3d-ssl /usr/lib/courier
2952 root 25 0 132 72 68 S 0.0 0.0 0:00 0 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=30 -nodnslookup
3023 bin 15 0 528 128 96 S 0.0 0.0 0:00 0 /usr/sbin/cannaserver -syslog -u bin
3044 root 15 0 664 356 292 S 0.0 0.0 0:00 0 crond
3055 wnn 25 0 3512 100 96 S 0.0 0.0 0:00 0 /usr/bin/jserver
3149 root 15 0 4368 1256 388 S 0.0 0.1 0:00 0 cpbandwd
3183 cpanel 16 0 5952 1500 836 S 0.0 0.1 0:00 0 /usr/bin/stunnel-4.15local /usr/local/cpanel/etc/stunnel/default/stunnel.conf.run
3195 root 15 0 256 204 200 S 0.0 0.0 0:00 0 rhnsd --interval 240
3226 root 21 0 144 96 92 S 0.0 0.0 0:00 0 /sbin/mingetty tty1
3227 root 21 0 144 96 92 S 0.0 0.0 0:00 0 /sbin/mingetty tty2
3228 root 21 0 144 96 92 S 0.0 0.0 0:00 0 /sbin/mingetty tty3
3229 root 21 0 144 96 92 S 0.0 0.0 0:00 0 /sbin/mingetty tty4
3230 root 21 0 144 96 92 S 0.0 0.0 0:00 0 /sbin/mingetty tty5
3231 root 16 0 144 96 92 S 0.0 0.0 0:00 0 /sbin/mingetty tty6
4524 root 15 0 1048 708 604 R 0.0 0.0 0:11 0 sshd: root@pts/1

It seems like that some log processing is slowing down the server. Configure your cPanel settings to halt backups n log processing at a certain load level, such as 3. Besides that, let me know the output of the following command:

uname -a

Linux sw2.hotserver.com 2.4.21-47.EL #1 Wed Jul 5 20:46:55 EDT 2006 i686 i686 i386 GNU/Linux