Server Optimisation Request

محروم.كوم · #1 04-30-2009, 03:40 AM

Hi there! I'm hoping you can find a bit of time to suggest how to optimise my new server..! Thanks in advance and here's the information you need:

1. Dedicated. There are other vB installations on the server - but none of them with anywhere near the level of traffic that our primary domain receives.

2. Web Server: Intel i7 Eight Core, 12GB DDR3 RAM, 2 x 10k RPM 250GB SSD RAID, CentOS 5.3 64-Bit, Apache 2.2.3, PHP 5.2.9 and MySQL 5.1.34.

3. vBulletin 3.8.2.

4. The 'thread' and 'user' tables in the database use InnoDB. With the exception of 'session' and 'cpsession' which are MEMORY driven, the rest are MyISAM tables.

5. As an external module.

6. Top stats:
Code:
top - 14:56:49 up 7:06, 1 user, load average: 6.19, 9.68, 13.66
Tasks: 521 total, 1 running, 519 sleeping, 0 stopped, 1 zombie
Cpu(s): 1.6%us, 0.3%sy, 0.0%ni, 65.2%id, 32.8%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 12302248k total, 8300200k used, 4002048k free, 90848k buffers
Swap: 8385920k total, 161216k used, 8224704k free, 3445000k cached
Code:
top - 14:58:04 up 7:07, 1 user, load average: 4.99, 8.61, 12.98
Tasks: 574 total, 1 running, 573 sleeping, 0 stopped, 0 zombie
Cpu0 : 20.7%us, 2.0%sy, 0.0%ni, 0.0%id, 75.7%wa, 0.3%hi, 1.3%si, 0.0%st
Cpu1 : 11.6%us, 0.3%sy, 0.0%ni, 85.1%id, 3.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 8.7%us, 0.3%sy, 0.0%ni, 91.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 5.3%us, 0.3%sy, 0.0%ni, 94.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st

Cpu4 : 9.3%us, 0.7%sy, 0.0%ni, 90.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 9.3%us, 0.3%sy, 0.0%ni, 58.8%id, 31.6%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 10.7%us, 1.0%sy, 0.0%ni, 88.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 43.3%us, 0.3%sy, 0.0%ni, 56.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 12302248k total, 8726424k used, 3575824k free, 91388k buffers
Swap: 8385920k total, 161216k used, 8224704k free, 3491796k cached
7. my.cnf Contents:
Code:
[mysqld]
user = mysql
port = 3306
skip-name-resolve
skip-host-cache
safe-show-database
old_passwords
back_log = 75
max_connections = 2048
key_buffer = 128M
myisam_sort_buffer_size = 128M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 256M
max_heap_table_size = 256M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 8M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM
thread_concurrency = 16
innodb_buffer_pool_size = 80M

#innodb_file_per_table=1
#innodb_data_file_path=ibdata1:1G:autoextend:max:2 G
#innodb_additional_mem_pool_size=10M
#innodb_log_file_size=20M
#innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_thread_concurrency=8
#innodb_status_file=1
#innodb_buffer_pool_size=256M
#innodb_open_files=300

[mysqld_safe] __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server Optimisation Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-23-2009 12:22 PM
Server Optimisation Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-06-2009 07:10 PM
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