Server Optimization Request (Dedicated)
 

<div>1.
Quote:
Dedicated server
2.
Quote:
cpu speed/type single or dual cpus): x3220 quad core 2.40GHz
how much memory installed: 4096mb ram
hard drive type/configuration: 320GB RAID1
linux distributor or windows version: centos5 64bits
apache/IIS version: Apache v2.2.11
PHP version: php 5.2.9
MySQL version: 5.0.77-community
3.
Quote:
vBulletin 3.8.0
4.
Quote:
no innodb tables
5.
Quote:
mysql installed via whm/cpanel
6.
Quote:
op - 17:07:09 up 10 days, 23:25, 1 user, load average: 2.26, 2.28, 2.36
Tasks: 166 total, 1 running, 165 sleeping, 0 stopped, 0 zombie
Cpu(s): 47.3%us, 26.3%sy, 0.0%ni, 25.8%id, 0.0%wa, 0.5%hi, 0.0%si, 0.0%st
Mem: 4038100k total, 2459972k used, 1578128k free, 272884k buffers
Swap: 2096472k total, 104k used, 2096368k free, 1482468k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25410 mysql 16 0 380m 71m 5480 S 281.5 1.8 15368:20 mysqld
15605 nobody 15 0 214m 22m 9196 S 3.7 0.6 0:00.20 httpd
15445 nobody 16 0 214m 21m 9252 S 2.7 0.5 0:00.11 httpd
15444 nobody 16 0 212m 20m 9212 S 2.0 0.5 0:00.20 httpd
15073 nobody 15 0 214m 23m 10m S 1.7 0.6 0:00.57 httpd
15541 nobody 15 0 209m 17m 8980 S 1.7 0.4 0:00.09 httpd
15551 nobody 15 0 214m 22m 9628 S 1.7 0.6 0:00.20 httpd
15717 root 15 0 12736 1144 808 R 0.7 0.0 0:00.05 top
1 root 15 0 10344 640 544 S 0.0 0.0 0:04.72 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.70 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.04 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:08.53 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.32 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.42 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:00.12 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.41 migration/3
12 root 34 19 0 0 0 S 0.0 0.0 0:00.13 ksoftirqd/3
13 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/3
14 root 10 -5 0 0 0 S 0.0 0.0 0:01.06 events/0
15 root 10 -5 0 0 0 S 0.0 0.0 1:26.78 events/1
16 root 10 -5 0 0 0 S 0.0 0.0 0:00.02 events/2
17 root 10 -5 0 0 0 S 0.0 0.0 0:00.06 events/3
18 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khelper
57 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
64 root 10 -5 0 0 0 S 0.0 0.0 0:03.94 kblockd/0
65 root 10 -5 0 0 0 S 0.0 0.0 0:06.23 kblockd/1
66 root 10 -5 0 0 0 S 0.0 0.0 0:03.43 kblockd/2
67 root 10 -5 0 0 0 S 0.0 0.0 0:00.72 kblockd/3
68 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
178 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/0
179 root 17 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/1
180 root 17 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/2
181 root 18 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/3
184 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khubd
186 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
273 root 10 -5 0 0 0 S 0.0 0.0 0:04.94 kswapd0
274 root 17 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
275 root 17 -5 0 0 0 S 0.0 0.0 0:00.00 aio/1

Quote:
top - 16:32:09 up 10 days, 22:50, 1 user, load average: 2.29, 1.94, 1.91
Tasks: 158 total, 2 running, 156 sleeping, 0 stopped, 0 zombie
Cpu0 : 17.8%us, 7.7%sy, 0.0%ni, 74.3%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 18.6%us, 8.7%sy, 0.0%ni, 71.5%id, 0.2%wa, 0.9%hi, 0.1%si, 0.0%st
Cpu2 : 24.6%us, 11.3%sy, 0.0%ni, 63.9%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 13.2%us, 4.5%sy, 0.0%ni, 81.7%id, 0.3%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 4038100k total, 2263536k used, 1774564k free, 246520k buffers
Swap: 2096472k total, 104k used, 2096368k free, 1471664k cached
7.
Quote:
[mysqld]
set-variable = max_connections=500
safe-show-database
8.
<div style="margin:20px; margin-top:5px; "> Quote:
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 1
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 0
flush OFF
flush_time 0
ft_boolean_syntax + ->