Re: Speed of MySQL connections - Socket vs. Non-Socket
| From: | Don Read | Date: | Tue, 17 Apr 2001 23:06:53 +0000 |
| Subject: | Re: Speed of MySQL connections - Socket vs. Non-Socket | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-49075@lists.php.net to get a copy of this message | ||
On 17-Apr-01 Alexander Skwar wrote:
> So sprach Don Read am Tue, Apr 17, 2001 at 05:13:14PM -0500:
>> define('DBHOST', 'localhost');
>> // define('DBHOST', 'myhost.domain.com');
>>
<snip>
>> 'myhost.domain.com' would be your network hostname for the box, either in
>> /etc/hosts or from your DNS server.
>>
>> test the numbers using the 'localhost' (the AF_UNIX socket).
>> comment/uncoment the 'myhost' line & re-test (AF_INET connect).
>
> the first define, defines a connect using a AF_UNIX socket? Are you sure?
I have with 3.0.18 installed (to match customers), 'localhost' will use the
/tmp/mysql.sock. This may have changed under 4.x.
> According to the manual, I'd have thought, that I'd need to do:
>
> define('DBHOST', 'localhost:/tmp/mysql.sock' );
>
try it, YMMV.
Regards,
--
Don Read dread@texas.net
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.