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

From: 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

« previous php.bugs (#215579) next »