Jerry Schwartz wrote:
From: Wagner Bianchi [mailto:wagnerbianch...@gmail.com]
Sent: Thursday, January 28, 2010 2:03 PM
To: Jerry Schwartz
Subject: Re: WAMP vs LAMP
[JS] The file paths were all the same, actually, and the address for MySQL is
just “localhost”.
[WB]Consider to use MySQL on Unix like environment because the socket file.
This way you will get more performance then use TCP/IP on MS Windows.
[JS] That’s an interesting suggestion. Windows has socket files, but I’ve never
looked at them. In fact, I don’t even know if MySQL can us a socket file and
TCP/IP at the same time. We’re going to have more ODBC traffic than web
traffic, I expect.
On Windows they aren't called "sockets", they are "named pipes" and yes
you can be listening to both internal and external connections at the
same time.
--enabled-named-pipe
http://dev.mysql.com/doc/refman/4.1/en/server-options.html#option_mysqld_enable-named-pipe
When connecting locally, you have both options at your disposal
http://dev.mysql.com/doc/refman/4.1/en/connecting.html
There is even another option for Windows, --shared-memory
http://dev.mysql.com/doc/refman/4.1/en/server-options.html#option_mysqld_shared-memory
This works similar to a named pipe and if you want to enable both (pipes
and shares) at the same time, you need to provide different names. The
TCP/IP ports are independent and also available.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
