mysql support files_MySQL5.5.32数据库support-files/my*.cnf详解

MySQL数据库配置说明：

1、support-files/my-huge.cnf

[root@db02 mysql-5.5.32]# vim support-files/my-huge.cnf

# Example MySQL config file for very large systems.

#

# This is for a large system with memory of 1G-2G where the system runs mainly

# MySQL.

这个配置是巨型数据库系统使用，内存在1G-2G左右！

2、support-files/my-innodb-heavy-4G.cnf

[root@db02 mysql-5.5.32]# vim support-files/my-innodb-heavy-4G.cnf

#BEGIN CONFIG INFO

#DESCR: 4GB RAM, InnoDB only, ACID, few connections, heavy queries

#TYPE: SYSTEM

#END CONFIG INFO

这个主要的作用是，支持4G内存，支持InnoDB引擎，支持事务(ACID)等特性所使用！说明：ACID，指数据库事务正确执行的四个基本要素的缩写。包含：原子性(Atomicity)、一致性(Consistency)、隔离性(Isolation)、持久性(Durability)！

3、support-files/my-large.cnf

[root@db02 mysql-5.5.32]# vim support-files/my-large.cnf

# Example MySQL config file for large systems.

#

# This is for a large system with memory = 512M where the system runs mainly

# MySQL.

这个配置文件是大型数据库使用，内存在512M左右！

4、support-files/my-medium.cnf

[root@db02 mysql-5.5.32]# vim support-files/my-medium.cnf

# Example MySQL config file for medium systems.

#

# 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)

这个配置文件是中型数据系统使用，内存在128M左右！

5、support-files/my-small.cnf

[root@db02 mysql-5.5.32]# vim support-files/my-small.cnf

# 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.

这是my-small.cnf配置文件中开头的简介，他说明了这个配置文件时在内存小于64M时使用的，小型数据库系统，目的是不占用更多的系统资源！