To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here
MySQL, too many connections - using mysqli and PHP5
I'm developing a system in PHP5 with the new mysqli extension. After a while of developing I got an error saying MySQL had too many connections - I checked and they were all in the status of 'Sleep'. I restarted the MySQL server and added code into my script to close the DB connections (good practice anyways I know, but technically PHP should close connection at the end of the script execution). The same problem with too many connections still occurs.
Is this something to do with mysqli or PHP5 or... ?
Location: Rapid Offensive Unit "Foreign Object Damage"
Posts: 19,128
Have you tried any of the suggestions for MySQL and PHP4 that have been made in these forums before?
__________________
On two occasions I have been asked [by Members of Parliament], "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
You can still use the regular (and arguably more stable) mysql extensions with higher versions. I personally build PHP5 against MySQL 5.0a on one of my boxes and it doesn't complain.
One thing you might want to keep in mind though... on the very same pages of the manual (yes, I have already read it, but thanks for quoting it anyway ), it also states that the MySQLi extension is experimental. Usually when I see words like that, I don't expect stuff to work perfectly.
MySQL, too many connections - using mysqli and PHP5
), it also states that the MySQLi extension is experimental. Usually when I see words like that, I don't expect stuff to work perfectly.
Linear Mode
