server optimization request. thanks in advance
 

<div>1. Dedicated
2.
Quote:
Quad Core X3210 @ 2.13GHz
8gb RAM
250GB EIDE non raid
CENTOS 5.2 i686 standard
Apache/2.0.63
PHP Version 5.2.5
mysql 5.0.77
3. Version 3.7.3
4.
5.
6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top
Quote:
top - 21:30:16 up 3 days, 5:24, 1 user, load average: 1.35, 1.29, 1.24
Tasks: 288 total, 2 running, 286 sleeping, 0 stopped, 0 zombie
Cpu(s): 20.1%us, 1.3%sy, 0.1%ni, 77.3%id, 0.7%wa, 0.0%hi, 0.5%si, 0.0%st
Mem: 8313504k total, 8085384k used, 228120k free, 495040k buffers
Swap: 2040212k total, 5716k used, 2034496k free, 5269164k cached
i.e. after hitting 1

Quote:
top - 21:31:45 up 3 days, 5:25, 1 user, load average: 1.60, 1.41, 1.28
Tasks: 287 total, 4 running, 282 sleeping, 0 stopped, 1 zombie
Cpu0 : 15.4%us, 0.9%sy, 0.1%ni, 83.3%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 16.5%us, 1.0%sy, 0.1%ni, 82.2%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 16.3%us, 0.9%sy, 0.1%ni, 80.8%id, 1.7%wa, 0.0%hi, 0.2%si, 0.0%st
Cpu3 : 32.5%us, 2.3%sy, 0.0%ni, 63.0%id, 0.5%wa, 0.1%hi, 1.6%si, 0.0%st
Mem: 8313504k total, 8084896k used, 228608k free, 495248k buffers
Swap: 2040212k total, 5716k used, 2034496k free, 5267936k cached
7.
Quote:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
safe-show-database
old_passwords
back_log = 50
skip-innodb
max_connections = 500
key_buffer_size = 128M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 8000
thread_cache_size = 384
wait_timeout = 60
connect_timeout = 10
tmp_table_size = 128M
max_heap_table_size = 128M
max_allowed_packet = 128M
net_buffer_length = 16384
max_connect_errors = 100000
thread_concurrency = 8
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 2M
bulk_insert_buffer_size = 16M
query_cache_limit = 8M
query_cache_size = 256M
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]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 64M
[myisamchk]
key_buffer = 256M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysql.server]
user=mysql
8. MySQL stats from ssh telnet as root user type:

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