big board server optimization request
 

<div>1. using dedicated servers ( co-location in dc )

2.
SQL Server
HP SERVER
1xIntel Quad Xeon CPU E5405 2.0 GHZ 12MB L2, 1333 FSB
16 GB ECC DDR2 RAM
2X72 GB 10K RPM SCSI @ RAID 1
mysql 5.0.77-community

WEB Server -1
HP SERVER
1xIntel Quad Xeon CPU E5405 2.0 GHZ 12MB L2, 1333 FSB
14 GB ECC DDR2 RAM
2X146 GB 10K RPM SCSI @ RAID 0
apache 2.2.11
php 5.2.9
xcache 1.2.2

WEB Server - 2
HP SERVER
1xIntel Quad Xeon CPU E5420 2.5 GHZ 12 MB L2, 1333 FSB
10 GB ECC DDR2 RAM
3X 146 GB 10K RPM SCSI ( RAID 5 ) But forum's public html directory mounted from web server -1

apache 2.2.11
php 5.2.9
xcache 1.2.2


WEB SERVERS UNDER LOAD BALANCING ( 45% - 55% )

(I was running on litespeed web server and i have licences but, xcache doesnt work right with litespeed. everytime resetting caches ... i need caching for some addons .. )

3.
VBULLETIN 3.8.2

4.
NO INNODB

5.
Installed with directadmin panel then later we upgraded to latest version

6.
SQL SERVER / TOP

Code:
top - 16:26:31 up 18 days, 16:29, 1 user, load average: 3.16, 8.68, 10.36
Tasks: 141 total, 3 running, 138 sleeping, 0 stopped, 0 zombie
Cpu0 : 12.3%us, 5.0%sy, 0.0%ni, 4.0%id, 0.0%wa, 77.7%hi, 1.0%si, 0.0%st
Cpu1 : 52.0%us, 22.2%sy, 0.0%ni, 25.2%id, 0.3%wa, 0.0%hi, 0.3%si, 0.0%st
Cpu2 : 35.2%us, 13.0%sy, 0.0%ni, 51.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 27.2%us, 10.6%sy, 0.0%ni, 61.6%id, 0.3%wa, 0.0%hi, 0.3%si, 0.0%st
Mem: 16442448k total, 15707344k used, 735104k free, 307480k buffers
Swap: 2031608k total, 120k used, 2031488k free, 11889908k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
29578 mysql 5 -10 3414m 2.3g 4456 S 246.6 14.6 38160:33 mysqld
4328 root 15 0 12736 1124 812 R 0.7 0.0 0:00.27 top
3699 root 15 0 88080 3324 2608 R 0.3 0.0 0:00.05 sshd
1 root 15 0 10344 636 544 S 0.0 0.0 0:18.81 init
2 root RT -5 0 0 0 S 0.0 0.0 0:02.03 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:02.57 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.10 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.90 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.37 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0.0 0.0 0:00.43 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:00.31 ksoftirqd/2
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0.0 0.0 0:00.79 migration/3
WEB SERVER 1 / TOP
Code:
top - 16:26:43 up 9 days, 2:15, 1 user, load average: 22.65, 17.52, 13.18
Tasks: 380 total, 32 running, 347 sleeping, 0 stopped, 1 zombie
Cpu(s): 91.9%us, 2.2%sy, 0.0%ni, 4.3%id, 0.1%wa, 0.0%hi, 1.4%si, 0.0%st
Mem: 14373968k total, 10390436k used, 3983532k free, 186760k buffers
Swap: 2031608k total, 112k used, 2031496k free, 6050056k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1685 apache 15 0 619m 34m 15m S 34.3 0.2 0:03.21 httpd
1541 apache 15 0 620m 35m 14m S 33.9 0.3 0:06.18 httpd
1965 apache 15 0 615m 27m 12m S 33.4 0.2 0:01.66 httpd
1561 apache 15 0 623m 36m 14m R 31.9 0.3 0:04.49 httpd
1728 apache 15 0 623m 35m 13m S 27.0 0.3 0:02.99 httpd
1853 apache 15 0 622m 34m 12m S 27.0 0.2 0:01.43 httpd
1365 apache 16 0 619m 34m 15m R 19.1 0.2 0:11.66 httpd
1717 apache 15 0 618m 94m 75m S 18.6 0.7 0:03.12 httpd
1863 apache 15 0 621m 34m 13m S 16.7 0.2 0:02.08 httpd
1680 apache 15 0 623m 38m 15m S 16.2 0.3 0:03.09 httpd
1859 apache 16 0 624m 37m 13m R 15.2 0.3 0:01.79 httpd
1942 apache 15 0 617m 29m 12m S 14.7 0.2 0:01.22 httpd
1519 apache 15 0 617m 32m 15m S 13.2 0.2 0:07.90 httpd
1737 apache 15 0 615m 29m 14m S 10.8 0.2 0:03.08 httpd
1820 apache 15 0 617m 29m 13m S 10.8 0.2 0:01.37 httpd
1550 apache 16 0 621m 36m 15m R 9.3 0.3 0:05.44 httpd
1010 apache 15 0 617m 36m 19m S 7.4 0.3 0:21.25 httpd
WEB SERVER - 2 / TOP
Code:
top - 16:35:17 up 9 days, 13:40, 2 users, load average: 10.38, 11.12, 10.91
Tasks: 472 total, 9 running, 463 sleeping, 0 stopped, 0 zombie
Cpu0 : 43.8%us, 3.4%sy, 0.0%ni, 50.3%id, 0.1%wa, 0.0%hi, 2.5%si, 0.0%st
Cpu1 : 26.6%us, 1.8%sy, 0.0%ni, 71.2%id, 0.1%wa, 0.2%hi, 0.1%si, 0.0%st
Cpu2 : 31.4%us, 1.7%sy, 0.0%ni, 66.7%id, 0.1%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu3 : 29.6%us, 1.9%sy, 0.0%ni, 68.3%id, 0.1%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 10233440k total, 6921336k used, 3312104k free, 59516k buffers
Swap: 2031608k total, 78888k used, 1952720k free, 1311108k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5605 apache 16 0 622m 35m 13m S 24.3 0.4 0:01.08 httpd
5879 apache 16 0 622m 32m 11m R 24.3 0.3 0:00.33 httpd
5889 apache 16 0 622m 32m 11m R 23.1 0.3 0:00.31 httpd
5872 apache 16 0 622m 34m 12m R 22.0 0.3 0:00.44 httpd
5753 apache 16 0 623m 39m 15m R 19.6 0.4 0:02.08 httpd
5916 apache 16 0 617m 27m 10m R 18.5 0.3 0:00.35 httpd
5795 apache 16 0 622m 35m 13m R 17.3 0.4 0:00.69 httpd
3167 apache 15 0 616m 33m 17m S 13.9 0.3 0:02.99 httpd
5798 apache 15 0 614m 26m 11m S 13.9 0.3 0:00.61 httpd
3226 apache 15 0 615m 31m 15m S 12.7 0.3 0:05.62 httpd
5909 apache 15 0 615m 24m 9324 S 12.7 0.2 0:00.16 httpd
5811 apache 15 0 615m 25m 9m S 11.6 0.3 0:00.20 httpd
5663 apache 15 0 615m 28m 13m S 10.4 0.3 0:00.67 httpd
5737 apache 15 0 622m 35m 13m S 10.4 0.4 0:00.60 httpd
7.
Code:
[mysqld]
log-bin = /var/log/mysql/mysql-bin.log
binlog-do-db = db2


