2.3.3.3 Selecting a MySQL Server Type (original) (raw)
The world's most popular open source database
2.3.3.3 Selecting a MySQL Server Type
The following table shows the available servers for Windows in MySQL 8.4.
| Binary | Description |
|---|---|
| mysqld | Optimized binary with named-pipe support |
| mysqld-debug | Like mysqld, but compiled with full debugging and automatic memory allocation checking |
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.
All Windows MySQL 8.4 servers have support for symbolic linking of database directories.
MySQL supports TCP/IP on all Windows platforms. MySQL servers on Windows also support named pipes, if you start the server with the named_pipe system variable enabled. 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. The default is to use TCP/IP regardless of platform because named pipes are slower than TCP/IP in many Windows configurations.