Server Optimization Request - Dual Xeon 5530
 

<div>I'm not sure if this makes a difference but the info below was collected just after moving on to the server at a very quiet time (not sure if that has a bearing).

1. Quote:
Dedicated server
2.

Quote:
Dual Xeon 5530 (HT 2.4 ghz)(quad core)
3 x 146gb:scsi:10krpm 146gb (raid 5)
6gb ddr3 1333 ecc
whm/cpanel
rhel 5.3 64bit
apache v2.2.11
mysql 5.0.67-community
php 5.2.9
3.
Quote:
currently:
Vbulletin 3.7.5 patch level 1
but upgrading to latest in the next 7 days(ish)
4. Quote:
No innodb

5.
Quote:
mysql installed via whm/cpanel
6.

Quote:
root@server [~]# top
top - 23:01:35 up 3:04, 1 user, load average: 0.42, 0.30, 0.28
tasks: 246 total, 1 running, 244 sleeping, 0 stopped, 1 zombie
cpu(s): 0.6%us, 0.0%sy, 0.0%ni, 99.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
mem: 6099940k total, 2257964k used, 3841976k free, 120228k buffers
swap: 2040212k total, 0k used, 2040212k free, 1664092k cached

Quote:
root@server [~]# top
top - 23:03:22 up 3:06, 1 user, load average: 0.23, 0.27, 0.26
tasks: 247 total, 1 running, 246 sleeping, 0 stopped, 0 zombie
cpu0 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu1 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu3 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu4 : 2.3%us, 0.7%sy, 0.0%ni, 97.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu5 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu6 : 9.0%us, 0.3%sy, 0.0%ni, 90.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu7 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu8 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu9 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu10 : 0.3%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu11 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu12 : 8.3%us, 0.3%sy, 0.0%ni, 91.0%id, 0.3%wa, 0.0%hi, 0.0%si, 0.0%st
cpu13 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu14 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
cpu15 : 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: 6099940k total, 2323896k used, 3776044k free, 120992k buffers
swap: 2040212k total, 0k used, 2040212k free, 1665580k cached

7.

Quote:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
Old_passwords=1
#skip-name-resolve
safe-show-database
old_passwords
back_log = 50
skip-innodb
max_connections = 500
key_buffer_size = 144m
myisam_sort_buffer_size = 64m
join_buffer_size = 1m
read_buffer_size = 1m
sort_buffer_size = 2m
table_cache = 4000
thread_cache_size = 384
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 64m
max_heap_table_size = 64m
max_allowed_packet = 64m
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 = 8m
query_cache_limit = 4m
query_cache_size = 128m
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

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -10
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16m

[myisamchk]
key_buffer = 128m
sort_buffer = 64m
read_buffer = 16m
write_buffer = 16m
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 | 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 | 0 |
| flush | off |
| flush_time | 0 |
| ft_boolean_syntax | + ->