主要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复制代码