建站软件 优化软件 编程软件 网页辅助 站群程序 网站程序 图像处理 资源教程 字体下载 推荐软件


您的位置:首页 > MYSQL学习 > 优化的MySQL实例

优化的MySQL实例

时间:2015-02-11 15:19:49  来源:免费模板网 作者:风雪 阅读次数 tags优化的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 CPUs*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

本文地址:https://www.freemoban.com/mysql/2015/0211/510.html

猜你喜欢
栏目推荐
模板推荐

Copyright:www.freemoban.com 免费模板网 All Rights Reserved 网站备案:辽ICP备19014872号-2   辽公网安备 21010602000376号  辽公网安备:42900402000182号

免责声明:本站部分资源来自互联网收集,版权归原创者所有,如果侵犯了你的权益,我们会及时删除侵权内容,联系QQ:1615187561 谢谢合作!