Optimization Request - Running FreeBSD 7.0-STABLE
 

<div>Hi, I'm running vBulletin with 30.000 active members daily, over 100.000 members registered.

I would like to ask a Server Optimization Request:<ol style="list-style-type: decimal">It's on Dedicated Server, but running WHM/cPanel to make Server Management easier.
Server Specification:
2 x Intel Xeon X5492 (8-Core), 3.4 GHz, FSB 1.600 MHz, Cache 24 MB
4 x 2 GB FB-DIMM 800 Mhz + ECC
2 x 160 GB HDD (RAID 1)
FreeBSD 7.0-STABLE
Intel Certified Server Board
Versions:

• Apache: 2.2.10
• PHP: 5.2.6
• MySQL: 5.0.67

vBulletin v3.8.2
I'm running MySQL 5.0.67
Compiled using WHM
TOP:
Code:
last pid: 4940; load averages: 1.23, 1.14, 1.07 up 103+03:17:20 10:39:36
454 processes: 4 running, 408 sleeping, 42 zombie
CPU states: 11.6% user, 0.0% nice, 6.1% system, 0.0% interrupt, 82.3% idle
Mem: 1434M Active, 3909M Inact, 543M Wired, 102M Cache, 214M Buf, 1838M Free
Swap: 4096M Total, 952K Used, 4095M Free
/etc/my.cnf:
Code:
[mysqld]
set-variable = max_connections=500
safe-show-database
mysqladmin -u root -p var ext stat ver proc output:
<div style="margin:20px; margin-top:5px"> Code:
vivoperdio# mysqladmin -u vbulletin -p var ext stat ver proc
Enter password:
+---------------------------------+----------------------------------------+
| Variable_name | Value |
+---------------------------------+----------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /usr/local/ |
| 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/local/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/db/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 | + ->