ID: 41350 Comment by: bkeene at whisolutions dot nospamplease dot com Reported By: graham at directhostinguk dot com Status: No Feedback Bug Type: MySQL related Operating System: Windows 2003 PHP Version: 5.2.6 Assigned To: scottmac New Comment:
It looks like the system automatically closed out this ticket, but it is still an issue. I have commented out every extension in my PHP5.2.6 installation with the exception of the php_mysql.dll OR php_mysqli.dll and still experience the problem. Running php.exe -v on a windows 2003 box STILL takes 5 seconds. I happened to locate a previous version of php5.1.6 (Aug 23 2006) and used that version of the libmysql.dll and the delay ceases. At a minimum, could a valid, previous version of the libmysql.dll be bundled with the installation so that the command line versions of PHP can function correctly? Also, I never experienced this issue with MySQL when running PHP scripts served by Apache 2.2 as a module (not CGI). Previous Comments: ------------------------------------------------------------------------ [2008-06-20 01:00:00] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2008-06-19 11:50:13] Computer dot Pers at gmail dot com So mysql dll from 5.2.1 cures the problem... Where i can take php 5.2.1 (or this dll)??? there no any live links in google... ------------------------------------------------------------------------ [2008-06-12 08:44:56] [EMAIL PROTECTED] This was a change by MySQL, not by PHP. We simply bundle the latest version of MySQL, if you use PHP 5.2.2 with the libmysql.dll you will see the issue. They're looking at other changes to try and solve an issue where every new thread needs to call mysql_thread_init() which isn't ideal. Until then either use the non-thread-safe version of PHP or downgrade your libmysql.dll ------------------------------------------------------------------------ [2008-06-11 21:33:47] paul at orac dot clara dot co dot uk At last, someone seems to have a clue: http://bugs.mysql.com/bug.php?id=25621 http://bugs.mysql.com/bug.php?id=37226 ------------------------------------------------------------------------ [2008-06-11 21:20:31] paul at orac dot clara dot co dot uk Brand new install of Win XP, with IIS (5.1). Installed PHP 5.2.6 (IIS set to use PHP in CGI mode not ISAPI). MySQL is NOT installed on the machine. The only version of libmysql.dll anywhere is the one supplied with php (version 5.00.51a). With either or both of "extension=php_mysql.dll" or "extension=php_mysqli.dll" enabled, running "php-cgi -v" results in the 5 second delay about 25% of the time (5 times out of 20 - very repeatable). The same happens running a browser to a local web page containing just a call to phpinfo(). With both the extension lines commented, the problem does not occur, ever. Running "php -v" I never see the problem occur, ever, even with the extensions enabled. Replacing libmysql.dll with the one from php 5.2.1 (version 5.00.22) causes the above 5 second delay to disappear in ALL cases. The first version of libmysql.dll that caused the problem was that supplied with php 5.2.2. Surely it can't be too hard to start back with those two versions and work out what changed between them? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/41350 -- Edit this bug report at http://bugs.php.net/?id=41350&edit=1
