List:General Discussion« Previous MessageNext Message »
From:Shawn Green Date:February 1 2010 4:07pm
Subject:Re: WAMP vs LAMP
View as plain text  
Jerry Schwartz wrote:
> From: Wagner Bianchi [mailto:wagnerbianchijr@stripped] 
> 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



Thread
Event feature already working in Server 5.1.37Philipp Maske [Location Bretagne]24 Jan
  • RE: Event feature already working in Server 5.1.37Daevid Vincent26 Jan
    • Re: Event feature already working in Server 5.1.37Dan Nelson26 Jan
      • RE: Event feature already working in Server 5.1.37Daevid Vincent26 Jan
        • Re: Event feature already working in Server 5.1.37Shawn Green27 Jan
          • Re: Event feature already working in Server 5.1.37Wagner Bianchi27 Jan
          • RE: Event feature already working in Server 5.1.37Jerry Schwartz27 Jan
            • Re: Event feature already working in Server 5.1.37Johan De Meersman27 Jan
              • WAMP vs LAMPJerry Schwartz28 Jan
                • how to get the name of primary key ?曹凯1 Feb
                  • Re: how to get the name of primary key ?Thiyaghu CK1 Feb
                    • RE: how to get the name of primary key ?曹凯1 Feb
                  • Re: how to get the name of primary key ?Jesper Wisborg Krogh1 Feb
                    • RE: how to get the name of primary key ?曹凯1 Feb
                      • Re: how to get the name of primary key ?prabhat kumar1 Feb
        • Re: Event feature already working in Server 5.1.37Johan De Meersman27 Jan
          • Re: Event feature already working in Server 5.1.37Shawn Green27 Jan
            • Re: Event feature already working in Server 5.1.37Dan Nelson27 Jan
              • Re: Event feature already working in Server 5.1.37Johan De Meersman27 Jan
    • Re: Event feature already working in Server 5.1.37Joerg Bruehe26 Jan
    • Re: Event feature already working in Server 5.1.37Johan De Meersman26 Jan
Re: Event feature already working in Server 5.1.37Shawn Green26 Jan
RE: Event feature already working in Server 5.1.37John Daisley 27 Jan
RE: WAMP vs LAMPJerry Schwartz29 Jan
  • Re: WAMP vs LAMPWagner Bianchi29 Jan
    • RE: WAMP vs LAMPJerry Schwartz1 Feb
  • Re: WAMP vs LAMPShawn Green1 Feb
    • RE: WAMP vs LAMPJerry Schwartz1 Feb