- 7.1.1 配置服务器7.1.1 Configuring the Server
- 7.1.2 服务器配置默认值7.1.2 Server Configuration Defaults
- 7.1.3 服务器配置验证7.1.3 Server Configuration Validation
- 7.1.4 服务器选项、系统变量和状态变量参考7.1.4 Server Option, System Variable, and Status Variable Reference
- 7.1.5 服务器系统变量参考7.1.5 Server System Variable Reference
- 7.1.6 服务器状态变量参考7.1.6 Server Status Variable Reference
- 7.1.7 服务器命令选项7.1.7 Server Command Options
- 7.1.8 服务器系统变量7.1.8 Server System Variables
- 7.1.9 使用系统变量7.1.9 Using System Variables
- 7.1.10 服务器状态变量7.1.10 Server Status Variables
- 7.1.11 服务器 SQL 模式7.1.11 Server SQL Modes
- 7.1.12 连接管理7.1.12 Connection Management
- 7.1.13 IPv6 支持7.1.13 IPv6 Support
- 7.1.14 网络命名空间支持7.1.14 Network Namespace Support
- 7.1.15 MySQL 服务器时区支持7.1.15 MySQL Server Time Zone Support
- 7.1.16 资源组7.1.16 Resource Groups
- 7.1.17 服务器端帮助支持7.1.17 Server-Side Help Support
- 7.1.18 服务器跟踪客户端会话状态7.1.18 Server Tracking of Client Session State
- 7.1.19 服务器关闭过程7.1.19 The Server Shutdown Process
mysqld 是 MySQL 服务器。以下讨论涵盖了这些 MySQL 服务器配置主题:mysqld is the MySQL server. The following discussion covers these MySQL server configuration topics:
服务器支持的启动选项。您可以在命令行、通过配置文件或两者同时指定这些选项。Startup options that the server supports. You can specify these options on the command line, through configuration files, or both.
服务器系统变量。这些变量反映启动选项的当前状态和值,其中一些可以在服务器运行时修改。Server system variables. These variables reflect the current state and values of the startup options, some of which can be modified while the server is running.
服务器状态变量。这些变量包含关于运行时操作的计数器和统计信息。Server status variables. These variables contain counters and statistics about runtime operation.
如何设置服务器的 SQL 模式。此设置修改 SQL 语法和语义的某些方面,例如为了兼容其他数据库系统的代码,或控制特定情况下的错误处理。How to set the server SQL mode. This setting modifies certain aspects of SQL syntax and semantics, for example for compatibility with code from other database systems, or to control the error handling for particular situations.
服务器如何管理客户端连接。How the server manages client connections.
配置和使用 IPv6 及网络命名空间支持。Configuring and using IPv6 and network namespace support.
配置和使用时区支持。Configuring and using time zone support.
使用资源组。Using resource groups.
服务器端帮助功能。Server-side help capabilities.
用于启用客户端会话状态更改的功能。Capabilities provided to enable client session state changes.
服务器关闭过程。根据表的类型(事务型或非事务型)以及是否使用复制,会有性能和可靠性方面的考虑。The server shutdown process. There are performance and reliability considerations depending on the type of table (transactional or nontransactional) and whether you use replication.
有关在 MySQL 8.4 中新增、弃用或移除的 MySQL 服务器变量和选项的列表,请参见 第 1.5 节,“自 8.0 起 MySQL 8.4 添加、弃用或移除的服务器和状态变量与选项”。For listings of MySQL server variables and options that have been added, deprecated, or removed in MySQL 8.4, see Section 1.5, “Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.4 since 8.0”.
并非所有存储引擎均受所有 MySQL 服务器二进制文件和配置支持。要了解如何确定您的 MySQL 服务器安装支持哪些存储引擎,请参见 第 15.7.7.17 节,“SHOW ENGINES 语句”。Not all storage engines are supported by all MySQL server binaries and configurations. To find out how to determine which storage engines your MySQL server installation supports, see Section 15.7.7.17, “SHOW ENGINES Statement”.