Server Optimization Request !!!! (I have a high load problem)

محروم.كوم · #1 06-02-2009, 05:50 PM

virual server

CPU: 2 AMD Opteron 2212 HE
Memory: 41GB ram
Hard drive: 50GB sata II with raid
OS: linux centos 5
Apache 2.2.11
PHP 5.2.8
MySQL 5.0.67-community

3.8.2

MyISAM only

CPanel configured/installed

Top :

Code:
top - 06:19:37 up 2 days, 18:10, 2 users, load average: 13.02, 11.58, 11.74
Tasks: 93 total, 8 running, 85 sleeping, 0 stopped, 0 zombie
Cpu(s): 3.8% us, 1.4% sy, 0.0% ni, 88.6% id, 6.2% wa, 0.0% hi, 0.0% si
Mem: 1048576k total, 354176k used, 694400k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
20305 mysql 15 0 220m 69m 4404 S 8.3 6.8 2:34.29 mysqld
23574 nobody 15 0 99224 18m 5980 R 2.6 1.8 0:00.28 httpd
21889 nobody 16 0 96756 17m 7224 S 2.2 1.7 0:02.49 httpd
1852 nobody 15 0 98340 22m 10m S 1.9 2.2 0:02.44 httpd
9475 nobody 15 0 96304 16m 6288 S 1.3 1.6 0:00.73 httpd
14053 nobody 15 0 93840 14m 6292 R 1.0 1.4 0:00.61 httpd
14069 nobody 15 0 97744 17m 6124 R 1.0 1.7 0:00.56 httpd
9236 nobody 15 0 98560 17m 6664 S 0.6 1.7 0:01.25 httpd
1420 nobody 15 0 92556 12m 6260 S 0.3 1.2 0:01.48 httpd
1846 nobody 15 0 94388 18m 10m S 0.3 1.8 0:01.66 httpd
25819 root 15 0 6232 1164 868 R 0.3 0.1 0:00.01 top
28451 nobody 18 0 92884 17m 10m S 0.3 1.7 0:01.64 httpd
1 root 15 0 4840 632 524 S 0.0 0.1 0:01.18 init
1354 root 16 0 18508 1516 1096 S 0.0 0.1 0:00.01 sftp-server
1384 nobody 15 0 92544 12m 6200 S 0.0 1.2 0:00.61 httpd
1530 nobody 15 0 98500 18m 6236 S 0.0 1.8 0:01.27 httpd
1533 nobody 15 0 94560 18m 9.9m S 0.0 1.8 0:01.75 httpd
after hitting 1

Code:
top - 0655 up 2 days, 18:13, 1 user, load average: 32.79, 19.98, 14.84
Tasks: 116 total, 18 running, 97 sleeping, 0 stopped, 1 zombie
Cpu0 : 48.5% us, 6.1% sy, 0.0% ni, 45.5% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu1 : 10.0% us, 13.3% sy, 0.0% ni, 76.7% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu2 : 9.1% us, 6.8% sy, 0.0% ni, 84.1% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu3 : 33.3% us, 22.2% sy, 0.0% ni, 44.4% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu4 : 12.5% us, 3.6% sy, 0.0% ni, 76.8% id, 7.1% wa, 0.0% hi, 0.0% si
Cpu5 : 40.0% us, 13.3% sy, 0.0% ni, 46.7% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu6 : 21.2% us, 3.8% sy, 0.0% ni, 75.0% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu7 : 50.0% us, 13.3% sy, 0.0% ni, 36.7% id, 0.0% wa, 0.0% hi, 0.0% si

Mem: 1048576k total, 408080k used, 640496k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
7.my.cnf

Code:
[mysqld]
local-infile=0
datadir=/var/lib/mysql
skip-locking
skip-innodb
skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=32M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=180
max_connections=300
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=128M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M ## 1MB for every 1GB of RAM
read_buffer_size=1M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM
thread_concurrency=16 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci

[mysql.server]
user=mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

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

[mysqlhotcopy]
interactive-timeout
8 . statistics.txt :

statistics.txt is empty !!!!!!!!!!!

9 . nothing of note
10 . Average 400-500, Max 800. Cookie timeout = 3600
11.http://www.al3malka.com/phpinfo.php
12.

Code:
KeepAlive not found !!!!!!!!!!!!!!!!!!
MaxKeepAliveRequests not found !!!!!!!!!!!!!!!!!!
KeepAliveTimeout not found !!!!!!!!!!!!!!!!!!
MinSpareServers 5
MaxSpareServers 10
StartServers 2
MaxClients 150
Maxrequestsperchild 0
13 . size +2000000k

Code:
/home/cprestore/cpmove-scream.tar.gz
14.
uname -a
Code:
Linux host1.al3malka.com 2.6.18-028stab060.8 #1 SMP Mon Feb 9 20:25:36 MSK 2009 x86_64 x86_64 x86_64 GNU/Linux
ulimit -aH

Code:
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited

file size (blocks, -f) unlimited
pending signals (-i) 137216
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 137216
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo
Code:
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
stepping : 6
cpu MHz : 65.108
cache size : 6144 KB
physical id : 0
siblings : 4
core id : 0
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 5335.62
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
stepping : 6
cpu MHz : 65.108
cache size : 6144 KB
physical id : 1
siblings : 4
core id : 0
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 5332.77
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
stepping : 6
cpu MHz : 65.108
cache size : 6144 KB
physical id : 0
siblings : 4
core id : 1
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 5332.84
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
stepping : 6
cpu MHz : 65.108
cache size : 6144 KB
physical id : 1
siblings : 4
core id : 1
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 5332.85
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 4
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
stepping : 6
cpu MHz : 65.108
cache size : 6144 KB
physical id : 0
siblings : 4
core id : 2
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 5332.75
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 5
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
stepping : 6
cpu MHz : 65.108
cache size : 6144 KB
physical id : 1
siblings : 4
core id : 2
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 5332.77
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 6
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
stepping : 6
cpu MHz : 65.108
cache size : 6144 KB
physical id : 0
siblings : 4
core id : 3
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 5332.75
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 7
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
stepping : 6
cpu MHz : 65.108
cache size : 6144 KB
physical id : 1
siblings : 4
core id : 3
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 5332.79
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management: __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server Optimization Request. First time optimization	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-08-2009 04:40 AM
vps optimization for high load	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-19-2009 05:50 PM
vps optimization for high load	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-19-2009 05:44 PM
Very High Server Load \|\| Optimization Request!	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-10-2009 02:40 PM
Server Optimization Request - Please help! Server loads way too high!	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-05-2009 02:00 AM