MySQL 5.6 my.cnf 及其可配置项

1.环境

OS: CentOS 6.5 x64

MySQL: 5.6 for Linux (x86_64)

2.my.cnf文件介绍

参数文件my.cnf存放各种选项参数，默认的读取顺序是/etc/my.cnf /etc/mysql/my.cnf /u01/mysql/etc/my.cnf ~/.my.cnf，mysql的执行程序运行需要的参数都可以放在这个文件，查看各执行程序的选项和读取my.cnf文件哪部分内容，可以通过在命令行运行该程序加--verbose --help的方式查看，例如，查看mysqld的可用选项：

[root@test1 ~]# mysqld --help --verbose
2016-06-12 10:10:22 0 [Note] mysqld (mysqld 5.6.31-log) starting as process 4494 ...
2016-06-12 10:10:22 4494 [Note] Plugin 'FEDERATED' is disabled.
mysqld  Ver 5.6.31-log for Linux on x86_64 (Source distribution)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Starts the MySQL database server.

Usage: mysqld [OPTIONS]

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /u01/mysql/etc/my.cnf ~/.my.cnf 
The following groups are read: mysqld server mysqld-5.6
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit.
--no-defaults           Don't read default options from any option file,
                        except for login file.

。。。

validate-user-plugins                                      TRUE
verbose                                                    TRUE
wait-timeout                                               28800


To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --verbose --help'.
2016-06-12 10:10:22 4494 [Note] Binlog end
2016-06-12 10:10:22 4494 [Note] Shutting down plugin 'MyISAM'
2016-06-12 10:10:22 4494 [Note] Shutting down plugin 'CSV'
[root@test1 ~]# 

mysqld, mysqld_safe, mysql（客户端程序）, mysqldump, myisamchk, mysqlhotcopy等等程序都可以配置选项参数。