Bug #76442 [NEW]: Slow MySQL perfomance via named pipe
| From: | yaro at opti dot su | Date: | Sun, 10 Jun 2018 10:46:02 +0000 |
| Subject: | Bug #76442 [NEW]: Slow MySQL perfomance via named pipe | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-215579@lists.php.net to get a copy of this message | ||
From: yaro at opti dot su
Operating system: Windows Server 2008 R2
PHP version: 7.2.6
Package: MySQLi related
Bug Type: Bug
Bug description:Slow MySQL perfomance via named pipe
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 bug report at https://bugs.php.net/bug.php?id=76442&edit=1
--
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=76442&r=trysnapshot54
Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=76442&r=trysnapshot55
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=76442&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=76442&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=76442&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=76442&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=76442&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=76442&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=76442&r=support
Expected behavior: https://bugs.php.net/fix.php?id=76442&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=76442&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=76442&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=76442&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=76442&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=76442&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=76442&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=76442&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=76442&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=76442&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=76442&r=mysqlcfg