关于mysql的配置文件my.cnf的说明

最新推荐文章于 2024-05-27 15:06:29 发布

原创最新推荐文章于 2024-05-27 15:06:29 发布 · 313 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL #Web #UP

服务器专栏收录该内容

8 篇文章

订阅专栏

本文介绍了如何根据系统的内存大小选择合适的MySQL配置文件，并提供了不同内存条件下推荐使用的配置文件路径。适用于小到大型系统的MySQL配置建议。

mysql的配置文件是/etc/my.cnf，通过修改它来配置mysql。
/etc/my.cnf来自以下文件：

如果你的内存≤64M，则复制/usr/local/share/mysql/my-small.cnf为/etc/my.cnf
# 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.

如果内存是128M，则复制/usr/local/share/mysql/my-medium.cnf为/etc/my.cnf
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)

如果内存是512M，则复制/usr/local/share/mysql/my-large.cnf为/etc/my.cnf
# This is for a large system with memory = 512M where the system runs mainly
# MySQL.

如果内存是1-2G，则复制/usr/local/share/mysql/my-huge.cnf为/etc/my.cnf
# This is for a large system with memory of 1G-2G where the system runs mainly
# MySQL.

如果内存是4G，则复制/usr/local/share/mysql/my-innodb-heavy-4G.cnf为/etc/my.cnf
# This is a MySQL example config file for systems with 4GB of memory
# running mostly MySQL using InnoDB only tables and performing complex
# queries with few connections.