mysqld, also known as MySQL Server, is a single multithreaded program that does most of the work in a MySQL installation. It does not spawn additional processes. mysqld,也称为MySQL Server,是一个单线程程序,在MySQL安装中完成大部分工作。它不会产生额外的进程。MySQL Server manages access to the MySQL data directory that contains databases and tables. The data directory is also the default location for other information such as log files and status files.MySQL服务器管理对包含数据库和表的MySQL数据目录的访问。数据目录也是其他信息(如日志文件和状态文件)的默认位置。
Some installation packages contain a debugging version of the server named mysqld-debug. 一些安装包包含名为mysqld-debug的服务器调试版本。Invoke this version instead of mysqld for debugging support, memory allocation checking, and trace file support (see Section 5.9.1.2, “Creating Trace Files”).调用此版本而不是mysqld以获得调试支持、内存分配检查和跟踪文件支持(请参阅第5.9.1.2节,“创建跟踪文件”)。
When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those clients.当MySQL服务器启动时,它会监听来自客户端程序的网络连接,并代表这些客户端管理对数据库的访问。
The mysqld program has many options that can be specified at startup. For a complete list of options, run this command:mysqld程序有许多可以在启动时指定的选项。要查看完整的选项列表,请运行以下命令:
mysqld --verbose --help
MySQL Server also has a set of system variables that affect its operation as it runs. System variables can be set at server startup, and many of them can be changed at runtime to effect dynamic server reconfiguration. MySQL Server还有一组系统变量,这些变量会影响其运行时的操作。系统变量可以在服务器启动时设置,其中许多变量可以在运行时更改,以实现动态服务器重新配置。MySQL Server also has a set of status variables that provide information about its operation. You can monitor these status variables to access runtime performance characteristics.MySQL Server还有一组状态变量,提供有关其操作的信息。您可以监视这些状态变量以访问运行时性能特征。
For a full description of MySQL Server command options, system variables, and status variables, see Section 5.1, “The MySQL Server”. 有关MySQL Server命令选项、系统变量和状态变量的完整描述,请参阅第5.1节,“MySQL Server”。For information about installing MySQL and setting up the initial configuration, see Chapter 2, Installing and Upgrading MySQL.有关安装MySQL和设置初始配置的信息,请参阅第2章“安装和升级MySQL”。