Bug #51909 [Opn]: mysqli hangs after small request storms.

Edit report at http://bugs.php.net/bug.php?id=51909&edit=1 ID: 51909 User updated by: ixti at member dot fsf dot org Reported by: ixti at member dot fsf dot org Summary: mysqli hangs after small request storms. Status: Open Type: Bug Package: MySQLi related Operating System: Debian GNU/Linux PHP Version: Irrelevant Assigned To: mysql New Comment: I can prepare a screencast with showing process of stroming and some statisctics information (e.g. top). Alternatively you can test script provided in bug report with simple request stormer - I can prepare such in PHP if you want. Basically it can be with pecl_http: $url = 'http://localhost/mysqli.php'; $r = new HttpRequest($url, HttpRequest::METH_GET); for ($i = 0; $i < 256; $i++) { $r->send(); } Previous Comments: ------------------------------------------------------------------------ [2010-05-26 15:02:39] ixti at member dot fsf dot org Normally CPU usage is low. It raises up upon rapid continiously requests. By "hanging" I mean that after some amount of requests with stormer provided in discussion it becomes completely impossible to connect to MySQL (at least wth MySQLi) so any attempt to connect to MySQL with MySQLi adapter fails. Here's example that I was met: After I have stormed mysqli.php test script with 130 requests it started to tell that it can't connect to database. BUT. Even phpMyAdmin started tell me the same. While I was able to connect via CLI mysql tool. After all rebooting apache2 helps. If you need I can try to gather more additional information on my current PHP (with latest snapshot of PHP there is no such problem at all) ------------------------------------------------------------------------ [2010-05-26 14:47:42] andrey@php.net What do you mean by hanging? You have Apache workers that don't return and still process some data? Is the CPU usage high? ------------------------------------------------------------------------ [2010-05-26 09:33:41] ixti at member dot fsf dot org Please let me know if you want more information from me. I'm running Debian GNU/Linux "testing" with some "sid" mixins :)) But the bug (as you can see in the discussion) was first reproduced on FreeBSD :)) ------------------------------------------------------------------------ [2010-05-26 00:55:30] ixti at member dot fsf dot org above ------------------------------------------------------------------------ [2010-05-26 00:54:20] ixti at member dot fsf dot org Hello, I have tested it against latest snapshot and it wokred fine. Here's my configuration: PHP Version 5.3.3-dev System: Linux msi-s300 2.6.30-2-686 #1 SMP Fri Dec 4 00:53:20 UTC 2009 i686 Build Date: May 26 2010 00:21:01 mysqli MysqlI Support: enabled Client API library version: 5.1.46 PS I have tested against latest snapshot using PHP as CGI module (while error was met on 5.3.2 used as Apache 2.0 Handler) PPS On latest snapshot version mysqli_free_result($result); from test script started producing a warning: mysqli_result::close() ... Couldn't fetch mysqli_result in /var/www/mysqli.php on line 16 ------------------------------------------------------------------------ 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/bug.php?id=51909 -- Edit this bug report at http://bugs.php.net/bug.php?id=51909&edit=1