mysql5.0.51 my.ini配置求指点,数据库报错

"

服务器环境及配置 <span style=""line-height:1.5;font-size:10pt;"">MySQL 5.0.51 版本 apache2.2  w<span style=""line-height:1.5;font-size:10pt;"">indows 2008 32位主机 数据库表类型采用的是MyISAM

4核 4GB内存 内存目前使用情况600-800M

已经对程序进行了优化，当用户并发量大的时候（写入数据部分）出现apache CPU高涨，甚至有时候导致程序直接挂掉。

以下是my.in的配置，请点评。

[client]

port=3306

[mysql]

default-character-set = utf8

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306

#Path to installation directory. All paths are usually resolved relative to this.
basedir="E:\PROGRA~1\App/MySQL/"

#Path to the database root
datadir="E:\PROGRA~1\App/MySQL/data/"

default-character-set = utf8
character-set-server = utf8
collation-server = utf8_general_ci
init_connect = 'SET collation_connection = utf8_general_ci'
init_connect = 'SET NAMES utf8'


sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

max_connections=200
query_cache_size=64M
table_cache=512
tmp_table_size=64M
thread_cache_size=8
myisam_max_sort_file_size=10G
myisam_max_extra_sort_file_size=10G
myisam_sort_buffer_size=128M
key_buffer_size=32M
read_buffer_size=2M
read_rnd_buffer_size=16M
sort_buffer_size=8M
log-slow-queries=mysql-slow.log
log-error=mysql.err
skip-innodb
innodb_additional_mem_pool_size=16M
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=8M
innodb_buffer_pool_size=2G
innodb_log_file_size=256M
innodb_thread_concurrency=16