Selecting a MySQL Server Type

The following table shows the available servers for Windows in MySQL 5.0.

mysqld-ntOptimized binary with named-pipe support
mysqldOptimized binary without named-pipe support
mysqld-debugLike mysqld-nt, but compiled with full debugging and automatic memory allocation checking

All of the preceding binaries are optimized for modern Intel processors, but should work on any Intel i386-class or higher processor.

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 5.0 servers have support for symbolic linking of database directories.

MySQL supports TCP/IP on all Windows platforms. MySQL servers on Windows support named pipes as indicated in the following list. However, the default is to use TCP/IP regardless of platform. (Named pipes are slower than TCP/IP in many Windows configurations.)

Use of named pipes is subject to these conditions:

  • Named pipes are enabled only if you start the server with the --enable-named-pipe option. It is necessary to use this option explicitly because some users have experienced problems with shutting down the MySQL server when named pipes were used.

  • Named-pipe connections are permitted only by the mysqld-nt and mysqld-debug servers.


Most of the examples in this manual use mysqld as the server name. If you choose to use a different server, such as mysqld-nt, make the appropriate substitutions in the commands that are shown in the examples.

User Comments
  Posted by Gauron Kolas on May 11, 2009
"Named pipes are slower than TCP/IP in many Windows configurations"? Which "configurations"? If connecting to a DB on localhost, it should be faster. Please clarify.
Sign Up Login You must be logged in to post a comment.