Page 1 of 1

XAMPP Apache/MySQL connection fails on heavy loads

PostPosted: 26. June 2007 10:17
by edwardberlin
1. after a new installation of XAMPP on Windows XP on two computers this script gets an error:
<?php
for ($i=0; $i<10000; $i++){
$mysqli = new mysqli('localhost','root','admin');
$mysqli->select_db('applicationDevelop');
$result = $mysqli->query("SELECT * FROM test");
echo $i. "<br>";
$result->close();
$mysqli->close();
}
?>

error:
.
.
.
3890
3891
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2003): Can't connect to MySQL server on 'localhost' (10048) in C:\xampp\htdocs\application\testGetError.php on line 9

2. on another (third) computer we installed Apache/PHP/MySQL manually (instructions here: http://tanguay.info/web/tutorial.php?id ... evelopment) and this script always works fine without errors, hence I assume the above error has something to do with the xampp settings somewhere.

3. I can also use my apache on the third computer and use the mysql server on one of the xampp machine and it WORKS which tells me it has nothing to do with the mysql server itself but with the apache settings (Timeout, KeepAlive, mysql.connect_timeout, etc.) but all of these are the same as on the computer that works.

4. I also tried using both mysql.dll and mysqli.dll and both get the same error on those two machines.

Does anybody have any idea which settings in xampp could be causing the connection to fail on even on localhost on heavy loads?

Thanks,

Edward Tanguay
All my projects: http:://www.tanguay.info