各位老大，请帮我优化下配置参数

dulcet

各位老大，请帮我优化下配置参数
服务器 8G内存  两颗8核至强CPU
       CentOS 5.4  MYSQL 5.0.45
这个服务器为mysql的专用服务器
现在web同时有200-300人访问，是一个企业的内部系统
表全部是MYSIAM类型 现在的配置如下，请老大们帮我优化下，尽可能的利用上现在的服务器资源，谢谢先

[client]
port                = 3306
socket                = /opt/lampp/var/mysql/mysql.sock
default-character-set=UTF8

[mysqld]
port                = 3306
socket                = /opt/lampp/var/mysql/mysql.sock
skip-locking
key_buffer = 2048M
max_allowed_packet = 16M
table_cache = 1024
sort_buffer_size = 32M
net_buffer_length = 8K
read_buffer_size = 32M
read_rnd_buffer_size = 64M
myisam_sort_buffer_size = 256M
query_cache_size=128M
thread_cache_size=512
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
default-character-set=UTF8

log-slow-queries=/opt/lampp/logs/mysql/slowquery.log
long_query_time=2
server-id        = 1
skip-innodb
innodb_data_home_dir = /opt/lampp/var/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/lampp/var/mysql/
innodb_log_arch_dir = /opt/lampp/var/mysql/

innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M

innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

xiao7ng

sort_buffer_size = 32M
net_buffer_length = 8K
read_buffer_size = 32M
read_rnd_buffer_size = 64M上面几个都是线程独享的,觉得好大啊!
myisam_sort_buffer_size = 256M除非你经常修改表,要不觉得没必要
query_cache_size=128M不知道需求不好评论
thread_cache_size=512有点太大了
当然具体的,的根据业务需求来设置,以上,抛砖引玉,不当之处,海涵,哈哈
还有就是,没有innodb的话,直接skip-innodb

dulcet

谢谢楼上兄弟，看来这东西不能偷懒呀，还得慢慢研究了