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

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 2016 ~ 40 msec for mysqli_connect() - Windows Server 2016 ~ 16 msec for mysqli_query() php v7.2.5 x64, mysql v5.7.22 x64, VC14.13.26020 Previous Comments: ------------------------------------------------------------------------ [2018-06-10 10:50:32] yaro at opti dot su Additional info: - Windows Server 2008 R2 ~ 15 msec for mysqli_query() - Windows Server 2012 R2 ~ 1 msec for mysqli_query() ------------------------------------------------------------------------ [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