MySQL社区

标题: 经过高手优化的MySQL数据库实例 [打印本页]

作者: kider 时间: 2008-8-14 17:21
标题: 经过高手优化的MySQL数据库实例
　　据说这是高手优化的MySQL,供大家参考,其中连接数: max_connections=1500可以根据服务器的性能更改.

#set-variable = connect_timeout=5
#set-variable = wait_timeout=5

　　建议启用,负担重的服务器可以适当减少持续连接时间
　

　[mysqld]
　　basedir=D:/mysql
　　#bind-address=ip
　　datadir=D:/mysql/data
　　#language=D:/mysql/share/your language directory
　　#slow query log#=
　　#tmpdir#=
　　#port=3306
　　set-variable = max_connections=1500
　　skip-locking
　　#skip-networking
　　set-variable = key_buffer=384M
　　set-variable = max_allowed_packet=1M
　　set-variable = table_cache=512
　　set-variable = sort_buffer=2M
　　set-variable = record_buffer=2M
　　set-variable = thread_cache=8
　　# Try number of CPU's*2 for thread_concurrency
　　set-variable = thread_concurrency=8
　　set-variable = myisam_sort_buffer_size=64M
　　#set-variable = connect_timeout=5
　　#set-variable = wait_timeout=5
　　server-id = 1
　　[isamchk]
　　set-variable = key_buffer=128M
　　set-variable = sort_buffer=128M
　　set-variable = read_buffer=2M
　　set-variable = write_buffer=2M
　　[myisamchk]
　　set-variable = key_buffer=128M
　　set-variable = sort_buffer=128M
　　set-variable = read_buffer=2M
　　set-variable = write_buffer=2M
　　[WinMySQLadmin]
　　Server=D:/mysql/bin/mysqld-nt.exe

欢迎光临 MySQL社区 (http://www.mysqlpub.com/)