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
New Comment:
Shortened URL of discussion thread: http://bit.ly/aNDeW4
Previous Comments:
------------------------------------------------------------------------
[2010-05-25 22:26:17] ixti at member dot fsf dot org
Description:
------------
The problem is that MySQLi completely hangs after a small storm of
requests. I
have prepared a sample script (attached into bug report) with SQL script
used to
create and populate table (see http://gist.github.com/413635). I also
used dummy
http client written in ruby to storm it with requests. After ~ 130
requests
proceded one after another MySQLi completely hangs out and stops working
until
Apache2 is restarted. I was tested same storming with pdo_mysql and it
was
working like a charm (more than 1024 continiously repeated requests).
This bug was found upon discussing strange problem in zend Framework
mailing
list. Please refer to discussion for more details:
http://zend-framework-
community.634137.n4.nabble.com/Saving-many-Zend-Db-Table-Rows-in-for-loop-
td2220281.html
Test script:
---------------
<?php
$host = 'localhost';
$user = 'user';
$pass = 'pass';
$name = 'test';
header('Content-Type: text/plain');
$mysqli = mysqli_connect($host, $user, $pass, $name);
if ($result = $mysqli->query('SELECT * FROM my_table')) {
while ($obj = $result->fetch_object()) {
echo $obj->id . ' - ' . $obj->title . PHP_EOL;
}
mysqli_free_result($result);
$result->close();
}
$mysqli->close();
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=51909&edit=1