>-----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 ><brentgclarkl...@gmail.com>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 >> >> tcp 0 0 own.ex.ip:50340 own.ex.ip:3306 ESTABLISHED >> 30324/apache2 >> tcp 0 0 own.ex.ip:50287 own.ex.ip:3306 ESTABLISHED >> 30309/apache2 >> tcp 0 0 own.ex.ip:3306 own.ex.ip:50287 ESTABLISHED >> 29234/mysqld >> tcp 0 0 own.ex.ip:50357 own.ex.ip:3306 ESTABLISHED >> 31714/apache2 >> tcp 0 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
