Selecting a MySQL Server Type
Created On
Last Updated On
byWesAdmin
Print < Back to the Title Topic
Selecting a MySQL Server Type
The following table shows the available servers for Windows in MySQL 8.0.Binary | Description |
---|---|
mysqld | Optimized binary with named-pipe support |
mysqld-debug | Like mysqld, but compiled with full debugging and automatic memory allocation checking |
SHOW ENGINES
statement displays which engines a given server supports.
All Windows MySQL 8.0 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.