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等等程序都可以配置选项参数。