Re: mysqli_connect fails under load(mysqlnd)

[Andrey Hristov]

  Hi Amir,
Amir Hardon wrote:
> Hi, we decided to test mysqlnd and installed 5.0.1-beta, on one of our
> production servers (LAMP environment).

5.0.1-beta is pretty old version. mysqlnd is already in php-5.3-dev. You 
can get a snapshot from http://snaps.php.net for testing purposes. If 
you are limited to 5.2, then it's possible to extract mysqlnd from a 5.3 
version, together with ext/mysqli, and build it in a 5.2 tree.

> On our development environment it looked like it's working good, and passed
> all QA tests (which were also done on the staging environment).
> But when we directed real traffic to that server mysqli_connect started
> acting weirdly:
> On some of the requests, it failed (returned false), while
> mysqli_connect_error() returned an empty string,
> and mysli_connect_errno() returned 0(zero).

I think I corrected such a weirdness of mysqli_connect_error being zero. 
I think it was an streams problem, from outside mysqlnd's world, in the 
PHP code. In this case recent 5.3 snapshot should work.

> 
> I tried testing it under load with ab(apache benchmark), but couldn't
> reproduce the error.
> Tried directing real traffic to this server again, and got the same errors.
> 
> If you think I might be doing something wrong, please elaborate,
> if it's a bug and I can give you some more data I'll be happy, just keep in
> mind that I can keep this server out of the load balancer only for 12 more
> hours, so after that if it won't work, I'll have to roll back to the
> previous state without mysqlnd.
> 
> Thanks!
> 

Thank you for testing mysqlnd!

Andrey
-- 
Andrey Hristov, Connectors Software Developer
Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering