ID:               41350
 Comment by:       Computer dot Pers at gmail dot com
 Reported By:      graham at directhostinguk dot com
 Status:           Feedback
 Bug Type:         MySQL related
 Operating System: Windows 2003
 PHP Version:      5.2.6
 Assigned To:      scottmac
 New Comment:

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...


Previous Comments:
------------------------------------------------------------------------

[2008-06-12 08:44:56] scottmac@[...].net

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?

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

[2008-06-09 11:47:13] Computer dot Pers at gmail dot com

OK.
I've upgraded PHP to latest 5.2.6
Message: "Error in my_thread_global_end(): 1 threads didn't exit"
is disappeared.

but delay of 5 seconds is here.
I've disabled ALL plugins and there's no any delay.
1. Then i've enabled "extension=php_mysql.dll"
2. i've created script, which shows curent time before and after "php
-v" commnad and launched it several times
here is result:

1. No delay
C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5> phpinfo.bat
09.06.2008 14:33:16
PHP 5.2.6 (cli) (built: May  2 2008 18:02:07)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
09.06.2008 14:33:16

2. Delay
C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5> phpinfo.bat
09.06.2008 14:33:18
PHP 5.2.6 (cli) (built: May  2 2008 18:02:07)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
09.06.2008 14:33:23

3. No delay
C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5> phpinfo.bat
09.06.2008 14:33:26
PHP 5.2.6 (cli) (built: May  2 2008 18:02:07)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
09.06.2008 14:33:26

4. No delay
C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5> phpinfo.bat
09.06.2008 14:33:28
PHP 5.2.6 (cli) (built: May  2 2008 18:02:07)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
09.06.2008 14:33:28

5. No delay
C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5> phpinfo.bat
09.06.2008 14:33:29
PHP 5.2.6 (cli) (built: May  2 2008 18:02:07)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
09.06.2008 14:33:29

6. No delay
C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5> phpinfo.bat
09.06.2008 14:33:30
PHP 5.2.6 (cli) (built: May  2 2008 18:02:07)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
09.06.2008 14:33:30

7. Delay
C:\Program Files\SWsoft\Plesk\Additional\PleskPHP5> phpinfo.bat
09.06.2008 14:33:31
PHP 5.2.6 (cli) (built: May  2 2008 18:02:07)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
09.06.2008 14:33:36

.........
1 of 3 or 4 times i see a delay of 5 secs.
and this is on a machine Intel Xeon E5335 @2Ghz 4Gb Ram at Idle state

MySql for test reason was STOPPED.

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

[2008-06-09 10:55:35] scottmac@[...].net

First you need 5.2.6 and secondly you need to check for old
libmysql.dll files lurking around in your path, I can't reproduce this
with MySQL 5.0.51.

Can you reproduce this when you disable all extensions and just enable
MySQL? If you start enabling extensions which one causes the problem?

On phpinfo() what version of libmysql does it show?

If you don't have PHP 5.2.6 and MySQL 5.0.51 or newer then please
upgrade before you consider replying.

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

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