Hi.

Please help me to optimise this server. some time server load is become high


CPanel server
model name : Intel® Celeron® CPU 2.40GHz
RAM-GB
Apache-1
4.1.21-standard


my.cnf
---------------
[mysqld]
skip-locking
skip-innodb
max_connections = 650
key_buffer = 128M
myisam_sort_buffer_size = 16M
join_buffer_size = 768K
read_buffer_size = 768K
sort_buffer_size = 1M
table_cache = 1500
thread_cache_size = 32
interactive_timeout = 60
wait_timeout = 60
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 16M
max_connect_errors = 10
thread_concurrency= 2
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
#query_prealloc_size = 16384
#query_alloc_block_size = 16384
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
-------
Timeout 150
KeepAlive On
MaxKeepAliveRequests 200
MinSpareServers 20
MaxSpareServers 40
StartServers 1
MaxClients 250
MaxRequestsPerChild 1000

free -m
-------

root@srv10 [~]# free -m
total used free shared buffers cached
Mem: 1002 994 8 0 14 512
-/+ buffers/cache: 468 534
Swap: 1992 353 1639

Please post output from "top" and also please tell what type of sites are hosted on this server.

11:36:07 up 6 days, 16:17, 2 users, load average: 1.27, 7.22, 10.64
139 processes: 137 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 26.2% 0.0% 0.5% 0.0% 0.1% 4.3% 68.5%
Mem: 1026976k av, 1014128k used, 12848k free, 0k shrd, 32852k buff
779872k actv, 146544k in_d, 19168k in_c
Swap: 2040244k av, 279236k used, 1761008k free 511784k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
22773 nobody 15 0 14036 12M 2776 S 7.3 1.2 0:06 0 httpd
22752 nobody 15 0 11212 9740 2744 S 4.7 0.9 0:05 0 httpd
22785 nobody 15 0 11372 9976 2772 S 4.5 0.9 0:04 0 httpd
22782 nobody 15 0 11372 9936 2768 S 4.1 0.9 0:05 0 httpd
22761 nobody 16 0 13780 11M 2708 S 3.7 1.1 0:04 0 httpd
22592 mysql 16 0 179M 123M 2360 S 0.5 12.3 0:03 0 mysqld
22786 nobody 15 0 11244 9820 2740 S 0.3 0.9 0:05 0 httpd
22789 nobody 15 0 13700 10M 2736 S 0.3 1.0 0:05 0 httpd
23861 root 15 0 1160 1160 888 R 0.3 0.1 0:00 0 top
22784 nobody 15 0 14268 10M 2764 S 0.1 1.0 0:04 0 httpd
23431 GLUGP100 15 0 1160 1128 872 S 0.1 0.1 0:00 0 top
1 root 15 0 260 228 200 S 0.0 0.0 0:06 0 init
2 root 15 0 0 0 0 SW 0.0 0.0 0:04 0 keventd
3 root 15 0 0 0 0 SW 0.0 0.0 0:02 0 kapmd
4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0

---------------

This is shared server for webhosting. most website using Vbulleting forum

Make the following changes in httpd.conf

and in my.cnf: