mysql配置文件官方地址如下：https://dev.mysql.com/doc/refman/5.6/en/option-files.html

mysql读取配置文件的先后顺序如下：

File Name	Purpose
/etc/my.cnf	Global options
/etc/mysql/my.cnf	Global options
SYSCONFDIR/my.cnf	Global options
$MYSQL_HOME/my.cnf	Server-specific options (server only)
defaults-extra-file	The file specified with , if any
~/.my.cnf	User-specific options
~/.mylogin.cnf	User-specific login path options (clients only)

SYSCONFDIR 是编译mysql时指定的， 默认是/etc目录下

$MYSQL_HOME 是环境变量设置的，如果没有设置，就采用其他的策略

凡是能通过命令行传递的参数，都可以通过配置文件进行配置。查看命令行参数命令如下：

mysqld --verbose --help 或者 mysqladmin variables

my.cnf文件语法如下：

1、空行被忽略

2、[group] 分组的开始，分组的结束为下一个分组的开始

3、opt_name 变量

4、opt_name=XXX 如同命令行参数和值

配置文件中的转译特殊字符，大小写敏感，具体如下：

\b	backspace
\t	tab
\n	newline
\r	carriage return
\\	backslash
\s	space	空格

[group] 目前包括如下：

mysqld   针对mysql server程序的配置

mysql  针对mysql客户端的配置

client  针对mysql所有客户端的配置

mysqldump  针对dump程序的配置

mysqlhotcopy  热cp

mysqladmin  管理程序配置

优化方面，我们主要是针对[mysqld]配置，其他的这里暂不处理。

mysqld可配置的变量如下：

Table 5.3 System Variable Summary

Name	Cmd-Line	Option File	System Var	Var Scope	Dynamic
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
			Yes	Both	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
			Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Varies
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
			Yes	Both	Yes
			Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
			Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes	Yes	Global	Yes
			Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
	Yes	Yes	Yes	Global	No
			Yes	Global	Yes
			Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
(note 1)			Yes	Both	Yes
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
			Yes	Both	Yes
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
			Yes	Both	Yes
(note 1)			Yes	Both	Yes
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
			Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
			Yes	Global	No
			Yes	Global	No
	Yes	Yes	Yes	Both	Yes
			Yes	Session	Yes
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes			Yes
- Variable:			Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Session	No
	Yes	Yes	Yes	Both	Yes
			Yes	Both	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Session	No
	Yes	Yes			Yes
- Variable:			Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Session	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
			Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes			Yes
- Variable:			Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Both	No
			Yes	Both	No
			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
			Yes	Global	No
			Yes	Session	Yes
			Yes	Both	No
			Yes	Global	Yes
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	Yes
			Yes	Global	No
			Yes	Session	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
			Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
			Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
			Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
			Yes	Global	No
	Yes	Yes	Yes	Global	No
			Yes	Session	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
			Yes	Global	No
			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
			Yes	Session	Yes
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
			Yes	Both	Yes
			Yes	Global	No
			Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
	Yes	Yes			Yes
- Variable:			Yes	Global	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			Yes
- Variable:			Yes	Global	Yes
	Yes	Yes			Yes
- Variable:			Yes	Global	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes	Yes	Global	No
			Yes	Global	Yes
	Yes	Yes			Yes
- Variable:			Yes	Global	Yes
			Yes	Global	Yes
			Yes	Global	Yes
	Yes	Yes			Yes
- Variable:			Yes	Varies	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
			Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
			Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
			Yes	Global	No
			Yes	Global	No
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
			Yes	Global	No
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
			Yes	Global	No
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes		Yes	Global	Yes
	Yes	Yes	Yes	Global	No
			Yes	Global	No
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes			Yes
- Variable:			Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Both	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes		Yes	Both	Yes
	Yes		Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
			Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
			Yes	Global	Yes
	Yes	Yes	Yes	Global	No
			Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
			Yes	Global	No
			Yes	Session	Yes
			Yes	Session	Yes
			Yes	Both	No
			Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Global	No
			Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
			Yes	Global	No
	Yes		Yes	Both	Yes
	Yes		Yes	Both	Yes
			Yes	Global	Yes
	Yes		Yes	Both	Yes
	Yes		Yes	Both	Yes
			Yes	Global	No
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
			Yes	Both	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Both	Yes
			Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Global	No
			Yes	Session	No
			Yes	Session	Yes
			Yes	Session	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Session	Yes
			Yes	Session	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
			Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Varies
	Yes	Yes	Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
			Yes	Global	Yes
			Yes	Global	Yes
			Yes	Global	Yes
			Yes	Global	Yes
			Yes	Global	Yes
			Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes			Yes
- Variable:			Yes	Global	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			Yes
- Variable:			Yes	Global	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes	Yes	Global	No
			Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
			Yes	Global	Yes
	Yes	Yes			Yes
- Variable:			Yes	Global	Yes
	Yes		Yes	Global	Yes
			Yes	Global	Yes
			Yes	Global	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
			Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes			Yes
- Variable:			Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Session	Yes
			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
	Yes	Yes			Yes
- Variable:			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Global	Yes
			Yes	Both	Yes
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
	Yes	Yes			No
- Variable:			Yes	Global	No
			Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	Yes
			Yes	Global	No
			Yes	Global	Yes
			Yes	Global	Yes
			Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Global	Yes
	Yes	Yes	Yes	Global	No
			Yes	Global	No
			Yes	Both	Yes
	Yes	Yes	Yes	Global	Yes
			Yes	Session	Yes
	Yes	Yes	Yes	Both	Yes
	Yes	Yes	Yes	Global	No
	Yes	Yes	Yes	Both	Yes
			Yes	Session	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
			Yes	Both	Yes
	Yes	Yes	Yes	Both	Yes
			Yes	Global	Varies
			Yes	Global	Yes
			Yes	Global	Yes
			Yes	Global	Yes
			Yes	Global	Yes
			Yes	Global	Yes
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
			Yes	Global	No
	Yes	Yes	Yes	Both	Yes
			Yes	Session	No

状态变量列表

Table 5.4 Status Variable Summary

Variable Name	Variable Type	Variable Scope
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	SESSION
		GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	string	GLOBAL
	string	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	numeric	SESSION
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	boolean	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	boolean	GLOBAL
	string	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	numeric	GLOBAL
		GLOBAL
	integer	GLOBAL
		GLOBAL
	integer	GLOBAL
	string	GLOBAL
	boolean	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	string	GLOBAL | SESSION
	string	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL
	string	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	string	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL | SESSION
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	integer	GLOBAL
	datetime	GLOBAL
	integer	GLOBAL