2.3.4.3 Selecting a MySQL Server Type选择MySQL服务器类型

The following table shows the available servers for Windows in MySQL 8.0.下表显示了MySQL 8.0中Windows可用的服务器。

Binary二进制的Description描述
mysqldOptimized binary with named-pipe support优化二进制文件,支持命名管道
mysqld-debugLike mysqld, but compiled with full debugging and automatic memory allocation checkingmysqld类似,但经过完全调试和自动内存分配检查编译

All of the preceding binaries are optimized for modern Intel processors, but should work on any Intel i386-class or higher processor.上述所有二进制文件都针对现代英特尔处理器进行了优化,但应适用于任何英特尔i386级或更高级别的处理器。

Each of the servers in a distribution support the same set of storage engines. 分布中的每个服务器都支持同一组存储引擎。The SHOW ENGINES statement displays which engines a given server supports.SHOW ENGINES语句显示给定服务器支持哪些引擎。

All Windows MySQL 8.0 servers have support for symbolic linking of database directories.所有Windows MySQL 8.0服务器都支持数据库目录的符号链接。

MySQL supports TCP/IP on all Windows platforms. MySQL在所有Windows平台上都支持TCP/IP。MySQL servers on Windows also support named pipes, if you start the server with the named_pipe system variable enabled. 如果在启动服务器时启用了named_pipe系统变量,则Windows上的MySQL服务器也支持命名管道。It is necessary to enable this variable explicitly because some users have experienced problems with shutting down the MySQL server when named pipes were used. 有必要显式启用此变量,因为有些用户在使用命名管道时遇到了关闭MySQL服务器的问题。The default is to use TCP/IP regardless of platform because named pipes are slower than TCP/IP in many Windows configurations.默认情况下,无论平台如何,都使用TCP/IP,因为在许多Windows配置中,命名管道的速度比TCP/IP慢。