Server Optimisation Request
 

<div>1. The vBulletin site is on a dedicated web server.
2. My Server Specs:

Intel DualCore 2 2.33Ghz (XEON?)
2GB RAM Installed
250GB Hard Disk
CentOS 5.3
Apache 2.2.11
PHP version: 5.2.9
MySQL version: mysql 5.0.77

3. I am running vB 3.8.2
4. I am running the latest version on MySQL - no innodb tables
5. MySQL was compiled by cPanel
6. Here are my top stats:
<div align="left"> Quote:
top - 16:47:51 up 1 day, 4:41, 1 user, load average: 0.03, 0.04, 0.00
Tasks: 128 total, 1 running, 127 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 2065320k total, 1779876k used, 285444k free, 458608k buffers
Swap: 4192924k total, 0k used, 4192924k free, 1050020k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1 root 15 0 2064 592 512 S 0.0 0.0 0:00.82 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.02 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 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:00.02 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0
9 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/1
10 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khelper
11 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
15 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 kblockd/0
16 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 kblockd/1
17 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
112 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/0
113 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/1
116 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khubd
118 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
184 root 19 0 0 0 0 S 0.0 0.0 0:00.00 pdflush
185 root 15 0 0 0 0 S 0.0 0.0 0:00.26 pdflush
186 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 kswapd0
187 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
188 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 aio/1
342 root 12 -5 0 0 0 S 0.0 0.0 0:00.00 kpsmoused
373 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 ata/0
374 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 ata/1
375 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 ata_aux
379 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
380 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
387 root 12 -5 0 0 0 S 0.0 0.0 0:00.00 kstriped
400 root 10 -5 0 0 0 S 0.0 0.0 0:00.28 kjournald
427 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 kauditd
461 root 21 -4 2248 660 404 S 0.0 0.0 0:00.05 udevd
CPU Load analysis:
Quote:
Cpu0 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 1.7%us, 0.0%sy, 0.0%ni, 98.0%id, 0.0%wa, 0.3%hi, 0.0%si, 0.0%st
7. my.cnf contents:
Quote:
[mysqld]
set-variable = max_connections=500
safe-show-database
8. <div style="margin:20px; margin-top:5px; "> Quote:
+---------------------------------+----------------------------------------+
| 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 | 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 | + ->