Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- running out of mysql-connections
June 26, 2007, 7:47 am
rate this thread
ten seconds. The PHP-file connects to a mysql-database, make a short query,
and then close the connection, before it returns the info to the swf.
$mysqli = mysqli_connect($dbhost, $dbusername, $dbuserpassword,
$default_dbname, $port); //open connection
$number = getNumber(); //the function makes a query, and return a number
mysqli_close($mysqli); // closing connection
echo "&number=$number"; // returns the number to yhe swf
The problem is that it seems like the mysqli-connection will not close from
time to time. I have a limitation of 1000 connections, which should be
enough really. But if I run the flash-file for hours (say 8 hours), the
limitation of 1000 OPEN connection is reached, even if I was hoping there
should only be ONE open connection at a time.
Any suggestions why this problem appear?
Re: running out of mysql-connections
There is some info in the MySQL documentation on port timeouts in
windows. If you are running Windows, you should read under B.184.108.40.206: