Bug #51909 [Fbk->NoF]: mysqli hangs after small request storms.

Edit report at https://bugs.php.net/bug.php?id=51909&edit=1 ID: 51909 Updated by: johannes@php.net Reported by: ixti at member dot fsf dot org Summary: mysqli hangs after small request storms. -Status: Feedback +Status: No Feedback Type: Bug Package: MySQLi related Operating System: Debian GNU/Linux PHP Version: Irrelevant Assigned To: mysql Block user comment: N Private report: N Previous Comments: ------------------------------------------------------------------------ [2010-08-18 17:21:02] johannes@php.net Please try the latest snapshot from http://snaps.php.net ------------------------------------------------------------------------ [2010-05-26 15:10:14] ixti at member dot fsf dot org 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(); } ------------------------------------------------------------------------ [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 :)) ------------------------------------------------------------------------ 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 https://bugs.php.net/bug.php?id=51909 -- Edit this bug report at https://bugs.php.net/bug.php?id=51909&edit=1