MYSQL优化寻指点

webyang

[client]
port=3306

serverid = 1
#socket = /tmp/mysql.sock
#skip-locking
#skip-name-resolve
#back_log = 384

[mysql]
default-character-set=gbk
[mysqld]
port=3306
basedir="E:/Program Files/php_iis/MySQL545/"
datadir="E:/Program Files/php_iis/MySQL545/Data/"
default-character-set=gbk
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=32M
table_cache = 256
tmp_table_size=64M
thread_cache_size=64
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=64M

key_buffer_size=128M
read_buffer_size=2M

read_rnd_buffer_size=185K
sort_buffer_size = 6M

innodb_additional_mem_pool_size=4M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=2M
innodb_buffer_pool_size=8M
innodb_log_file_size=10M
innodb_thread_concurrency=8

max_allowed_packet = 4M
thread_stack = 256K

join_buffer_size = 2M

max_connect_errors = 10000000
wait_timeout = 5
thread_concurrency = 4

#skip-networking

4G 4核 windows 2003 MYSQL配置 最近网站经常卡死 而且进服务器异常的慢 请高手帮忙看下配置是否存在严重问题

kider

看你默认用的innodb表引擎，也不知道表真正都用的什么引擎。
如果是InnoDB的话，那么innodb_buffer_pool_size=8M 此值设置太小了。可以调到2G左右试试...

max_connect_errors = 100 即可