Bug #76442 [Opn]: Slow MySQL perfomance via named pipe

From: Date: Sun, 10 Jun 2018 10:50:35 +0000
Subject: Bug #76442 [Opn]: Slow MySQL perfomance via named pipe
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-215580@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=76442&edit=1

 ID:                 76442
 User updated by:    yaro at opti dot su
 Reported by:        yaro at opti dot su
 Summary:            Slow MySQL perfomance via named pipe
 Status:             Open
 Type:               Bug
 Package:            MySQLi related
 Operating System:   Windows Server 2008 R2
 PHP Version:        7.2.6
 Block user comment: N
 Private report:     N

 New Comment:

Additional info:
- Windows Server 2008 R2 ~ 15 msec for mysqli_query()
- Windows Server 2012 R2 ~ 1 msec for mysqli_query()


Previous Comments:
------------------------------------------------------------------------
[2018-06-10 10:45:56] yaro at opti dot su

Description:
------------
On PHP v5.4.x mysqli_connect() and mysqli_query() worked momentally via named pipes for all version
of windows (at least for MySQL v5.5, v5.6, v5.7), but in PHP v5.6.x, v7.0.x, v7.1.x, v7.2.x works
very slowly:
- Windows Server 2008 R2 ~ 50 msec for mysqli_connect()
- Windows Server 2012 R2 ~ 5 msec for mysqli_connect()

I think this is a bug, because in the previous version of PHP everything worked is perfect!
Excuse for bad English.

Test script:
---------------
$time = microtime(true);
$link = mysqli_connect($host, $user, $pass);
$time = (microtime(true) - $time) * 1000;
echo 'Connect = '.$time.' ms.';

$time = microtime(true);
$link = mysqli_query($link, 'select 1');
$time = (microtime(true) - $time) * 1000;
echo 'Select = '.$time.' ms.';



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



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

Thread (5 messages)

« previous php.bugs (#215580) next »