MySQL的my.ini文件优化!

最新推荐文章于 2023-03-01 22:35:36 发布

zcyang

最新推荐文章于 2023-03-01 22:35:36 发布

阅读量920

点赞数

CC 4.0 BY-SA版权

分类专栏： PHP的体会数据库文章标签： mysql buffer concurrency thread locking server

本文链接：https://blog.youkuaiyun.com/zcyang/article/details/1532108

PHP的体会同时被 2 个专栏收录

5 篇文章

订阅专栏

数据库

4 篇文章

订阅专栏

本文提供了一套详细的MySQL配置参数设置方案，旨在通过调整各种内存缓冲区大小、并发连接数及其它关键参数来优化数据库性能。适用于希望提升MySQL服务器运行效率的数据库管理员及开发人员。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[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