#30666 [Opn->Bgs]: mysql_connect reports unable to connect after numerous requests

ID: 30666 Updated by: derick@php.net Reported By: eugene dot kharkov at videinfra dot com -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: W2K Pro, Win XP Pro,Win 2003 Srv PHP Version: 4.3.9 New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. You're probably out of mysql connections. Previous Comments: ------------------------------------------------------------------------ [2004-11-02 20:31:12] eugene dot kharkov at videinfra dot com Description: ------------ I executed a simple script on Windows and Linux platforms. I used Apache Jmeter to simulate server load (5 concurrent connections per second to each platform). In both cases I used the same MySQL server. Settings in php.ini file on both platforms were the same. After a number of requests, script on Windows platform started responding Can't connect to MySQL server on '10.0.1.4' (10048), whereas script on Linux continue its work. Reproduce code: --------------- <? $conn = mysql_connect ( '10.0.1.4', 'root', '') or die("Could not connect: " . mysql_error()); mysql_select_db('lub2', $conn); $res = mysql_query("SELECT title FROM pages_lv0 WHERE id = 1", $conn) or die("Invalid query: " . mysql_error()); mysql_close($conn); echo "ok"; ?> ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30666&edit=1