mysqld is the MySQL server. 是MySQL服务器。The following discussion covers these MySQL server configuration topics:以下讨论涵盖以下MySQL服务器配置主题:
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.这些变量包含有关运行时操作的计数器和统计信息。
How to set the server SQL mode. 如何设置服务器SQL模式。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.此设置修改SQL语法和语义的某些方面,例如与其他数据库系统的代码兼容,或控制特定情况下的错误处理。
How the server manages client connections.服务器如何管理客户端连接。
Configuring and using IPv6 and network namespace support.配置和使用IPv6和网络命名空间支持。
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.根据表的类型(事务性或非事务性)以及是否使用复制,需要考虑性能和可靠性。
For listings of MySQL server variables and options that have been added, deprecated, or removed in MySQL 8.0, see Section 1.4, “Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0”.有关MySQL 8.0中添加、弃用或删除的MySQL服务器变量和选项的列表,请参阅第1.4节,“MySQL 8.0中添加、弃用或删除的服务器和状态变量和选项”。
Not all storage engines are supported by all MySQL server binaries and configurations. 并非所有MySQL服务器二进制文件和配置都支持所有存储引擎。To find out how to determine which storage engines your MySQL server installation supports, see Section 13.7.7.16, “SHOW ENGINES Statement”.要了解如何确定MySQL服务器安装支持哪些存储引擎,请参阅第13.7.7.16节,“显示引擎状态”。