下表列出了适用于 mysqld 的所有系统变量。The following table lists all system variables applicable within
mysqld.
该表列出了命令行选项(Cmd-line)、配置文件中有效的选项(Option file)、服务器系统变量(System Var)和状态变量(Status var),统一列在一张表中,并指明每个选项或变量的有效位置。如果在命令行或选项文件中设置的服务器选项与相应系统变量的名称不同,变量名称会立即在对应选项下方注明。变量的作用域(Var Scope)可以是全局(Global)、会话(Session)或两者兼有。有关设置和使用变量的详细信息,请参阅相应条目的描述。在适当情况下,还提供了指向相关进一步信息的直接链接。The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in one unified list, with an indication of where each option or variable is valid. If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted immediately below the corresponding option. The scope of the variable (Var Scope) is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the variables. Where appropriate, direct links to further information about the items are provided.
表 7.2 系统变量摘要Table 7.2 System Variable Summary
注意:Notes:
1. 此选项是动态的,但应仅由服务器设置。您不应手动设置此变量。1. This option is dynamic, but should be set only by server. You should not set this variable manually.