XAMPP Apache/MySQL connection fails on heavy loads

Problems with the Windows version of XAMPP, questions, comments, and anything related.

XAMPP Apache/MySQL connection fails on heavy loads

Postby edwardberlin » 26. June 2007 10:17

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
edwardberlin
 
Posts: 1
Joined: 26. June 2007 10:03

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 54 guests