MySQL的生产环境My.cnf配置

最新推荐文章于 2021-02-28 11:19:03 发布

kaixinlc

最新推荐文章于 2021-02-28 11:19:03 发布

阅读量3.9k

点赞数

分类专栏： MySQL 文章标签： mysql my.cnf Linux

本文链接：https://blog.csdn.net/kaixinlc/article/details/50772859

版权

该博客主要介绍适用于小型系统的MySQL生产环境配置文件My.cnf的设置，内容涵盖关键参数调整和优化，旨在提升MySQL在Linux环境下的性能。

摘要由CSDN通过智能技术生成

www.kaixinlc.com

# Example MySQL config file for small systems.

#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# MySQL programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password   = your_password
port       = 33306
socket       = /mnt/opt/database/mysql5.6.28/data/mysql.sock
default-character-set=utf8
#character-set-client = gbk

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port       = 33306
socket   =/mnt/opt/database/mysql5.6.28/data/mysql.sock
datadir = /mnt/opt/disk/database/mysql5.6.28/data
skip-external-locking
lower_case_table_names=1
character-set-server = utf8

#skip_name_resolve

#key_buffer_size = 16M
#他人经验值，查询排序时所能使用的缓冲区大小。所以，对于内存在4GB左右的服务器推荐设置为6-8M。
#sort_buffe