服务器系统是win2003,CPU是2.8双核,内存是4G,数据库500MB左右。运行discuz+uchome 一千多IP 三万多PV php做了eAccelerator+FastCGI还是感觉慢于是就想到了mysql
现在的my.ini是这样的[client]
port=3306
[mysql]
default-character-set=gbk
[mysqld]
port=3306
basedir="D:/MySQL/"
datadir="D:/MySQL/Data/"
default-character-set=gbk
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=1024
query_cache_size=73M
table_cache=500
tmp_table_size=17M
thread_cache_size=60
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=32M
key_buffer_size=800M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_data_home_dir="D:/MySQL Datafiles/"
innodb_additional_mem_pool_size=9M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=5M
innodb_buffer_pool_size=402M
innodb_log_file_size=81M
innodb_thread_concurrency=4
谢谢大家了