relay-log = /var/lib/mysql/slave-relay.log
relay-log-index = /var/lib/mysql/slave-relay-log.index

expire_logs_days = 10
max_binlog_size = 500M

safe-show-database
#old_passwords
back_log = 50
skip-innodb
max_connections = 900
key_buffer_size = 950M
myisam_sort_buffer_size = 64M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 2M
table_cache = 8000
thread_cache_size = 256
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 256M
max_heap_table_size = 256M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 8
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 16M
query_cache_limit = 6M
query_cache_size = 512M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_write_lock_count = 16
default-character-set=utf8
default-collation=utf8_turkish_ci
ft_min_word_len=2

[mysqld_safe]
nice = -10
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 256M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
ft_min_word_len=2
8.
<div style="margin:20px; margin-top:5px"> Code:
auto_increment_increment: 1
auto_increment_offset: 1
automatic_sp_privileges: ON
back_log: 50
basedir: /
binlog_cache_size: 32768
bulk_insert_buffer_size: 16777216
character_set_client: latin1
character_set_connection: latin1
character_set_database: latin1
character_set_filesystem: binary
character_set_results: latin1
character_set_server: utf8
character_set_system: utf8
character_sets_dir: /usr/share/mysql/charsets/
collation_connection: latin1_swedish_ci
collation_database: latin1_swedish_ci
collation_server: utf8_turkish_ci
completion_type: 0
concurrent_insert: 2
connect_timeout: 10
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: 10
flush: OFF
flush_time: 0
ft_boolean_syntax: + ->