Skip navigation links
2.3.9 Starting the Server for the First Time »
Section Navigation      [Toggle]

2.3.8. Selecting a MySQL Server Type

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

Binary Description
mysqld Optimized binary with named-pipe support
mysqld-debug Like mysqld, 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.5 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.)

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.


User Comments

Posted by Gauron Kolas on May 11 2009 7:07am[Delete] [Edit]

"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.

Add your own comment.