RE: localhost vs domain for connection string

2010-11-29 Thread Jerry Schwartz
>-Original Message- >From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De >Meersman >Sent: Thursday, November 25, 2010 3:29 AM >To: Jerry Schwartz >Cc: Brent Clark; mysql mailing list >Subject: Re: localhost vs domain for connection string > &g

Re: localhost vs domain for connection string

2010-11-25 Thread Johan De Meersman
On Wed, Nov 24, 2010 at 4:44 PM, Jerry Schwartz wrote: > [JS] This might or might not be enabled by default. I'm running on Windows, > and I seem to remember having to change it. > > # Enable named pipe, bypassing the network stack > enable-named-pipe > Windows' named pipes are not the same as u

RE: localhost vs domain for connection string

2010-11-24 Thread Jerry Schwartz
>-Original Message- >From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De >Meersman >Sent: Wednesday, November 24, 2010 2:39 AM >To: Jerry Schwartz >Cc: Brent Clark; mysql mailing list >Subject: Re: localhost vs domain for connection string >

Re: localhost vs domain for connection string

2010-11-23 Thread Johan De Meersman
On Tue, Nov 23, 2010 at 7:55 PM, Jerry Schwartz wrote: > >IIRC, "localhost" is seen by the client as a magic word to mean "use the > >UNIX socket, not 127.0.0.1". > > > [JS] IF it is enabled in my.cnf. > Hmm, didn't know that bit. What's the option called ? -- Bier met grenadyn Is als mosterd

RE: localhost vs domain for connection string

2010-11-23 Thread Jerry Schwartz
>-Original Message- >From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De >Meersman >Sent: Tuesday, November 23, 2010 6:19 AM >To: Brent Clark >Cc: mysql mailing list >Subject: Re: localhost vs domain for connection string > >IIRC, "loc

Re: localhost vs domain for connection string

2010-11-23 Thread Jan Steinman
> From: Brent Clark > > Is there a difference if someone had to make the connection string the a > domain (hosts file entry makes the machine look at its ip) as opposed to just > using localhost. > If so would a performance hit be incurred? Using 'localhost' will always be faster, although per

Re: localhost vs domain for connection string

2010-11-23 Thread Johan De Meersman
IIRC, "localhost" is seen by the client as a magic word to mean "use the UNIX socket, not 127.0.0.1". So, yes, that would make the connection not show up in netstat :-) On Tue, Nov 23, 2010 at 11:11 AM, Brent Clark wrote: > Hiya > > Is there a difference if someone had to make the connection str