Bug #69843 [Opn->Fbk]: Connection via only named pipe very slow
| From: | fjanisze@php.net | Date: | Tue, 09 May 2017 12:21:27 +0000 |
| Subject: | Bug #69843 [Opn->Fbk]: Connection via only named pipe very slow | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-209024@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=69843&edit=1
ID: 69843
Updated by: fjanisze@php.net
Reported by: steffenb198 at aol dot com
Summary: Connection via only named pipe very slow
-Status: Open
+Status: Feedback
Type: Bug
Package: MySQL related
Operating System: Windows
PHP Version: 5.6.10
Block user comment: N
Private report: N
New Comment:
Can you provide server version and full configuration? Are you using a custom build? In that case
can you provide the building options? Which windows version are you using? Is the performance
problem always reproducible?
Previous Comments:
------------------------------------------------------------------------
[2015-06-15 22:12:59] steffenb198 at aol dot com
Description:
------------
When you connect to a mysql server using a named pipe and networking is disabled
on said server (so no TCP fallback is possible), the connection via mysqlnd
is very slow.
Test script:
---------------
$mysqli = new \Mysqli(".", "user", "pw", "db", null,
"\\\\.\\pipe\\MySQL");
$s = microtime(true);
$result = $mysqli->query("SELECT * FROM user");
var_dump($result);
var_dump(microtime(true) - $s);
Expected result:
----------------
Fast "query result" like with libmysql (~8ms)
Actual result:
--------------
Very slow (100ms)
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=69843&edit=1