I am developing a site using PHP with Dreamweaver MX and connecting to a MySQL db on a Red Hat (linux). After so many hits to my site I get funky errors like Warning: Too many connections in /home/virtual/siteXX/fst/var/www/html/Connections/domain_name.php on line X Too many connections.
Yes, I understand that each page that is loaded is starting a connection but at the end of each page Dreamweaver MX releases it by doing a
for each recordset.PHP Code:mysql_free_result($recordset);
We had success with our code for a over 6 months but all of a sudden after a upgrade to the box we keep getting this and our fix is to stop and restart the MySQL server ever so often.
Do we have a setting we need to change? I thought PHP would handle the closing the connection automatically? If this is wrong then Dreamweaver MX has a flaw in its code.
Thanks for any advice anyone can provide on this issue.




Reply With Quote