#48082 [Com]: mysql_connect does not work with named pipes

From:	peaceable_whale at hotmail dot com	Date:	Tue, 02 Feb 2010 07:07:15 +0000
Subject:	#48082 [Com]: mysql_connect does not work with named pipes
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-147133@lists.php.net to get a copy of this message

 ID:               48082
 Comment by:       peaceable_whale at hotmail dot com
 Reported By:      andrew dot answer at gmail dot com
 Status:           Assigned
 Bug Type:         MySQL related
 Operating System: win32 only - Windows XP
 PHP Version:      5.3.0RC1
 Assigned To:      mysql
 New Comment:

I have the same problem using PHP 5.3.1 on IIS 7.5 w/FastCGI and MySQL
5.1.43. Is there any update on this issue?


Previous Comments:
------------------------------------------------------------------------

[2009-10-20 19:56:25] kulakov74 at yandex dot ru

I confirm this with the just installed PHP 5.3.0 on Win XP, I used to
use pipes and had skip-networking in my my.ini, I still can connect with
mysql.exe, but PHP does not connect this way any more - I had to comment
out skip-networking and set the right port in mysql.default_port = 3306
(PHP used to work without it when I used TCP long ago). 
Yes, the dot does not work any more, as if it cannot be resolved to
localhost. 
If I have mysql.default_socket = mysql in my php.ini, mysqlnd connects
to localhost via UNIX socket, otherwise it uses TCP. 

I agree these things are not critical, yet they have to be mentioned or
explained somewhere. 

Got some info on pipes here: http://blog.ulf-wendel.de/?p=157
(comments)

------------------------------------------------------------------------

[2009-06-29 09:43:02] andrew dot answer at gmail dot com

http://stackoverflow.com/questions/832714/mysql-named-pipes-on-windows-
faster-best-practice-or-bad-idea

------------------------------------------------------------------------

[2009-06-29 09:40:48] andrew dot answer at gmail dot com

regarding performance

http://www.google.ru/search?
rlz=1C1GGLS_ruRU305RU305&sourceid=chrome&ie=UTF-8&q=named+pipes+speed

http://www.mail-archive.com/mysql@lists.mysql.com/msg77837.html

http://msdn.microsoft.com/en-us/library/aa178138(SQL.80).aspx

------------------------------------------------------------------------

[2009-06-29 08:42:28] uwendel at mysql dot com

Aren't named pipes considerable slower than TCP/IP: why use named pipes
?! I won't work on named pipe support for mysqlnd, if its slower, which
is the case AFAIK.

------------------------------------------------------------------------

[2009-06-20 11:36:19] pajoye@php.net

Andrei, fixable? or need help on this one? I'm not sure it is very
critical or widely used. it could wait for 5.3.1.

------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/48082

-- 
Edit this bug report at http://bugs.php.net/?id=48082&edit=1



   

Thread (24 messages)

• andrew dot answer at gmail dot comSun, 26 Apr 2009 18:31:40 +0000
  • jani@php.netSun, 26 Apr 2009 21:07:15 +0000#48082 [Opn->Fbk]: mysql_connect not work with named pipes
  • mattwil@php.netMon, 27 Apr 2009 00:04:04 +0000#48082 [Fbk]: mysql_connect not work with named pipes
  • mattwil@php.netMon, 27 Apr 2009 00:04:28 +0000#48082 [Fbk->Ver]: mysql_connect not work with named pipes
  • andrew dot answer at gmail dot comMon, 27 Apr 2009 16:24:35 +0000#48082 [Ver]: mysql_connect not work with named pipes
  • andrew dot answer at gmail dot comMon, 27 Apr 2009 16:27:35 +0000#48082 [Ver]: mysql_connect not work with named pipes
  • pajoye@php.netSat, 20 Jun 2009 11:36:20 +0000#48082 [Ver->Asn]: mysql_connect does not work with named pipes
  • uwendel at mysql dot comMon, 29 Jun 2009 08:42:29 +0000#48082 [Com]: mysql_connect does not work with named pipes
  • andrew dot answer at gmail dot comMon, 29 Jun 2009 09:40:49 +0000#48082 [Asn]: mysql_connect does not work with named pipes
  • andrew dot answer at gmail dot comMon, 29 Jun 2009 09:43:04 +0000#48082 [Asn]: mysql_connect does not work with named pipes
  • kulakov74 at yandex dot ruTue, 20 Oct 2009 19:56:25 +0000#48082 [Com]: mysql_connect does not work with named pipes
  • peaceable_whale at hotmail dot comTue, 02 Feb 2010 07:07:15 +0000#48082 [Com]: mysql_connect does not work with named pipes
  • quakvorgus at yahoo dot comWed, 17 Feb 2010 20:11:17 +0000#48082 [Com]: mysql_connect does not work with named pipes
  • dex_is_cool at loopmod dot comTue, 18 May 2010 18:31:07 +0000Bug #48082 [Com]: mysql_connect does not work with named pipes
  • andrey@php.netMon, 16 Aug 2010 14:38:57 +0000Req #48082 [Asn->Ana]: mysql_connect does not work with named pipes
  • andrey@php.netFri, 20 Aug 2010 10:24:54 +0000Req #48082 [Ana]: mysql_connect does not work with named pipes
  • andrey@php.netWed, 22 Sep 2010 15:16:40 +0000Req #48082 [Ana->Csd]: mysql_connect does not work with named pipes
  • peaceable_whale at hotmail dot comTue, 28 Sep 2010 13:50:58 +0000Req #48082 [Com]: mysql_connect does not work with named pipes
  • stevenmartin99 at gmail dot comWed, 01 Dec 2010 23:00:55 +0000Req #48082 [Com]: mysql_connect does not work with named pipes
  • stevenmartin99 at gmail dot comWed, 01 Dec 2010 23:07:53 +0000Req #48082 [Com]: mysql_connect does not work with named pipes
  • jose dot nobile at gmail dot comTue, 18 Jan 2011 01:48:44 +0000Req #48082 [Com]: mysql_connect does not work with named pipes
  • peaceable_whale at hotmail dot comFri, 04 Feb 2011 17:52:57 +0000Req #48082 [Com]: mysql_connect does not work with named pipes
  • peaceable_whale at hotmail dot comTue, 24 Apr 2012 14:44:07 +0000Req #48082 [Com]: mysql_connect does not work with named pipes
  • peaceable_whale at hotmail dot comTue, 24 Apr 2012 14:45:44 +0000Req #48082 [Com]: mysql_connect does not work with named pipes