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
localhost vs domain for connection string
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=arch...@jab.org