- eudx2010-02-25论坛元老1159
主要DISCUZ用 其实和VPS 没啥关系。但这里优化数据库有经验的多 给点建议
为啥运行1-2天左右 MYSQL 进程会偶尔掉了呢?-- port=3306
- default-character-set=gbk
- port=3306
- basedir="G:/servers/mysql"
- datadir="G:/servers/mysql/Data/"
- default-character-set=gbk
- default-storage-engine=MYISAM
- sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
- max_connections=15000
- query_cache_size=52M
- table_cache=4100
- tmp_table_size=16M
- - thread_cache_size=64
- myisam_max_sort_file_size=100G
- myisam_max_extra_sort_file_size=100G
- myisam_sort_buffer_size=8M
- key_buffer_size=146M
- read_buffer_size=64K
- read_rnd_buffer_size=256K
- sort_buffer_size=208K
- skip-innodb
- innodb_additional_mem_pool_size=4M
- innodb_flush_log_at_trx_commit=1
- innodb_log_buffer_size=1M
- innodb_buffer_pool_size=47M
- innodb_log_file_size=24M
- innodb_thread_concurrency=8复制代码