只需一步,快速开始
[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配置 最近网站经常卡死 而且进服务器异常的慢 请高手帮忙看下配置是否存在严重问题
[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
使用道具 举报
本版积分规则 发表回复 回帖后跳转到最后一页
手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )
GMT+8, 2024-12-25 12:48 , Processed in 0.026916 second(s), 5 queries , Gzip On, Redis On.
Powered by Discuz! X3.4
Copyright © 2001-2023, Tencent Cloud.