I'm after a server format, Server optimisation request.
 

<div>I have a dedicated server -
Dual Quad Core E5405 @ 2.00GHz ("8" processors)
6 GB RAM
Centos 5.x (I think it's 5.2)
Apache 1.3.41 Running
DirectAdmin 1.33.7 Running
Exim 4.67 Running
MySQL 5.0.67 Running
Named 9.3.4 Running
ProFTPd 1.3.1 Running
sshd Running
dovecot 1.2.0 Running

I'm using VB 3.8.2

TOP -
top - 16:33:45 up 11:08, 3 users, load average: 4.59, 4.38, 5.27
Tasks: 269 total, 2 running, 266 sleeping, 0 stopped, 1 zombie
Cpu(s): 14.0%us, 1.4%sy, 0.0%ni, 82.2%id, 2.3%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 6232628k total, 2757004k used, 3475624k free, 50332k buffers
Swap: 4192956k total, 76k used, 4192880k free, 1469068k cached

TOP after hitting 1 -

Tasks: 295 total, 8 running, 287 sleeping, 0 stopped, 0 zombie
Cpu0 : 8.2%us, 1.8%sy, 0.0%ni, 80.0%id, 10.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 9.5%us, 1.9%sy, 0.0%ni, 78.5%id, 10.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 4.9%us, 1.4%sy, 0.0%ni, 92.3%id, 1.4%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 38.8%us, 13.2%sy, 0.0%ni, 42.6%id, 4.7%wa, 0.0%hi, 0.7%si, 0.0%st
Cpu4 : 8.9%us, 1.6%sy, 0.0%ni, 88.1%id, 1.4%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 11.0%us, 1.8%sy, 0.0%ni, 85.6%id, 1.6%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 8.6%us, 1.6%sy, 0.0%ni, 87.3%id, 2.4%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 10.1%us, 1.8%sy, 0.0%ni, 85.7%id, 2.3%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 6232628k total, 2856008k used, 3376620k free, 50400k buffers
Swap: 4192956k total, 76k used, 4192880k free, 1470624k cached

my.cnf > (just the var's)

Mysql Status from Admicp

Code:
MySQL Variable_name Value Aborted_clients 37 Aborted_connects 416 Binlog_cache_disk_use 0 Binlog_cache_use 0 Bytes_received 1027786116 Bytes_sent 1546708341 Com_admin_commands 0 Com_alter_db 0 Com_alter_table 0 Com_analyze 0 Com_backup_table 0 Com_begin 0 Com_call_procedure 0 Com_change_db 200306 Com_change_master 0 Com_check 0 Com_checksum 0 Com_commit 0 Com_create_db 0 Com_create_function 0 Com_create_index 0 Com_create_table 44 Com_create_user 0 Com_dealloc_sql 0 Com_delete 11956 Com_delete_multi 0 Com_do 0 Com_drop_db 0 Com_drop_function 0 Com_drop_index 0 Com_drop_table 44 Com_drop_user 0 Com_execute_sql 0 Com_flush 1 Com_grant 0 Com_ha_close 0 Com_ha_open 0 Com_ha_read 0 Com_help 0 Com_insert 92799 Com_insert_select 44 Com_kill 0 Com_load 0 Com_load_master_data 0 Com_load_master_table 0 Com_lock_tables 0 Com_optimize 0 Com_preload_keys 0 Com_prepare_sql 0 Com_purge 0 Com_purge_before_date 0 Com_rename_table 0 Com_repair 0 Com_replace 10803 Com_replace_select 0 Com_reset 0 Com_restore_table 0 Com_revoke 0 Com_revoke_all 0 Com_rollback 0 Com_savepoint 0 Com_select 1610797 Com_set_option 186897 Com_show_binlog_events 0 Com_show_binlogs 2 Com_show_charsets 1 Com_show_collations 1 Com_show_column_types 0 Com_show_create_db 0 Com_show_create_table 0 Com_show_databases 5 Com_show_errors 0 Com_show_fields 579 Com_show_grants 1 Com_show_innodb_status 0 Com_show_keys 2 Com_show_logs 0 Com_show_master_status 0 Com_show_ndb_status 0 Com_show_new_master 0 Com_show_open_tables 0 Com_show_privileges 0 Com_show_processlist 3 Com_show_slave_hosts 0 Com_show_slave_status 0 Com_show_status 10 Com_show_storage_engines 0 Com_show_tables 60 Com_show_triggers 0 Com_show_variables 30 Com_show_warnings 0 Com_slave_start 0 Com_slave_stop 0 Com_stmt_close 0 Com_stmt_execute 0 Com_stmt_fetch 0 Com_stmt_prepare 0 Com_stmt_reset 0 Com_stmt_send_long_data 0 Com_truncate 52 Com_unlock_tables 0 Com_update 252804 Com_update_multi 44 Com_xa_commit 0 Com_xa_end 0 Com_xa_prepare 0 Com_xa_recover 0 Com_xa_rollback 0 Com_xa_start 0 Compression OFF Connections 200725 Created_tmp_disk_tables 10678 Created_tmp_files 7254 Created_tmp_tables 78879 Delayed_errors 0 Delayed_insert_threads 0 Delayed_writes 0 Flush_commands 1 Handler_commit 0 Handler_delete 27730 Handler_discover 0 Handler_prepare 0 Handler_read_first 155684 Handler_read_key 33092535 Handler_read_next 290258306 Handler_read_prev 1850255 Handler_read_rnd 2292669 Handler_read_rnd_next 3957511003 Handler_rollback 0 Handler_savepoint 0 Handler_savepoint_rollback 0 Handler_update 433870 Handler_write 1492872 Innodb_buffer_pool_pages_data 20 Innodb_buffer_pool_pages_dirty 0 Innodb_buffer_pool_pages_flushed 0 Innodb_buffer_pool_pages_free 492 Innodb_buffer_pool_pages_latched 0 Innodb_buffer_pool_pages_misc 0 Innodb_buffer_pool_pages_total 512 Innodb_buffer_pool_read_ahead_rnd 1 Innodb_buffer_pool_read_ahead_seq 0 Innodb_buffer_pool_read_requests 153 Innodb_buffer_pool_reads 13 Innodb_buffer_pool_wait_free 0 Innodb_buffer_pool_write_requests 0 Innodb_data_fsyncs 3 Innodb_data_pending_fsyncs 0 Innodb_data_pending_reads 0 Innodb_data_pending_writes 0 Innodb_data_read 2510848 Innodb_data_reads 26 Innodb_data_writes 3 Innodb_data_written 1536 Innodb_dblwr_pages_written 0 Innodb_dblwr_writes 0 Innodb_log_waits 0 Innodb_log_write_requests 0 Innodb_log_writes 1 Innodb_os_log_fsyncs 3 Innodb_os_log_pending_fsyncs 0 Innodb_os_log_pending_writes 0 Innodb_os_log_written 512 Innodb_page_size 16384 Innodb_pages_created 0 Innodb_pages_read 20 Innodb_pages_written 0 Innodb_row_lock_current_waits 0 Innodb_row_lock_time 0 Innodb_row_lock_time_avg 0 Innodb_row_lock_time_max 0 Innodb_row_lock_waits 0 Innodb_rows_deleted 0 Innodb_rows_inserted 0 Innodb_rows_read 0 Innodb_rows_updated 0 Key_blocks_not_flushed 0 Key_blocks_unused 1866270 Key_blocks_used 233210 Key_read_requests 145232941 Key_reads 375135 Key_write_requests 346409 Key_writes 218110 Last_query_cost 0.000000 Max_used_connections 101 Ndb_cluster_node_id 0 Ndb_config_from_host Ndb_config_from_port 0 Ndb_number_of_data_nodes 0 Not_flushed_delayed_rows 0 Open_files 411 Open_streams 0 Open_tables 256 Opened_tables 30962 Prepared_stmt_count 0 Qcache_free_blocks 466 Qcache_free_memory 3035936 Qcache_hits 1057085 Qcache_inserts 1470034 Qcache_lowmem_prunes 169881 Qcache_not_cached 141458 Qcache_queries_in_cache 653 Qcache_total_blocks 2408 Questions 3624370 Rpl_status NULL Select_full_join 6314 Select_full_range_join 0 Select_range 445881 Select_range_check 0 Select_scan 146476 Slave_open_temp_tables 0 Slave_retried_transactions 0 Slave_running OFF Slow_launch_threads 0 Slow_queries 290 Sort_merge_passes 3712 Sort_range 205960 Sort_rows 16839286 Sort_scan 73231 Table_locks_immediate 4463090 Table_locks_waited 17815 Tc_log_max_pages_used 0 Tc_log_page_size 0 Tc_log_page_waits 0 Threads_cached 6 Threads_connected 2 Threads_created 1173 Threads_running 1 Uptime 41445 Uptime_since_flush_status


Code:
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 24M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
myisam_max_sort_file_size = 200048MB
myisam_max_extra_sort_file_size = 200048MB
myisam_data_pointer_size = 200048MB
key_buffer = 200048MB
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 16

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 1200008M
sort_buffer_size = 100028M
read_buffer = 200M
write_buffer = 200M

[myisamchk]
key_buffer = 12000008M
sort_buffer_size = 1000028M
read_buffer = 200M
write_buffer = 200M

[mysqlhotcopy]
interactive-timeout
mysqladmin -u root -p var ext stat ver proc

<div style="margin:20px; margin-top:5px"> Code:
+---------------------------------+------------------------------------+
| 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 | + ->