Server optimization help

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

<div>Lately we are having a huge problem with high memory usage and it slows the site down to a crawl. So hopefully this will help. here is everything I could find. Thank you ahead of time and I appreciate any help that you can give.

1) Virtual Private server

2)

Processor Information

Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
Processor #1 speed: 375.468 MHz
Processor #1 cache size: 4096 KB

Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
Processor #2 speed: 375.468 MHz
Processor #2 cache size: 4096 KB

Processor #3 Vendor: GenuineIntel
Processor #3 Name: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
Processor #3 speed: 375.468 MHz
Processor #3 cache size: 4096 KB

Processor #4 Vendor: GenuineIntel
Processor #4 Name: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
Processor #4 speed: 375.468 MHz
Processor #4 cache size: 4096 KB

Guaranteed/Burst System Memory 256MB / 4GB

15GB non raid HD

CENTOS 4.7 i686 virtuozzo on server

Server Type Linux
Web Server Apache v2.2.10
PHP 5.2.5
PHP Max Post Size 8.00 MB
PHP Maximum Upload Size 10.00 MB
PHP Memory Limit 32.00 MB
MySQL Version 5.0.77-community
MySQL Packet Size 64.00 MB

3) Vbulletin 3.8.2

6)

top - 1216 up 15:04, 1 user, load average: 0.02, 0.02, 0.00
Tasks: 54 total, 2 running, 50 sleeping, 0 stopped, 2 zombie
Cpu(s): 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 262160k total, 262160k used, 0k free, 0k buffers
Swap: 2737840k total, 4728k used, 2733112k free, 0k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1 root 18 0 1648 608 520 S 0.0 0.2 0:00.46 init
11995 nobody 18 0 46124 25m 13m S 0.0 9.9 0:08.92 httpd
16216 nobody 18 0 46532 24m 12m S 0.0 9.5 0:09.33 httpd
20392 nobody 15 0 45820 19m 9012 S 0.0 7.7 0:00.98 httpd
20416 nobody 15 0 45444 18m 8560 S 0.0 7.4 0:00.91 httpd
22228 root 15 0 6644 1944 1592 R 0.0 0.7 0:00.00 sshd
22327 root 17 0 2900 1236 972 S 0.0 0.5 0:00.00 login
22334 root 18 0 2176 1272 1032 S 0.0 0.5 0:00.00 bash
22396 root 15 0 5300 3864 2304 S 0.0 1.5 0:00.08 authProg
23801 nobody 15 0 45492 20m 9m S 0.0 8.2 0:02.22 httpd
23885 nobody 15 0 45576 22m 11m S 0.0 8.7 0:01.79 httpd
23886 nobody 15 0 45944 21m 10m S 0.0 8.4 0:02.78 httpd
24051 nobody 15 0 45836 22m 11m S 0.0 8.9 0:05.62 httpd
25632 root 18 0 1912 968 768 R 0.0 0.4 0:00.00 top
25661 root 16 0 0 0 0 Z 0.0 0.0 0:00.00 cpsrvd-ss
25688 root 17 0 17048 8332 1244 S 0.0 3.2 0:00.00 cpsrvd-ssl
25689 root 19 0 35352 32m 15m S 0.0 12.9 0:00.08 whostmgr2

top - 1230 up 15:04, 1 user, load average: 0.01, 0.02, 0.00

Tasks: 54 total, 1 running, 51 sleeping, 0 stopped, 2 zombie
Cpu0 : 0.4% us, 0.1% sy, 0.0% ni, 99.5% id, 0.1% wa, 0.0% hi, 0.0% si
Cpu1 : 0.4% us, 0.1% sy, 0.0% ni, 99.4% id, 0.1% wa, 0.0% hi, 0.0% si
Cpu2 : 0.3% us, 0.0% sy, 0.0% ni, 99.5% id, 0.1% wa, 0.0% hi, 0.0% si
Cpu3 : 0.3% us, 0.0% sy, 0.0% ni, 99.5% id, 0.1% wa, 0.0% hi, 0.0% si
Mem: 262160k total, 262160k used, 0k free, 0k buffers
Swap: 2737840k total, 4728k used, 2733112k free, 0k cached

7)

[mysqld]
#skip-name-resolve
safe-show-database
#old_passwords
back_log = 50
skip-innodb
max_connections = 500
key_buffer_size = 144M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 4000
thread_cache_size = 384
wait_timeout = 60
connect_timeout = 60
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
concurrent_insert = 2
"/etc/my.cnf" 51L, 1065C

MySQL Variables
Variable_name Value
auto_increment_increment 1
auto_increment_offset 1

automatic_sp_privileges ON
back_log 50
basedir /
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 2
connect_timeout 60
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
keep_files_on_create OFF
engine_condition_pushdown OFF
expire_logs_days 0
flush OFF
flush_time 0
ft_boolean_syntax + -> __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server Optimization Requst - Moved to new server	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	08-02-2009 10:30 AM
Web Server + DB Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-29-2009 08:30 PM
Web Server + DB Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-29-2009 08:20 PM
Server Optimization Request. First time optimization	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-08-2009 04:40 AM
Server Optimization Request - Please help! Server loads way too high!	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-05-2009 02:00 AM