RE: localhost vs domain for connection string
>-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 > >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 unix sockets, although the general >idea is similar. I'm not sure, but I think the Unix socket file is always >created. > [JS] I don't remember either. I also don't remember if the original question was about *nix or Windows. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >-- >Bier met grenadyn >Is als mosterd by den wyn >Sy die't drinkt, is eene kwezel >Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: localhost vs domain for connection string
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 unix sockets, although the general idea is similar. I'm not sure, but I think the Unix socket file is always created. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
RE: localhost vs domain for connection string
>-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 > >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 ? > [JS] This might or might not be enabled by default. I'm running on Windows, and I seem to remember having to change it. # SERVER SECTION # -- # # The following options will be read by the MySQL Server. Make sure that # you have installed the server correctly (see above) so it reads this # file. # [mysqld] # The TCP/IP Port the MySQL Server will listen on port=3306 # Enable named pipe, bypassing the network stack enable-named-pipe = Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >-- >Bier met grenadyn >Is als mosterd by den wyn >Sy die't drinkt, is eene kwezel >Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: localhost vs domain for connection string
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 by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
RE: localhost vs domain for connection string
>-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, "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. >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 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? >> >> I have this client that has used the domain and in netstat im seeing all >> this >> >> tcp0 0 own.ex.ip:50340 own.ex.ip:3306 ESTABLISHED >> 30324/apache2 >> tcp0 0 own.ex.ip:50287 own.ex.ip:3306 ESTABLISHED >> 30309/apache2 >> tcp0 0 own.ex.ip:3306 own.ex.ip:50287 ESTABLISHED >> 29234/mysqld >> tcp0 0 own.ex.ip:50357 own.ex.ip:3306 ESTABLISHED >> 31714/apache2 >> tcp0 0 own.ex.ip:3306 own.ex.ip:50335 ESTABLISHED >> 29234/mysqld >> >> But I have another client that is using localhost and netstat is quiet as a >> mouse. >> >> This actually never dawned on me. Hence the reason im asking >> But the real reason is that the first clients machine is under heavy load >> and we are trying to see what can be improved. >> >> Kind Regards >> Brent Clark >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be >> >> > > >-- >Bier met grenadyn >Is als mosterd by den wyn >Sy die't drinkt, is eene kwezel >Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: localhost vs domain for connection string
> 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 perhaps imperceptibly so. I look into the future because that’s where I am going to spend the rest of my life. -- George Burns Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: localhost vs domain for connection string
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 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? > > I have this client that has used the domain and in netstat im seeing all > this > > tcp0 0 own.ex.ip:50340 own.ex.ip:3306 ESTABLISHED > 30324/apache2 > tcp0 0 own.ex.ip:50287 own.ex.ip:3306 ESTABLISHED > 30309/apache2 > tcp0 0 own.ex.ip:3306 own.ex.ip:50287 ESTABLISHED > 29234/mysqld > tcp0 0 own.ex.ip:50357 own.ex.ip:3306 ESTABLISHED > 31714/apache2 > tcp0 0 own.ex.ip:3306 own.ex.ip:50335 ESTABLISHED > 29234/mysqld > > But I have another client that is using localhost and netstat is quiet as a > mouse. > > This actually never dawned on me. Hence the reason im asking > But the real reason is that the first clients machine is under heavy load > and we are trying to see what can be improved. > > Kind Regards > Brent Clark > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel