|
Server Optimization Request !!!! (I have a high load problem)
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 - 06:21:55 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: |
| الساعة الآن 01:53 AM |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir