Server Optimization Request
 

<div>1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)

Dedicated

2. your server specs.

Dual Xeon E5405 Quad Core (Harpertown)
8GB memory
Dual 1TB SATA / Hardware Raid 1 Drives
Centos 5 64 bit
Apache 2.2
PHP 5.29
MySQL 5.067

3. what version of vB are you running ?

3.75

4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?

N/A

5. if possible how mysql was compiled/installed

cPanel.

6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top

top - 21:28:27 up 86 days, 18:54, 4 users, load average: 2.96, 3.70, 4.07
Tasks: 266 total, 4 running, 262 sleeping, 0 stopped, 0 zombie
Cpu0 : 25.2%us, 0.7%sy, 0.0%ni, 74.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 25.5%us, 2.3%sy, 0.0%ni, 65.2%id, 6.6%wa, 0.0%hi, 0.3%si, 0.0%st
Cpu2 : 31.6%us, 2.3%sy, 0.0%ni, 66.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 25.3%us, 2.3%sy, 0.0%ni, 72.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 25.2%us, 1.0%sy, 0.0%ni, 73.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 21.7%us, 1.7%sy, 0.0%ni, 76.0%id, 0.7%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 14.0%us, 2.3%sy, 0.0%ni, 83.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 38.7%us, 11.3%sy, 0.0%ni, 47.0%id, 0.0%wa, 0.7%hi, 2.3%si, 0.0%st
Mem: 8174408k total, 6340956k used, 1833452k free, 78940k buffers
Swap: 8385920k total, 375540k used, 8010380k free, 3543824k cached

7. your mysql configuration variables located at /etc/my.cnf

[mysqld]
skip-name-resolve
safe-show-database
#old_passwords
back_log = 50
skip-innodb
max_connections = 500
key_buffer_size = 96M
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 = 30
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 100000
thread_concurrency = 8
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 64M
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 = 4

[mysqld_safe]
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. MySQL stats from ssh telnet

+---------------------------------+-------------------------------------------+
| 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 | + ->