running out of mysql-connections

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I'm having a flash-file (swf) which is requesting info from a PHP-file every  
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.

Like this:
$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?

// ojorus  

Re: running out of mysql-connections

Quoted text here. Click to load it

The wait timeout for mysql is 3600 seconds by default. Decrease it if you

Re: running out of mysql-connections

pritaeas wrote:
Quoted text here. Click to load it

There is some info in the MySQL documentation on port timeouts in
windows. If you are running Windows, you should read under B.

Best regards,
Willem Bogaerts

Application smith
Kratz B.V.

Site Timeline