Server Optimisation Request

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

<div>[root@vps off]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 11
cpu MHz : 138.189
cache size : 4096 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 tm2 cx16 xtpr lahf_lm

bogomips : 3726.70
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 : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 11
cpu MHz : 138.189
cache size : 4096 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 tm2 cx16 xtpr lahf_lm
bogomips : 3723.85
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 : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 11
cpu MHz : 138.189
cache size : 4096 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 tm2 cx16 xtpr lahf_lm
bogomips : 3723.85
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 : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 11
cpu MHz : 138.189
cache size : 4096 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 tm2 cx16 xtpr lahf_lm
bogomips : 3723.88
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 : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 11
cpu MHz : 138.189
cache size : 4096 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 tm2 cx16 xtpr lahf_lm
bogomips : 3723.87
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 : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 11
cpu MHz : 138.189
cache size : 4096 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 tm2 cx16 xtpr lahf_lm
bogomips : 3723.88
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 : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 11
cpu MHz : 138.189
cache size : 4096 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 tm2 cx16 xtpr lahf_lm
bogomips : 3723.84
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 : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 11
cpu MHz : 138.189
cache size : 4096 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 tm2 cx16 xtpr lahf_lm
bogomips : 3723.87
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

RAM: 768mb burstable to 1.5G

vB version: 3.8.2

MySQL version: 5.0.45 installed using yum

TOP:

top - 1045 up 1 day, 15:51, 1 user, load average: 7.43, 15.17, 21.36
Tasks: 95 total, 12 running, 83 sleeping, 0 stopped, 0 zombie
Cpu(s): 16.1%us, 3.3%sy, 0.0%ni, 80.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 1572864k total, 1071664k used, 501200k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25915 mysql 17 0 169m 45m 5080 R 6.8 2.9 35:56.83 mysqld
16075 apache 16 0 42484 16m 3968 R 4.5 1.1 0:08.10 httpd
29927 apache 15 0 42432 16m 4020 S 3.9 1.1 0:07.12 httpd
6001 apache 16 0 45476 19m 3972 S 2.9 1.3 0:16.06 httpd
29864 apache 15 0 50324 24m 4144 S 2.9 1.6 0:07.11 httpd
29928 apache 15 0 43580 17m 3940 S 2.9 1.2 0:06.58 httpd
32752 apache 15 0 42204 16m 3932 S 2.9 1.1 0:07.92 httpd
5654 apache 16 0 41240 15m 3892 S 2.6 1.0 0:01.37 httpd
24077 apache 16 0 40152 14m 3660 R 2.6 0.9 0:00.35 httpd
5656 apache 15 0 43176 17m 3876 R 2.3 1.1 0:01.41 httpd
32470 apache 18 0 41616 15m 3908 R 2.3 1.0 0:01.96 httpd
28436 apache 15 0 44956 19m 3992 S 1.6 1.3 0:11.15 httpd
3501 apache 15 0 45472 19m 4056 S 1.3 1.3 0:20.58 httpd
3810 apache 15 0 45472 19m 3992 R 1.3 1.3 0:14.85 httpd
7871 apache 15 0 42688 16m 3928 S 1.3 1.1 0:04.27 httpd
10098 apache 15 0 45480 19m 4028 S 1.3 1.3 0:18.49 httpd
11444 apache 15 0 50476 24m 4168 R 1.3 1.6 0:05.64 httpd
19896 apache 15 0 42656 16m 3980 S 1.3 1.1 0:08.39 httpd
30263 apache 16 0 50752 26m 5988 S 1.3 1.7 0:06.88 httpd
5605 apache 15 0 40160 14m 3828 S 1.0 0.9 0:00.76 httpd
24146 apache 15 0 41028 15m 3732 S 1.0 1.0 0:00.95 httpd
26167 apache 15 0 42496 16m 3976 S 1.0 1.1 0:08.35 httpd
30293 apache 15 0 50316 24m 4124 S 1.0 1.6 0:03.01 httpd
7828 apache 15 0 41856 16m 3992 S 0.6 1.1 0:03.82 httpd
10174 apache 15 0 41592 15m 3956 R 0.3 1.0 0:04.47 httpd
29990 apache 15 0 44488 17m 4008 S 0.3 1.2 0:19.42 httpd
1 root 15 0 1988 652 560 S 0.0 0.0 0:05.08 init
1354 root 15 0 14324 932 536 S 0.0 0.1 0:14.42 rsyslogd
1358 root 25 0 1592 400 332 S 0.0 0.0 0:00.00 rklogd
1378 sw-cp-se 18 0 5888 1884 892 S 0.0 0.1 0:00.29 sw-cp-serverd
1404 root 18 0 2644 900 732 S 0.0 0.1 0:00.06 xinetd
1422 root 19 0 5848 808 540 S 0.0 0.1 0:00.00 couriertcpd
1424 root 19 0 4684 1048 824 S 0.0 0.1 0:00.00 courierlogger
1432 root 25 0 5848 804 540 S 0.0 0.1 0:00.00 couriertcpd
1434 root 25 0 4688 1052 824 S 0.0 0.1 0:00.00 courierlogger
1440 root 25 0 5844 804 540 S 0.0 0.1 0:00.00 couriertcpd
1442 root 25 0 4688 1052 824 S 0.0 0.1 0:00.00 courierlogger
1449 root 25 0 5844 804 540 S 0.0 0.1 0:00.00 couriertcpd

top - 10:55:20 up 1 day, 15:52, 1 user, load average: 7.14, 14.26, 20.82
Tasks: 95 total, 1 running, 94 sleeping, 0 stopped, 0 zombie
Cpu0 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 7.2%us, 1.1%sy, 0.0%ni, 91.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 0.4%us, 0.0%sy, 0.0%ni, 99.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st

Cpu3 : 3.2%us, 0.4%sy, 0.0%ni, 96.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 13.7%us, 1.5%sy, 0.0%ni, 84.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 0.6%us, 0.1%sy, 0.0%ni, 99.3%id, 0.1%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 0.6%us, 0.1%sy, 0.0%ni, 99.2%id, 0.1%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 0.7%us, 0.1%sy, 0.0%ni, 98.7%id, 0.5%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 1572864k total, 1079020k used, 493844k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

my.cnf:

[root@vps off]# cat /etc/my.cnf
[mysqld]
skip-networking
log-slow-queries

datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user = mysql
set-variable = max_connections=200
set-variable = table_cache=256
set-variable = max_delayed_threads=20
set-variable = max_tmp_tables=32
set-variable = query_cache_type=1
set-variable = query_cache_size=4M
set-variable = thread_cache_size=4
myisam_max_sort_file_size=6442450941
[mysql.server]
user = mysql
basedir = /var/lib

[safe_mysqld]
err-log = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid

+---------------------------------+---------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /usr/ |
| bdb_cache_size | 8388600 |
| bdb_home | /var/lib/mysql/ |
| bdb_log_buffer_size | 131072 |
| bdb_logdir | |
| bdb_max_lock | 10000 |
| bdb_shared_data | OFF |
| bdb_tmpdir | /tmp/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 5 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| engine_condition_pushdown | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -> __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server Optimisation Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-23-2009 12:22 PM
Server Optimisation Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-30-2009 03:40 AM
Server optimisation request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-30-2009 01:40 AM
Server (VPS) optimisation request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-21-2009 01:10 AM
Server (VPS) optimisation request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-21-2009 01:00 AM