>-----Original Message-----
>From: vegivamp@stripped [mailto:vegivamp@stripped] 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
><brentgclarklist@stripped>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=1
>>
>>
>
>
>--
>Bier met grenadyn
>Is als mosterd by den wyn
>Sy die't drinkt, is eene kwezel
>Hy die't drinkt, is ras een ezel
